public static void CreateNewUserDashboard(int uid, UserType utype) { //Adds 4 entries to dashboardsettings table to give user default dash items 1 item for customers LINQ_UsersDataContext dc = new LINQ_UsersDataContext(); List<string> DefaultDashItems = ListDashboardItems(utype); if (utype == UserType.AccountCustomer) { DashBoardSetting ds = new DashBoardSetting(); ds.DashBoardNumber = 1; ds.DashBoardItem = DefaultDashItems[2]; ds.UserId = uid; dc.DashBoardSettings.InsertOnSubmit(ds); } else { for (int i = 1; i <= 4; i++) { DashBoardSetting ds = new DashBoardSetting(); ds.DashBoardNumber = i; ds.DashBoardItem = DefaultDashItems[i]; ds.UserId = uid; dc.DashBoardSettings.InsertOnSubmit(ds); } } try { dc.SubmitChanges(); } catch (Exception ex) { Database.WriteException("Error inserting new DashBoardSettings items", uid, "Users.CreateNewUserDashboard", ex); } }
private void UpdateEmail(string eml) { try { LINQ_UsersDataContext de = new LINQ_UsersDataContext(); var userEmail = (from a in de.WebAccounts where a.id == Convert.ToInt32(thisUserId) select a).FirstOrDefault(); if (userEmail != null) { userEmail.Email = eml; de.SubmitChanges(); } } catch (Exception ex) { Database.WriteException("Error updating email to web accounts table. Method: UpdateEmail", Page, HttpContext.Current, ex); } }
private void UpdateAccountRole(int usrid) { string role = ddWebAccountType.SelectedItem.ToString(); LINQ_UsersDataContext dc = new LINQ_UsersDataContext(); var dfd = (from a in dc.WebAccountRoles where a.WebUser == usrid select a).FirstOrDefault(); if (dfd != null) { dfd.RoleId = Users.GetUserChar(role); dc.SubmitChanges(); } }
protected void btnSave_Click(object sender, EventArgs e) { if (hiddenEntityId.Value == "") { Master.SetStatus("Save the record before adding a web user account.", 2); return; } if (isNew) { //string typ = Request.QueryString["type"]; bool iscst = true; if (thisUserType != UserType.AccountCustomer) { iscst = false; } int entVal = Convert.ToInt32(hiddenEntityId.Value); if (Users.IsUsernameTaken(txtUserName.Text)) { Master.SetStatus("User name is taken. Select a new user name",2); return; } //Create new web account user try { LINQ_UsersDataContext dc = new LINQ_UsersDataContext(); WebAccount wa = new WebAccount(); wa.UserName = txtUserName.Text; wa.Password = Users.EncryptPass(txtPassword1.Text); wa.Email = txtEmail.Text; wa.AccountType = Users.GetUserChar(ddWebAccountType.SelectedItem.ToString()); UpdateAccountRole(wa.id); wa.Active = true; wa.CreatedBy = (string)Session["username"]; wa.DateOpen = DateTime.Now; wa.EmailVerified = false; wa.AccountType = Convert.ToChar(userChar); wa.FName = txtFName.Text; wa.LName = txtLName.Text; if (iscst) { wa.Customer = entVal; wa.Account = Users.GetCustomerAccountNumber(entVal); } else { wa.Employee = entVal; wa.Account = Users.GetEmployeeAccountNumber(entVal); } dc.WebAccounts.InsertOnSubmit(wa); dc.SubmitChanges(); Users.CreateNewUserDashboard(wa.id, UserType.AccountCustomer); Users.SetupUserType(wa.id, Convert.ToChar(userChar)); Master.SetStatus("Web account created for " + txtFName.Text + " " + txtLName.Text , 1); } catch (Exception ex) { Database.WriteException("Error adding web account. btnSave_Click", Page, HttpContext.Current, ex); Master.SetStatus("Unable to create web account" , 2); } } else { string new_username = txtUserName.Text; //Validate and then save to DB --- THIS IS ONLY A SAVE FOR THE WEB INFO, NOT THE employee or customer try { if (Users.IsUsernameTaken(new_username) && new_username != Users.GetUserName(thisUserId)) { Master.SetStatus("User name is already taken", 2); return; } LINQ_UsersDataContext dc = new LINQ_UsersDataContext(); var userInfo = (from a in dc.WebAccounts where a.id == Convert.ToInt32(thisUserId) select a).FirstOrDefault(); if (userInfo != null) { if (new_username == "") { throw new NullReferenceException("Change UserName"); } //set vals and update userInfo.FName = txtFName.Text; userInfo.LName = txtLName.Text; userInfo.Email = txtEmail.Text; userInfo.UserName = txtUserName.Text; userInfo.AccountType = Users.GetUserChar(ddWebAccountType.SelectedItem.ToString()); UpdateAccountRole(userInfo.id); dc.SubmitChanges(); Master.SetStatus("Web account user updated", 1); btnSave.Visible = false; btnEditUser.Visible = true; txtUserName.ReadOnly = true; } } catch (Exception ex) { Database.WriteException("Error updating WebUser information. btnSave_Click", Page, HttpContext.Current, ex); Master.SetStatus("Error updating web account information", 2); } } }
private void SetNewValue(int itemnumber, string item) { uid = Variables.NullSafe((int)Session["userid"]); try { LINQ_UsersDataContext db = new LINQ_UsersDataContext(); var dash = (from d in db.DashBoardSettings where d.UserId == uid && d.DashBoardNumber == itemnumber select d).FirstOrDefault(); dash.DashBoardItem = item; db.SubmitChanges(); } catch (Exception ex) { Database.WriteException("Updating dashboard - SetNewValue()", Page, HttpContext.Current, ex); } }
public static void SetupUserType(int uid, char typ) { LINQ_UsersDataContext dc = new LINQ_UsersDataContext(); WebAccountRole ar = new WebAccountRole(); ar.WebUser = uid; ar.RoleId = typ; try { dc.WebAccountRoles.InsertOnSubmit(ar); dc.SubmitChanges(); } catch (Exception ex) { Database.WriteException("Error inserting new webaccount role", uid, "Users.SetupUserType", ex); } }