public int isAdmin(string UserName) { Classes.CUsers cu = new Classes.CUsers(); int UserId = cu.GetUserIdByName(UserName); List <string> Permissions = cu.ParsePermissions(UserId); if (Permissions.Contains("33") || Permissions.Contains("-33") || Permissions.Contains("33-")) { return(1); } return(-1); }
private Dictionary <int, string> ShowAllUsers() { Classes.CUsers cu = new Classes.CUsers(); Dictionary <int, string> Get = new Dictionary <int, string>(); List <Models.MUsers> GetUsers = new List <Models.MUsers>(); GetUsers = cu.GetApprovedUsers(); Get.Add(-1, "Please Select"); for (int i = 0; i < GetUsers.Count; i++) { int Key = Convert.ToInt32(GetUsers[i].id); string Value = GetUsers[i].name; Get.Add(Key, Value); } return(Get); }
protected void Page_Load(object sender, EventArgs e) { Classes.CUsers cu = new Classes.CUsers(); string LoggedInUserId = string.Empty; string FiscalYear = string.Empty; string WareHouseName = string.Empty; LoggedInUserId = Session["User"].ToString(); FiscalYear = ReturnFiscalYear(); int UserId = cu.GetUserIdByName(LoggedInUserId); WareHouseName = ReturnWareHouseName(UserId.ToString()); lblLoggedIn.Text = LoggedInUserId; lblFiscalYear.Text = FiscalYear; lblWareHouse.Text = WareHouseName; menu.InnerHtml = BuildMenu(); }
protected void grdUsers_RowCommand(object sender, GridViewCommandEventArgs e) { Classes.CUsers cu = new Classes.CUsers(); int index = Convert.ToInt32(e.CommandArgument); GridViewRow gvrow = grdUsers.Rows[index]; int userId = Convert.ToInt32(HttpUtility.HtmlDecode(gvrow.Cells[0].Text).ToString()); string userName = HttpUtility.HtmlDecode(gvrow.Cells[1].Text).ToString(); int rc = 0; if (e.CommandName.Equals("approve")) { rc = cu.ApproveUsers(userId); if (rc > 0) { lblError.ForeColor = System.Drawing.Color.Green; ShowMessage("The User[" + userName + "] has been Approved"); BindGrid(); } else { lblError.ForeColor = System.Drawing.Color.Red; ShowMessage("The User[" + userName + "] has not been Approved Kindly refresh the page and try again"); } } else if (e.CommandName.Equals("notapprove")) { if (cu.RejectUsers(userId) > 0) { lblError.ForeColor = System.Drawing.Color.Red; ShowMessage("The User[" + userName + "] has been Rejected"); BindGrid(); } else { lblError.ForeColor = System.Drawing.Color.Red; ShowMessage("The User[" + userName + "] has not been Rejected Kindly Refresh the page and try again"); BindGrid(); } } }
protected void btnSave_Click(object sender, EventArgs e) { Models.MUsers mu = new Models.MUsers(); mu.name = txtuserID.Text; mu.password = txtPassword.Text; Classes.CUsers cu = new Classes.CUsers(); if (cu.Save(mu) < 0) { ShowFailMessage(); } else if (cu.Save(mu) == 2) { lbluser.Text = "UserName [" + txtuserID.Text + "] Already exists"; } else { ShowSuccessMessage(); } }
protected void btnSave_Click(object sender, EventArgs e) { if (ddlEmployees.SelectedValue != "-1" && ddlUsers.SelectedValue != "-1") { Classes.CUsers cu = new Classes.CUsers(); int UserId = Convert.ToInt32(ddlUsers.SelectedValue); int RolesId = Convert.ToInt32(ddlEmployees.SelectedValue); if (cu.AssignRolesToUser(RolesId, UserId) < 0) { ShowMessage("Role Was not assigned please refresh the page!"); } else { ShowMessage("Role assigned successfully!"); } } else { ShowMessage("Please select a proper value of roles/users"); } }
private void BindGrid() { Classes.CUsers cu = new Classes.CUsers(); grdUsers.DataSource = cu.GetUnApprovedUsers(); grdUsers.DataBind(); }
private int ProcessPayments(string PaymentId, string OrderId, string totalCost, string CurrentAmountPaid, string AccountId, float AmountRemaining, string RemainingAmount, string DatePaid, string Type, string Cheque) { if (Page.IsValid) { Classes.CBankOfAccount cba = new Classes.CBankOfAccount(); Classes.CAccountTransaction cat = new Classes.CAccountTransaction(); Classes.CCashAccount cha = new Classes.CCashAccount(); Classes.CCashTransaction cht = new Classes.CCashTransaction(); Classes.CPayment cp = new Classes.CPayment(); Classes.CPaymentLine cpl = new Classes.CPaymentLine(); Classes.CSaleTransations cs = new Classes.CSaleTransations(); Models.MAccountTransaction mat = new Models.MAccountTransaction(); Models.MPayments mp = new Models.MPayments(); Models.PaymentLine mpl = new Models.PaymentLine(); Models.MCashTransactions mht = new Models.MCashTransactions(); Models.MCashAccount mha = new Models.MCashAccount(); #region Payments mp.Paid = (Convert.ToSingle(totalCost) - AmountRemaining).ToString(); if (cp.UpdateAmountPaid(Convert.ToInt32(PaymentId), mp.Paid) < 0) { return(-1); } #endregion #region PaymentLine mpl.PaymentId = Convert.ToInt32(PaymentId); mpl.BankId = Convert.ToInt32(AccountId); mpl.Date = DatePaid; mpl.PaidAmount = CurrentAmountPaid; mpl.RemainingAmount = RemainingAmount; mpl.CumulativeAmount = (Convert.ToSingle(cpl.LastPaidAmount(mpl.PaymentId)) + Convert.ToSingle(CurrentAmountPaid)).ToString(); int OptionValue = Convert.ToInt32(ddlOption.SelectedValue); mpl.Cheque = Cheque; switch (OptionValue) { case -1: { return(-1); } case 1: { #region Account Transactions mpl.ModeOfPayment = Common.Constants.ModeOfPayment.Cheque.ToString(); float AccountTotal = cba.ReturnTotalOfAccountById(Convert.ToInt32(AccountId)); mat.AccountId = AccountId; if (Type.Contains("Vendor")) { mat.Description = "Payment Of Order Id[" + OrderId + "] Paid, Amount [" + CurrentAmountPaid + "]"; mat.Debit = CurrentAmountPaid; mat.Credit = "0"; mat.Total = (AccountTotal - Convert.ToSingle(CurrentAmountPaid)).ToString(); mat.CurrentTransaction = cs.GetIdByOrderId(Convert.ToInt32(OrderId)).ToString(); mat.Transactiontype = "Debit"; mat.FiscalYearId = Session["FiscalYear"].ToString(); mat.eDate = Convert.ToDateTime(DatePaid); } else if (Type.Contains("Client")) { mat.Description = "Payment Of Order Id[" + OrderId + "] Recieved, Amount [" + CurrentAmountPaid + "]"; mat.Debit = "0"; mat.Credit = CurrentAmountPaid; mat.CurrentTransaction = cs.GetIdByOrderId(Convert.ToInt32(OrderId)).ToString(); mat.Total = (AccountTotal + Convert.ToSingle(CurrentAmountPaid)).ToString(); mat.Transactiontype = "Credit"; mat.FiscalYearId = Session["FiscalYear"].ToString(); mat.eDate = Convert.ToDateTime(DatePaid); } else { return(-3); } if (cat.Save(mat) < 0) { return(-4); } if (cba.SetNewAccountTotal(Convert.ToInt32(AccountId), Convert.ToSingle(mat.Total)) < 0) { return(-5); } #endregion break; } case 2: { #region Cash Transaction mpl.ModeOfPayment = Common.Constants.ModeOfPayment.Cash.ToString(); mpl.Cheque = "-"; float AccountTotal = cha.ReturnTotalOfCashAccount(Convert.ToInt32(AccountId)); mht.CashAccountId = Convert.ToInt32(AccountId); if (Type.Contains("Vendor")) { mht.Credit = "0"; mht.Debit = CurrentAmountPaid; mht.Description = "Payment Of Order Id[" + OrderId + "] Paid, Amount [" + CurrentAmountPaid + "]"; mht.eDate = (DatePaid); mht.FiscalYearId = Convert.ToInt32(Session["FiscalYear"].ToString()); mht.OrderId = Convert.ToInt32(OrderId); mht.Total = totalCost; mht.TransactionId = -1; mht.TransactionType = "Debit"; string UserName = Session["User"].ToString(); Classes.CUsers cu = new Classes.CUsers(); string UserId = cu.GetUserIdByName(UserName).ToString(); mht.UserId = Session["User"].ToString(); mht.WareHouseId = Convert.ToInt32(Session["WareHouse"].ToString()); } else if (Type.Contains("Client")) { mht.Credit = CurrentAmountPaid; mht.Debit = "0"; mht.Description = "Payment Of Order Id[" + OrderId + "] Recieved, Amount [" + CurrentAmountPaid + "]"; mht.eDate = (DatePaid); mht.FiscalYearId = Convert.ToInt32(Session["FiscalYear"].ToString()); mht.OrderId = Convert.ToInt32(OrderId); mht.Total = totalCost; mht.TransactionId = -1; mht.TransactionType = "Debit"; string UserName = Session["User"].ToString(); Classes.CUsers cu = new Classes.CUsers(); string UserId = cu.GetUserIdByName(UserName).ToString(); mht.UserId = Session["User"].ToString(); mht.WareHouseId = Convert.ToInt32(Session["WareHouse"].ToString()); } else { return(-3); } if (cht.Save(mht) < 0) { return(-4); } if (cha.SetNewAccountTotal(Convert.ToInt32(AccountId), Convert.ToSingle(mat.Total)) < 0) { return(-5); } #endregion break; } default: return(-1); } if (cpl.Save(mpl) < 0) { return(-2); } #endregion #region Accounts if (Convert.ToSingle(mp.Paid) > 0) { if (Type == "Vendor") { Classes.CJournal cj = new Classes.CJournal(); Models.MJournal mj = new Models.MJournal(); mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.MerchandiseInventory).ToString(); mj.amount = mp.Paid; mj.des = "Payment Recieved of Order id [" + OrderId + "]"; mj.e_date = (DatePaid); mj.type = Common.Constants.Accounts.Type.Debit.ToString(); cj.Save(mj); mj = new Models.MJournal(); mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.AccountsPayable).ToString(); mj.amount = mp.Paid; mj.des = "Payment Recieved of Order id [" + OrderId + "]"; mj.e_date = (DatePaid); mj.type = Common.Constants.Accounts.Type.Credit.ToString(); cj.Save(mj); } else if (Type == "Client") { Classes.CJournal cj = new Classes.CJournal(); Models.MJournal mj = new Models.MJournal(); mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.CostOfGoodsSold).ToString(); mj.amount = mp.Paid; mj.des = "Payment Recieved of Order id [" + OrderId + "]"; mj.e_date = (DatePaid); mj.type = Common.Constants.Accounts.Type.Debit.ToString(); cj.Save(mj); mj = new Models.MJournal(); mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.MerchandiseInventory).ToString(); mj.amount = mp.Paid; mj.des = "Payment Recieved of Order id [" + OrderId + "]"; mj.e_date = (DatePaid); mj.type = Common.Constants.Accounts.Type.Credit.ToString(); cj.Save(mj); cj = new Classes.CJournal(); mj = new Models.MJournal(); mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.AccountsRecievalbes).ToString(); mj.amount = mp.Paid; mj.des = "Payment Recieved of Order id [" + OrderId + "]"; mj.e_date = (DatePaid); mj.type = Common.Constants.Accounts.Type.Debit.ToString(); cj.Save(mj); mj = new Models.MJournal(); mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.Sales).ToString(); mj.amount = mp.Paid; mj.des = "Payment Recieved of Order id [" + OrderId + "]"; mj.e_date = (DatePaid); mj.type = Common.Constants.Accounts.Type.Credit.ToString(); cj.Save(mj); } } #endregion } lblPurchaseAmountRemaining.Text = AmountRemaining.ToString(); lblPurchaseAmountPaid.Text = (Convert.ToSingle(totalCost) - AmountRemaining).ToString(); return(1); }