Comments by TheBigBearNow (Top 77 by date)

My websockets are almost 'ALWAYS' running. I do have a stopcapture button but it doesnt get clicked often because I dont want it off. Its a trading bot that runs and captures all incoming data. I need to record all incoming data which are trades. I would like to record all the incoming data but i dont know how often i should save it to a table. and which method to use to save it. Addnewinconingtradeasync shows all the incoming data on a listview. my stopcapture just currently shuts off the websocket. Right now my code almost works. It saves all data to a database but when i click stopcapture then turn it back on it saves the whole datatable again creating duplicate rows. I would like to know is this a good way i have it setup?

So I made a log file to see if it would help me understand these double trades.
Here is what i found out. A normal log on top and the duplicate next.
06/04/2020 4:39:50 In ExecuteTradeTaskV3 Start
06/04/2020 4:39:50 Price Valid B1
06/04/2020 4:39:50 StopBuyV2 - before TradeClient call
06/04/2020 4:39:50 Trade Client - StopOrderBuy Start
06/04/2020 4:39:50 Trade Client - StopOrderBuy API Start
06/04/2020 4:39:51 Trade Client - StopOrderBuy API After
06/04/2020 4:39:52 Trade Client - StopOrderBuy End
06/04/2020 4:39:52 StopBuyV2 - end of method()
06/04/2020 4:39:52 B1 - After StopBuyV2 returned
06/04/2020 4:40:27 In ExecuteTradeTaskV3 Start
06/04/2020 4:40:41 In ExecuteTradeTaskV3 Start
06/04/2020 4:41:28 In ExecuteTradeTaskV3 Start
06/04/2020 4:41:28 Price Valid B1
06/04/2020 4:41:28 Price Valid B1
06/04/2020 4:41:28 StopBuyV2 - before TradeClient call
06/04/2020 4:41:29 StopBuyV2 - before TradeClient call
06/04/2020 4:41:29 Trade Client - StopOrderBuy Start
06/04/2020 4:41:29 Trade Client - StopOrderBuy Start
06/04/2020 4:41:29 Trade Client - StopOrderBuy API Start
06/04/2020 4:41:29 Trade Client - StopOrderBuy API Start
06/04/2020 4:41:29 Trade Client - StopOrderBuy API After
06/04/2020 4:41:29 Trade Client - StopOrderBuy API After
06/04/2020 4:41:30 Trade Client - StopOrderBuy End
06/04/2020 4:41:30 StopBuyV2 - end of method()
06/04/2020 4:41:30 B1 - After StopBuyV2 returned

Some bad new everyone.. It's not fixed it does it even less now but a double trade happened. Back to the drawing board...

Yes

You guys are correct if it happens again I have no idea..
I would like to have a solution where this does not happen.
If I remove my try-catch block if an exception happens wouldnt my program break then?

That sounds like an awesome solution would you give me a lil example of what you mean ?

Ill try to break it up. I have an idea instead of calling my method in the thread I can have the thread set a bool to true and in a separate thread I can call the method one time if its true. I'm new with multi threading applications I currently have a thread getting Trade History, my GUI WPF Thread, a TradeStatus Thread after a trade is executed, and I had this ExecuteTrade Thread.

I need it to continuously check a condition and if the condition is met, then do the method 1 time. The condition is checking a price that is changing every second.
Currently my ExecuteTradeTask() is doing all of that. But id say 90% it executes only 1 time like its supposed to. But every so often itll execute 2-3 times which cant happen because using real money doing a trade more than 1 time is not good.

The first page works correctly.
The page with the same action name as the view works on all the pageination links
The only ones that dont work is the action that calls the view the view and loads it with a custom set of data when i click the pagination link for that one the 2nd page is empty

This almost solved my problem I feel but it still didnt work.. My project does not refresh on the button click + tempdata msg dont display. Here is my code.

