public void Do_Something(object sender, EventArgs e)
{
string userName = user.Value;
string pwd = thePassword.Text;
string connectionToDB = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\20904\Documents\GitHub\EasyReceipt\EasyReceipts\EasyReceipts\App_Data\testDB.mdf;Integrated Security=True;MultipleActiveResultSets=True;Application Name=EntityFramework";
dbStoredProc createUser = new dbStoredProc(new SqlConnection(connectionToDB));
createUser.Set_COMMAND("prLoginCreate");
createUser.ADD_INPUT_PARAMATER("@user", System.Data.SqlDbType.VarChar, userName, -1);
createUser.ADD_INPUT_PARAMATER("@password", System.Data.SqlDbType.VarChar, pwd, -1);
createUser.ADD_INPUT_PARAMATER("@id", System.Data.SqlDbType.Int, 3);
createUser.EXECUTE_COMMAND();
//ADO.net Reading from DB
//CredentialsEntities erEntities = new CredentialsEntities();
//var query = from value in erEntities.Credentials
// where value.User_Name != " "
// select value.User_Name;
//var shortList = query.ToList();
////lamda exp
//shortList.ForEach(x =>
//{
// ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + x + "');", true);
//});
}
public dbWorkout()
{
db = new dbStoredProc(new SqlConnection(location));
}
public dbQuote()
{
db = new dbStoredProc(new SqlConnection(location));
}