public void LoadAccountInfo() { pnlAccountInfo.Visible = true; pnlButtons.Visible = true; pnlNamesMove.Visible = true; if ((lstAccounts.SelectedValue != null)&&(lstAccounts.SelectedValue != "")) { Top25Account account = new Top25Account(int.Parse(lstAccounts.SelectedValue)); txtAccountName.Text = account.AccountName; txtContact.Text = account.Contact; txtPhone.Text = account.Phone; txtLocations.Text = account.Locations.ToString(); txtClosedRMR.Text = account.ClosedRMR.ToString("0.##;-0.##;0"); txtClosedRSS.Text = account.ClosedRSS.ToString("0.##;-0.##;0"); txtRMR_10.Text = account.RMR_10.ToString("0.##;-0.##;0"); txtRSS_10.Text = account.RSS_10.ToString("0.##;-0.##;0"); txtRMR_50.Text = account.RMR_50.ToString("0.##;-0.##;0"); txtRSS_50.Text = account.RSS_50.ToString("0.##;-0.##;0"); txtRMR_90.Text = account.RMR_90.ToString("0.##;-0.##;0"); txtRSS_90.Text = account.RSS_90.ToString("0.##;-0.##;0"); } else { if(User.IsInRole(Database.EmployeeType.SalesManager.ToString())) { // make account info invisible if sales manager pnlAccountInfo.Visible = false; pnlButtons.Visible = false; pnlNamesMove.Visible = false; } else { this.ClearForm(); } } }
public int SaveAccount(Top25Account account) { string status = ""; switch (account.Status) { case AccountStatus.Approved: status = "A"; break; case AccountStatus.Pending: status = "P"; break; case AccountStatus.Updated: status = "U"; break; } SqlParameter[] prams = {this.MakeInParam("@intAccountID", SqlDbType.Int, 4, account.AccountID), this.MakeInParam("@intEmployeeID", SqlDbType.Int, 4, account.EmployeeID), this.MakeInParam("@dtmMonth", SqlDbType.DateTime, 8, account.Month), this.MakeInParam("@strAccountName", SqlDbType.VarChar, account.AccountName.Length, account.AccountName), this.MakeInParam("@strContact", SqlDbType.VarChar, account.Contact.Length, account.Contact), this.MakeInParam("@intLocations", SqlDbType.Int, 4, account.Locations), this.MakeInParam("@strPhone", SqlDbType.VarChar, account.Phone.Length, account.Phone), this.MakeInParam("@mnyClosedRMR", SqlDbType.Money, 8, account.ClosedRMR), this.MakeInParam("@mnyClosedRSS", SqlDbType.Money, 8, account.ClosedRSS), this.MakeInParam("@mnyRMR_10", SqlDbType.Money, 8, account.RMR_10), this.MakeInParam("@mnyRSS_10", SqlDbType.Money, 8, account.RSS_10), this.MakeInParam("@mnyRMR_50", SqlDbType.Money, 8, account.RMR_50), this.MakeInParam("@mnyRSS_50", SqlDbType.Money, 8, account.RSS_50), this.MakeInParam("@mnyRMR_90", SqlDbType.Money, 8, account.RMR_90), this.MakeInParam("@mnyRSS_90", SqlDbType.Money, 8, account.RSS_90), this.MakeInParam("@charStatus", SqlDbType.Char, 1, status), this.MakeOutParam("@intNewAccountID", SqlDbType.Int, 4)}; this.RunProc("sp_SaveAccount", prams); return (int)prams[1].Value; }
public void DeleteAccount(Top25Account account) { SqlParameter[] prams = {this.MakeInParam("@intAccountID", SqlDbType.Int, 4, account.AccountID)}; this.RunProc("sp_DeleteAccount", prams); }
protected void btnClose_Click(object sender, System.EventArgs e) { if ((lstAccounts.SelectedValue != null)&&(int.Parse(lstAccounts.SelectedValue) > 0)) { Top25Account account = new Top25Account(int.Parse(lstAccounts.SelectedValue)); string NotifyAction = "CLOSED"; Database data = new Database(); data.QueueNotification(account.EmployeeID, account.AccountID, account.AccountName, account.Month, NotifyAction); account.Close(); ClearForm(); BuildAccountsMenu(); BuildMoveMenu(); data.Close(); data.Dispose(); } else { lblMessage.Text = "You must select an account to delete."; lblMessage.Visible = true; return; } }
protected void btnSave_Click(object sender, System.EventArgs e) { Top25Account account; string NotifyAction = ""; if((lstAccounts.SelectedValue != "")&&(int.Parse(lstAccounts.SelectedValue) > 0)) { account = new Top25Account(int.Parse(lstAccounts.SelectedValue)); if(User.IsInRole(Database.EmployeeType.SalesManager.ToString())) { account.Status = AccountStatus.Approved; // managers can ony approve } else { if (account.Status == AccountStatus.Approved) { // if pending, or updated - status does not change account.Status = AccountStatus.Updated; // if approved, changes to updated NotifyAction = "UPDATED"; } } } else if (!User.IsInRole(Database.EmployeeType.SalesManager.ToString())) // managers can not create accounts { if (lstAccounts.Items.Contains(lstAccounts.Items.FindByText(txtAccountName.Text))) // if an account with this name already exists for this month, you can't add it { lblMessage.Text = "Account already exists for this month."; lblMessage.Visible = true; return; } else { account = new Top25Account(); account.EmployeeID = User.EmployeeID; account.Status = AccountStatus.Pending; NotifyAction = "CREATED"; } } else { return; } account.Month = ForecastMonth; account.AccountName = txtAccountName.Text; account.Contact = txtContact.Text; account.Phone = txtPhone.Text; if((txtLocations.Text != null)&&(txtLocations.Text != "")) { account.Locations = int.Parse(txtLocations.Text); } account.ClosedRMR = Utils.GetDecimal(txtClosedRMR.Text); account.ClosedRSS = Utils.GetDecimal(txtClosedRSS.Text); account.RMR_10 = Utils.GetDecimal(txtRMR_10.Text); account.RSS_10 = Utils.GetDecimal(txtRSS_10.Text); account.RMR_50 = Utils.GetDecimal(txtRMR_50.Text); account.RSS_50 = Utils.GetDecimal(txtRSS_50.Text); account.RMR_90 = Utils.GetDecimal(txtRMR_90.Text); account.RSS_90 = Utils.GetDecimal(txtRSS_90.Text); account.Save(); if (NotifyAction != "") { Database data = new Database(); data.QueueNotification(account.EmployeeID, account.AccountID, account.AccountName, account.Month, NotifyAction); notify.SendNotificationQueue(); data.Close(); data.Dispose(); } ClearForm(); BuildEmployeesMenu(); BuildAccountsMenu(); BuildMoveMenu(); LoadAccountInfo(); }
protected void btnMove_Click(object sender, System.EventArgs e) { if((lstAccounts.SelectedValue != "")&&(int.Parse(lstAccounts.SelectedValue) > 0) &&(lstMoveTo.SelectedValue != "")) { Top25Account account = new Top25Account(int.Parse(lstAccounts.SelectedValue)); account.Month = Convert.ToDateTime(lstMoveTo.SelectedValue); account.Save(); ClearForm(); BuildAccountsMenu(); LoadAccountInfo(); } }