[HttpPost]
        //[ValidateAntiForgeryToken]
        public ActionResult RemoveAdmin(string userid)
        {
            ApplicationUser au = context.Users.Where(u => u.Id.Equals(userid,
                StringComparison.CurrentCultureIgnoreCase)).FirstOrDefault();
            var store = new UserStore<ApplicationUser>(context);
            var manager = new UserManager<ApplicationUser>(store);
            
            manager.RemoveFromRole(au.Id, "Admin");
            manager.AddToRole(au.Id, "User");
            if (Request.IsAjaxRequest())
            {
                TempData["SuccessRole"] = "Role Removed Successfully";
                Json(Url.Action("AssignAdmin"));
                return RedirectToAction("AssignAdmin", "SuperAdmin");
            }
            
            //TempData["Success"] = "Roles Assigned Successfully";
            return RedirectToAction("AssignAdmin");
        }
 function clickMe() {
        var userid = $("#userAdmins").val();
        if (userid != "") {
            $.ajax({
                url: "RemoveAdmin/SuperAdmin",
                data: {
                    userid: userid
                },
                type: "POST",
                success: function (result) {
                    window.location.assign(result);
                }
                //error: function () {
                //    alert("Error");
                //}
            });

I put the var dump in the store method
and nothing happened
If I insert a row manually then the row appears in my index and I get can get and show the row with the correct data in my show view. Only I cannot update and create it. I can also delete a record successfully

like this

$contact = new Contact([
'first_name' => var_dump($request->get('first_name')),

Thank you. I did not know this is my first shopping cart with paypal so i should use the PHP integration of making the createOrder object and put the fields in on that side
This is the paypal integration
https://www.paypal.com/sdk/js?client-id=

I got everything working how I wanted to. I am just subtracting 2 arrays the initial value and the array of how many used.
The only question i have it what can i do if there is not even in the initial value. so the number is 0 or a negative. How can I solve that issue. That is all I have left. With an if statement ?
This is code i use to do the solving

 public static void Countsolve(int amount, int[] arraycount)
        {
            int[] cash = { 100, 50, 20, 10, 5, 1 };
            int[] bcounter = { 0, 0, 0, 0, 0, 0 };

            for(int i = 0; i < 6; i++)
            {
                if(amount >= cash[i])
                {
                    counter[i] = amount / cash[i];
                    amount -= bcounter[i] * cash[i];
                }
            }
            for(int x=0; x<arraycount.Length; x++)
            {
                arraycount[x] = arraycount[x] - bcounter[x];
            }

"
I need to so something with arraycount IF < 0 then print "..." in console

Thank you skydiver
That helped explaining alot to me.

Now I have a new question.
I have an array of the amount of bills I have to be used.
I am subtracting a bill each time i use one.
my 100s are working but when I go to the next bill the remainder is wrong so i cant move on here is some of the stuff i tried..

public static void countbills(int amount, int[] bills, int[] billsCount)
        {
            int remainder = amount;
            int billIterator = 1;
            for(int i = 0; i < billsCount.Length; i++)   // while(remainder > 0)
            {
                //if(remainder >= bills[billIterator])  //{  if(billsCount[])  }
                if (remainder >= bills[i])
                {
                    if (billsCount[i] != 0)
                    {
                        billsCount[i]--;
                        remainder -= bills[billIterator];//bills[i] * billsCount[billIterator];
                        billIterator++;
                        //= bills[i];//amount / bills[i];     //remainder -= counts[bill] * dollarSizes[bill]; //reminder = amount % cashBills[billrem];
                        //amount -= billsCount[i] * bills[i];
                        //billsCount[i]--;
                    }
                }
            }
        }

I am getting the users input and Ill get a number and I want to minus the number of bills that were used to make that amount and to keep track.

Quick question to set the spot in an array each value why is my spot not able to assign a position?

       public static int[] Reset( int[] billsRefill)
        {
            //int[] cashRefill = { 10, 10, 10, 10, 10, 10 };
            foreach(int spot in billsRefill)
            {
                spot = 10;
            }
            return billsRefill;
        }

I ended up going with a different direction

My remainder was adding 10 to the amount after it got down to 8 for some odd reason. So I switched to a for loop with the amount of kind of bills being used and an if to minus the amount left. Now I got this working properly. So onto the next steps keeping track.
Thank you

So this is what I have come up with and it has done everything right except for I did a value of 258 and it gave me a ten with the other correct values. It just gave me a extra 10 but everything else I tried worked..

        public static int[] MakeChange(int amount)
        {
            int[] cashBills = { 100, 50, 20, 10, 5, 1 };
            int[] billCounts = { 0, 0, 0, 0, 0, 0 };

            int billrem = 0;    //bill=0
            int reminder = amount;  //remainder
            while(reminder > 0)
            {

                billCounts[billrem] = reminder / cashBills[billrem];

                reminder = amount % cashBills[billrem];
                billrem++;
            }
            return billCounts;
        }

So basically like what I have make a money class like I did and how i have this

HundredDollarBill = cash / 100;
            cash %= 100;

And I can use an array or list to keep track of money.hundbill => 10 ?
Could I get a little example I think I am understanding what you mean but if I see it then for 1 bill ill know if I am understanding it right

My project does create read and delete but when i do update I DO NOT get an update. It refreshes the page and does not update and does not go to header()

What i needed to do what return false on each validation instead of isvalid = false because it was overwriting it at the end.

Thank you so much for finding that mistake! I would not have caught that. BUT My function is still returning VALID even when it is INVALID... I am stepping through it and the boolean invalid = false happens so I dont understand why on the if(validregister()) it returns TRUE ?

I did not copy all the code I know i didnt copy the '}'
I am only worried about the validation function

Moving index-- and index++ to the beginning fixed that issue.

I know it has something to do with the placement of my "index--"

Now I found an error array index undefined. How can I have it so when i click the btn and its at index 0 it wont go to -1 but i need to be able to click the btn to do index-- to view the next slot in the array.

$("#back").click(function() {
      if (index < 0) {
          index = 0;
      } else {
         var first = arr[index];
         $("#sec2").html('<h5>'+first.id+'</h5>');
         index--;
     }
  });

I got it all figured out im not sure why I was having such troubles last night lol probably was just tired and not thinking clearly. It was actually pretty easy when I took time and thought about it.
[code]
$("#back").click(function() {
if (index < 0) {
index = 0;
}
var first = arr[index];
$("#sec2").html('

'+first.id+'

');
index--;
});
[/code]

In the button click

$("#back").click(function() {
      //var s = arr[index];
      var first = arr.first();
      //$("#sec2").innerHTML(<span>first</span>);
  })

using var first = arr.first(); to select index[0] in the array and with $("#sec2").innerHTML(first); not being able to display the element on the page

Yes I know I asked this... This is my problem..

In my switch case is there a way i could have the case go off of id or something..

I have :

$(":input").blur(function () {
let controlType = this.type;

switch (controlType) {
case "text":
case "password":


My email textbox is type="text"
I want one of the cases to somehow link that specific type=text textbox to a different case So i could have it go to my method I made for validating email.

This works! But now i have 1 small thing left. I want to exclude '0' So if it selects 0 from my list I want it to go to the next smallest number.
min cannot be 0

How do I invoke report progress from dowork()?

Application.Current.Dispatcher.Invoke(delegate
17
    {
18
        backgroundWorker.ReportProgress(); //but what do i pass in and not sure if this is it
19
    });

Thank you! i got it working exactly how i wanted with what you said.

Does this look like im using it correctly?

        public static int CreateReceipt(int userid, decimal rtotal, DateTime rdate)
        {
            int result = -1;
            using(SqlConnection connection = ConnectionString.GetSqlConnection())
            {
                string sqlCreate = "INSERT INTO Orders(UserId, ReceiptDate, ReceiptTotal) " +
                                               "VALUES(@uid, @date, @rtotal)";
                using(SqlCommand cmdCreate = new SqlCommand(sqlCreate, connection))
                {
                    //cmdCreate.Parameters.AddWithValue("@rid", receipt.ReceiptID);
                    cmdCreate.Parameters.AddWithValue("@uid", userid);
                    cmdCreate.Parameters.AddWithValue("@date", rdate);
                    cmdCreate.Parameters.AddWithValue("rtotal", rtotal);
                    try
                    {
                        connection.Open();
                        string sqlSELECT = "SELECT @@IDENTITY FROM Orders";
                        cmdCreate.ExecuteNonQuery();
                        SqlCommand cmdSelect = new SqlCommand(sqlSELECT, connection);
                        result = Convert.ToInt32(cmdSelect.ExecuteScalar());

                    }
                    catch(Exception ex) { throw ex; }
                }                
            }
            return result;
        }

I am going to try that right now I have seen @@identity before but never understood it

Hey everyone sorry for the late response. I ended up using a List<product> which worked but i only got it to be loaded in the field. I am trying to populate a property of List<product> so i can use databinding but i did the List.Add() and nothing was added to my property.

//no longer using my 4 seperate lists because all fields are in my product class.
        private List<Product> listOfP = new List<Product>();
        public List<Product> Cart => new List<Product>();

        public ShoppingCart(Customer c, List<Product> listprod)
        {
            InitializeComponent();
            customer = c;
 
            listOfP = listprod;
            CreateCart(listOfP);
            PopulateListViewCart();
        }
 
private void CreateCart(List<Product> lcart)
        {
  
            //Cart.Add(selectedProduct);
            foreach(Product product in listOfP)
            {
                Cart.Add(product);
            }
        }

This property is not being filled with my listofP but my listofP has the correct items.

public static Product ReadProductById(int prodId)
{
Product product = new Product();

using(SqlConnection connection = ConnectionString.GetSqlConnection())
{
string query = "SELET * " +
"FROM Products " +
"WHERE ProductId = @pid";
using(SqlCommand cmdRead = new SqlCommand(query, connection))
{
cmdRead.Parameters.AddWithValue("@pid", prodId);
using(SqlDataReader reader = cmdRead.ExecuteReader())
{
if (reader != null)
{
while (reader.Read())
{
Product product2 = new Product()
{
ProductId = Convert.ToInt32(reader["ProductId"]),
ProductName = reader["ProductName"].ToString(),
ProductPrice = Convert.ToDecimal(reader["ProductPrice"]),
ProductListedDate = Convert.ToDateTime(reader["ProductListedDate"]),
ProductTax = Convert.ToDecimal(reader["ProductTax"]),
UserId = Convert.ToInt32(reader["UserId"]),
ProductQuantity = Convert.ToInt32(reader["ProductQuantity"]),
ProductTotal = Convert.ToDecimal(reader["ProductTotal"]),
ProductPurchasedDate = Convert.ToDateTime(reader["ProductPurchasedDate"]),
ReceiptId = Convert.ToInt32(reader["ReceiptId"])
};
product = product2;
}
}
else { product = null; }
}
}
}
return product;
}


is what i am going to try.

Yes im getting a null reference error about can not enter duplicate unique id into the database.
Im trying a couple different ideas i have and if that dont work i might try the boolean (flag) idea you put on my other post because that may work on this same problem i am having i could set the flag in the constructor and i could just skip the addCustomer if my database field is set to true.

In EF it looks like i have to of state.added or create and state.modified for update like :

[code]
public void CreatePerson(Person person)
{
if(person != null)
{

framework.People.Add(person);
framework.Entry(person).State = System.Data.Entity.EntityState.Added;
framework.SaveChanges();
}
}
[/code]

That worked exactly like you said to do! Now the database adds the new records while the project is running and i can update them and everything BUT now when i close the project NOTHING IS SAVED. everytime i restart the project it starts from the beginning. The project works and saves while running but then when i restart to keepp adding on it always starts over and does not save what i did?
thank you if you have any input

TRIED LOTS of different techniques to try to get the entity framework to load on the product load()

Thank you! I made a separate class US_States like you have and under that class at the bottom i made a public static class StatesArray
and in the statesarray class in the constructor I have
states.Add(new US_State("WY", "Wyoming"));
and this at bottom
public static US_State[] AllFiftyStates()
{
return states.ToArray();
}
I can make this in WPF window
private List<us_state> Get_States = StatesArray.states;
and combobox { Binding Get_States }

is that all correct?

do i want to put
"private List<us_state> usStates;
public List<us_state> USStates
{
get
{
return usStates;
}
set
{
usStates = value;
RaisePropertyChanged();
}
}"

in my WPF window? or does that go in US_State class as well
I have the class made like you
im just not sure if i should make a new List<us_state> in my WPF window or if i should use that property

Thankyou !!
Is there an easy way to bind this to a combo box using IEnumerable and INotifyChange
[code]
public class US_State
{
public string Name { get; set; }

public string Abbreviations { get; set; }

public US_State()
{
Name = null;
Abbreviations = null;
}

public US_State(string ab, string name)
{
Name = name;
Abbreviations = ab;
}

public override string ToString()
{
return string.Format("{0} - {1}", Abbreviations, Name);
}
}
//STATIC ARRAY CLASS WHICH CONTAINS ALL THE STATE DATA.
public static class StateArray
{
static List<us_state> states;

static StateArray()
{
states = new List<us_state>(50);
states.Add(new US_State("AL", "Alabama"));
states.Add(new US_State("AK", "Alaska"));
states.Add(new US_State("AZ", "Arizona"));
states.Add(new US_State("AR", "Arkansas"));
states.Add(new US_State("CA", "California"));
states.Add(new US_State("CO", "Colorado"));
states.Add(new US_State("CT", "Connecticut"));
states.Add(new US_State("DE", "Delaware"));
states.Add(new US_State("DC", "District Of Columbia"));
states.Add(new US_State("FL", "Florida"));
states.Add(new US_State("GA", "Georgia"));
states.Add(new US_State("HI", "Hawaii"));
states.Add(new US_State("ID", "Idaho"));
states.Add(new US_State("IL", "Illinois"));
states.Add(new US_State("IN", "Indiana"));
states.Add(new US_State("IA", "Iowa"));
states.Add(new US_State("KS", "Kansas"));
states.Add(new US_State("KY", "Kentucky"));
states.Add(new US_State("LA", "Louisiana"));
states.Add(new US_State("ME", "Maine"));
states.Add(new US_State("MD", "Maryland"));
states.Add(new US_State("MA", "Massachusetts"));
states.Add(new US_State("MI", "Michigan"));
states.Add(new US_State("MN", "Minnesota"));
states.Add(new US_State("MS", "Mississippi"));
states.Add(new US_State("MO", "Missouri"));
states.Add(new US_State("MT", "Montana"));
states.Add(new US_State("NE", "Nebraska"));
states.Add(new US_State("NV", "Nevada"));
states.Add(new US_State("NH", "New Hampshire"));
states.Add(new US_State("NJ", "New Jersey"));
states.Add(new US_State("NM", "New Mexico"));
states.Add(new US_State("NY", "New York"));
states.Add(new US_State("NC", "North Carolina"));
states.Add(new US_State("ND", "North Dakota"));
states.Add(new US_State("OH", "Ohio"));
states.Add(new US_State("OK", "Oklahoma"));
states.Add(new US_State("OR", "Oregon"));
states.Add(new US_State("PA", "Pennsylvania"));
states.Add(new US_State("RI", "Rhode Island"));
states.Add(new US_State("SC", "South Carolina"));
states.Add(new US_State("SD", "South Dakota"));
states.Add(new US_State("TN", "Tennessee"));
states.Add(new US_State("TX", "Texas"));
states.Add(new US_State("UT", "Utah"));
states.Add(new US_State("VT", "Vermont"));
states.Add(new US_State("VA", "Virginia"));
states.Add(new US_State("WA", "Washington"));
states.Add(new US_State("WV", "West Virginia"));
states.Add(new US_State("WI", "Wisconsin"));
states.Add(new US_State("WY", "Wyoming"));
}

public static string[] Abbreviations()
{
List<string> abbrevList = new List<string>(states.Count);
foreach (var state in states)

thank you! that is precisely what I needed to hear and see that is where my issues lies I will figure out the correct code to fix this!

thank you
I have it working somewhat now. just took away customer with login switched back to user and going to look into it so i can use my customer properties in my later screens. I am still learning. Could you take a quick look at these classes is this how i should have it?
thanks again. P.S. how do i [code][/code] in these comments?

[code]
//My USER class
public class User
{
//IMPLEMENTING/UPDATING C# CODE TO VERSION 7.0.
//create UserID property
private int _userId;
public int UserID
{
get => _userId; //get { return _userId; }
set => _userId = value; //set { _userId = value; }
}
//create username property
private string _username;
public string Username
{
get => _username; //get { return username; }
set => _username = value; //set { _username = value; }
}
//create password property
private string _password;
public string Password
{
get => _password; //get { return _password; }
set => _password = value; //set { _password = value; }
}
//create isAdmin property
private bool _isAdmin;
public bool IsAdmin
{
get => _isAdmin; //get { return _isAdmin; }
set => _isAdmin = value; //set { _isAdmin = value; }
}
//Creating a new property thought of this while creating the Database.
//create UserCreatedDate property
private DateTime _userCreatedDate;
public DateTime UserCreatedDate
{
get => _userCreatedDate; //get { return _userCreatedDate; }
set => _userCreatedDate = value; //set { _userCreatedDate = value; }
}

//Default Constructor for User class
public User() { }

//Constructor without UserId (USED FOR CREATING NEW USER)
public User(string uname, string pass, bool isadmin, DateTime userDate)
{
Username = uname;
Password = pass;
IsAdmin = isadmin;
UserCreatedDate = userDate;
}
//Constructor with UserId (USED FOR UPDATING CURRENTLY SELECTED USER)
public User(int id, string uname, string pass, bool isadmin, DateTime userDate)
{
UserID = id;
Username = uname;
Password = pass;
IsAdmin = isadmin;
UserCreatedDate = userDate;
}
//Constructor for UPDATE and to keep orginal DateCreated ~~(UPDATE: DON'T THINK I NEED)~~11/2/18~
public User(string uname, string pass, bool isadmin)
{
Username = uname;
Password = pass;
IsAdmin = isadmin;
}
//MY CUSTOMER CLASS
public class Customer : User
{
//Properties for the newly created Customer class. V 7.0
//CustomerId Property Foreign key of UserID.
//private int _customerId;
//public int CustomerId
//{
// get => _customerId;
// set => _customerId = value;
//}
////First name property.
//private string _firstname;
//public string FirstName
//{
// get => _firstname;
// set => _firstname = value;
//}

// ~ SWITCHING OVER TO USE AUTO-IMPLEMENTED PROPERTIES ~
//CustomerId Property inherits/foreign key of UserId.
public int CustomerId { get; set; }

//FirstName Property.
public string FirstName { get; set; }

//LastName Property.
public string LastName { get; set; }

//Address Property.
public string Address { get; set; }

//City Property.
public string City { get; set; }

//State Property.
public string State { get; set; }

//Zip Code Property.
publ

Ok what would i do to fix this error?
In userlogin create another loginmethod one for Customer and keep mine for User or just return customer in loginmethod instead of user because my customer will inherit all the user properties and also have its own customer properties.
I tried code like this but then i get a nullreference error just like you said because no allocated memory here.
[code]
Customer CastUser = loginUser as Customer;
Window nonAdmin = new CustomerScreen(CastUser);
[/code]

What do i do to upcast with
[code]c = (Customer) u;[/code]

because YES this is exactly what the issue is.
You have it dead on.

Here is UserLogin
User class is just a class with Username password id property and customer just adds on a few properties like firstname etc..

I think i understand what you are getting at because Yes Login does return a User not a Customer i will try to figure it out otherwise.
In the debugger it gets the correct user and i put that user in the next screen and cast it into a customer i take a user object in CustomerScreen and in the constructor i cast that specific user object over to a Customer.
[code]
public static User UserLogin(string username, string password)
{
//SQL Login Query.
string SQLloginQuery = "SELECT * FROM Users WHERE Username=@username AND Password=@password";
SqlCommand cmdLogin = new SqlCommand(SQLloginQuery, connection);
cmdLogin.Parameters.AddWithValue("@username", username);
cmdLogin.Parameters.AddWithValue("@password", password);
try
{
connection.Open();
//int result = (int)cmdLogin.ExecuteScalar();
SqlDataReader reader = cmdLogin.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
User user = new User
{
UserID = Convert.ToInt32(reader["UserId"]),
Username = reader["Username"].ToString(),
Password = reader["Password"].ToString(),
IsAdmin = Convert.ToBoolean(reader["IsAdmin"]),
UserCreatedDate = Convert.ToDateTime(reader["UserCreatedDate"])
};
return user;
}
else
return null;
}
[/code]

I have created this Model and Store - i believe this will work with combo box Store:formatStyleSheet ?
Ext.define('formatStyleSheetModel', {
extend: 'Ext.data.Model',
fields: [
{ name: 'value', type: 'int' },
{ name: 'spreadsheet', type: 'string' },
{ name: 'format', type: 'string' }
]
});

var formatStore = new Ext.data.Store({
model: 'formatStyleSheetModel',
data: [
{ value: 0, spreadsheet: 'Logisticare', format: 'Logisticare', defaultValue: true },
{ value: 1, spreadsheet: 'MTM', format: 'MTM' },
{ value: 2, spreadsheet: 'Access2Care', format: 'Access2Care'}
]
});

now when i have a list of clients i get a dictionary error such as -

Now one issue I have come across is when the list of clients with the same driver and same insurance is long for example 22. The program gives an error about System.Web.Mvc.ViewDataDictionary.

“A first chance exception of type 'System.Collections.Generic.KeyNotFoundException' occurred in System.dll

'iisexpress.exe' (CLR v4.0.30319: /LM/W3SVC/5/ROOT-1-130923551687352717): Loaded 'C:\Windows\assembly\GAC_MSIL\Microsoft.VisualStudio.DebuggerVisualizers\12.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.DebuggerVisualizers.dll'. Cannot find or open the PDB file.”



This only happens when there is a list of clients whenever it is small the excel template opens with no problems.

I tried to do this Options dialog box -> Debugging node -> Symbols with enabling symbols but still crashes.

I have my condition working its like above just changed a little but now i have this problem with the list of clients is bigger then a couple

I believe this may work for me.

Is there a better suggestion?

string insuranceType = Convert.ToString(iType);
string akeString = "";
string logicstr = "";
string bellinStr = "";
if (insuranceType.Length > 2) akeString = insuranceType.Substring(0, 3);
if (insuranceType.Length > 10) logicstr = insuranceType.Substring(0, 11);
if (insuranceType.Length > 10) bellinStr = insuranceType.Substring(0, 11);
if (logicstr == "Logisticare")
{
return TripLogSpreadsheet(results, filterStrs);//logisticare;//
}
else if (akeString.ToUpper() == "ake")
{
return MTMLogSpreadsheet(results, filterStrs);
}
else if (insuranceType == "Bellin")
{
return BellinLogSpreadsheet(results, filterStrs);
}
else
return TripLogSpreadsheet(results, filterStrs);

My issue is my method that GenerateTripLog() wants to return a single value, when I have my ‘if’ condition it will return a value depending on the condition, While the if is being used because the returns are in the if the method throws an error because it says not all paths return a value for the method.

public checkbox is marked
i changed admin account to transit

i user servername : localhost and connect to my local database.
setting up credentials i am not sure.
I just went to security - login and i see 'sa' and i see that my 'WIN-LV74O1VFEK6\Administrator' account is both in the logins under SQL but i am not sure on the rights for these accounts i just see them under login? do i do something more to these besides having them as logins

I am using Sql Server 2012.
I used a .bak file to made a copy of the database. I imported it to the localhost.

when i change the login/username to any combination i do not have the right username.
How do i fix the issue? by giving admin permission to SQL ?

I am only getting 4 Headers not one for every record. I had one of the method calls commented out but then i was getting 0 headers

could you give me an example for passing the id please and thank you.

nope im using C# not asp.net

This project is going all client side so there will be no PHP involved. I suggested the same to my client saying about 10 A.M. ordering online is absurd but she agreed and continued with her choice..

Here is some things i have tried for that so far. right now i have the current time Am or Pm and i have to set a default time of 10 am and compare them possibly with an if statement? right now when i try to set the time to 10 am it is in milliseconds with some HUGE number..

[code]
function determineCutoffTime() {
console.log("cut off time function");
var msg = "To recieve an order the current day it must be played before 10 a.m. of that day.";
//var timeNow = new Date($.now());
//var dd = new Date.now();
// console.log(dd);
//get current time and date if before time accept otherwise show message and allow cancel

// jquery take 2
// var jqueryTime = $.datepicker.formatDate('mm/dd/yy HH:mm:dd');
// console.log(jqueryTime);
// var jtime = new Date().getTime();
//console.log(jtime);

//alert($.datepicker.formatDate('yy/mm/dd', new Date()));
// console.log("date now");
//console.log($.now());
//var myTime = $.now();
// console.log(myTime);
//console.log("dateNow()");
//console.log(dateNow());
//another try this time i will set date/time to 10 am
// var buyingTime = new date();
// buyingTime.setHours(10, 0, 0);
// console.log(buyingTime);
// console.log(new Date.today().toString());

console.log('javascript');
//javascript way
var jsDate = new Date();
var seconds = jsDate.getSeconds();
var minutes = jsDate.getMinutes();
var hours = jsDate.getHours();
var day = jsDate.getDate();
var month = jsDate.getMonth() + 1;
var year = jsDate.getYear();
//var jsTime = jsDate.getHours() + ":" + jsDate.getMinutes() + ":" + jsDate.getSeconds();//getMonth() getDate() getFullYear()
//var jsTime = hours:minutes:seconds month/day/year;
// console.log(hours+":"+minutes+":"+seconds+" "+ month+"/"+day+"/"+year);

//Get current Date and Time
var today = new Date();
var dd = today.getDate(); var mm = today.getMonth() + 1; var yyyy = today.getFullYear();
var hh = today.getHours(); var min = today.getMinutes(); var sec = today.getSeconds();
if (dd < 10) {
dd = '0' + dd;
}
if (mm < 10) {
mm = '0' + mm;
}
if (min < 10) {
min = '0' + min;
}
today = hh + ":" + min + ":" + sec + " " + mm + "/" + dd + "/" + yyyy;
console.log(today);

/////////////////////////////////////////////
var now = new Date();
var nowhrs = now.getHours(); var nowmins = now.getMinutes(); var nowsecs = now.getSeconds();
var determine = (nowhrs >= 12) ? " P.M." : " A.M.";

if (nowhrs == 0) nowhrs = 12;
var timeValue = "" + ((nowhrs > 12) ? nowhrs - 12 : nowhrs);
timeValue += ((nowmins < 10) ? ":0"+nowmins : ":" + nowmins);
timeValue += ((nowsecs < 10) ? ":0"+nowsecs : ":" + nowsecs);
//timeValue += (nowhrs >= 12) ? " P.M." : " A.M.";
timeValue += determine;
console.log(timeValue);
/////////////////////////////////
//cutoff time
var cutoffTime = new Date();
var cutoffDay = cutoffTime.getDate();
var cutoffMonth = cutoffTime.getMonth() + 1;
var cutoffYear = cutoffTime.getFullYear();
var cutoffHours = cutoffTime.setHours(10); var cutoffMins = cutoffTime.setMinutes(00); var cutoffSecs = cutoffTime.setSeconds(00); var cutoffDetermine = " A.M.";
var cutoffTimeValue = cutoffHours + ":" + cutoffMins + ":" + cutoffSecs + cutoffDetermine;
console.log(cutoffTimeValue);
}
[/code]

Also for validation to possibly stop the button from being clicked if there is no filling on the sub sandwich so you cant order a sub with just bread?
I made a validation method and i wanted to return something like onClientClick but i believe that may not be javascript a

I am trying to do validation so the button wont go through if information is invalid
data is going to be imported from a list once i get that far
and my main part i am working on now is i am trying to use javascript/jquery to get the current date and set a time of 10 am of the current day to compare them and see if it is before or after 10 am then i can show a cancel page or continue with the order i have been trying to work on this for awhile and did not figure it out yet
here are some things i have tried
// var jqueryTime = $.datepicker.formatDate('mm/dd/yy HH:mm:dd');
// console.log(jqueryTime);
var jtime = new Date().getTime();
console.log(jtime);

//alert($.datepicker.formatDate('yy/mm/dd', new Date()));
console.log("date now");
//console.log($.now());
//var myTime = $.now();

// console.log(myTime);

//console.log("dateNow()");
//console.log(dateNow());
//another try this time i will set date/time to 10 am
// var buyingTime = new date();
// buyingTime.setHours(10, 0, 0);
// console.log(buyingTime);
// console.log(new Date.today().toString());

console.log('javascript');
//javascript way
var jsDate = new Date();
var seconds = jsDate.getSeconds();
var minutes = jsDate.getMinutes();
var hours = jsDate.getHours();
var day = jsDate.getDate();
var month = jsDate.getMonth() + 1;
var year = jsDate.getYear();
//var jsTime = jsDate.getHours() + ":" + jsDate.getMinutes() + ":" + jsDate.getSeconds();//getMonth() getDate() getFullYear()
//var jsTime = hours:minutes:seconds month/day/year;
console.log(hours+":"+minutes+":"+seconds+" "+ month+"/"+day+"/"+year);

Thank you very much Robin for your time!!
i will be looking at this and working on it after my XML exam today.
Thanks!!!!

I want to auto populate textboxes with the data from phpmyadmin database.
Once the data is in the textboxes then i want to do an update query so i can update the textboxes with the current data that is inserted.
Also i want to be able to add a profile image to each profile

Ok yes i understand exactly what you are saying. That is what i was wanting to do.
So i just create a bunch of rows in my 2nd table and can fill them up as i need them?

Your example is exactly what i am trying to do with my dynamically created fields.
I will create multiple rows in my 2nd table and find a way to loop through my dynamic fields to insert the data in the table.
How to i make the id reference to be the same in the 2nd table.

right now my table 1 automatically creates a id with auto increment.
in my 2nd table i make a row column for id but i am not sure how to set it.

could you give me an example?
for making the rows in the table for multiple numbers if the rows are not already created? im quiet confused with this concept
making spots for the data in the database on the fly...
and how will i find the max id for 1 table if i need to use it as the id in the other table?

how do i make another lap to put another customer in a seat? i am trying to fill up the airplane

anything really i could predefine the combinations in my code or have them set by the user i will have simple combinations like "//" and other combinations that will enter a username and password of multiple accounts with the correct key combination thats what i want this for. I dont mind if i have to hard code it or if i can have the user enter the phrase and key code in seperate text boxes

ok im happy to get help with thinking about these concepts, so i should set my selectedCustomer as a local variable in the delete method? what would you do could i see an lil example?

i gave all my source code, selectedCustomer i set as a global variable to -1 im just not sure how to actually set it to the selected item in the listbox

In CustomerDB im calling my "public static bool DeleteCustomer(Customer customer)" in my DELETE button in CustomerList() window
I go to my listbox and click on a customer then i click delete to delete it but it says i have not selected anything. my listbox isnt noticing my selection on a particular customer and that is my question. I dont know why it doesnt know what i choose. I'm not sure what to do to fix this. I know once i can figure out how to select a item in my listbox i should be able to do my modify fairly easy. Delete and Modify im having the same error. Selecting a customer

My error that i'm currently working on is the DELETE button. when i click on a item in my list-box then click delete it is suppose to delete that selected item. Well instead it says "Index was out of range. Must be non-negative and less than the size of the collection" that is my exception that i get. My database is SQLServerCE with a list of Customers and also the list of Products.

The code i have is a listbox with some buttons ADD DELETE MODIFY AND EXIT. (CustomerList())
when you click ADD it brings up a window with text boxes which is the input form (CustomerAdd())
CustomerDB is all of my database code CRUD