public void LoadAddPointsDetailView() { using (LoyaltyPointSystemEntities db = new LoyaltyPointSystemEntities()) { var list = from f in db.Customers.ToList() //join e in db.Applicants.ToList() on f.ApplicationID equals e.ApplicationID where (f.ID == CustomerID) select new { f.Name, f.Surname, f.ID_No, f.Gender.GenderName, f.Email, f.DateCreated, f.Cell_No, f.ID, }; AddPointsCustomerDetailsView.DataSource = list; AddPointsCustomerDetailsView.DataBind(); } }
public void LoadGrid() { using (LoyaltyPointSystemEntities db = new LoyaltyPointSystemEntities()) { var list = from f in db.Employees.ToList() //join e in db.Applicants.ToList() on f.ApplicationID equals e.ApplicationID //where (f.DAO_Approval == false && f.DM_Approval == false && f.ApplicationTypeID == 2) select new { f.Name, f.Surname, f.ID_No, f.Gender.GenderName, f.Email, f.CellPhone, f.EmployeeRole.RoleName, f.Employee_No, f.Username, f.ID, }; gvStaff.DataSource = list; gvStaff.DataBind(); } }
public void UpdateCustomer() { LoyaltyPointSystemEntities db = new LoyaltyPointSystemEntities(); CustomerBL Cusbl = new CustomerBL(); Models.Customer Custb = new Models.Customer(); var data = db.Customers.ToList().FirstOrDefault(x => x.ID == CustomerID); double points = 0; if (Convert.ToDecimal(txtTotalAmount.Text) == 100) { points = double.Parse("10", CultureInfo.InvariantCulture); Custb.Loyalty_Points = (decimal)points; } else if (Convert.ToDecimal(txtTotalAmount.Text) == 1000) { points = double.Parse("100", CultureInfo.InvariantCulture); Custb.Loyalty_Points = (decimal)points; } else if (Convert.ToDecimal(txtTotalAmount.Text) < 100) { points = double.Parse("1", CultureInfo.InvariantCulture); Custb.Loyalty_Points = (decimal)points; } else if (Convert.ToDecimal(txtTotalAmount.Text) > 1000) { points = double.Parse("150", CultureInfo.InvariantCulture); Custb.Loyalty_Points = (decimal)points; } Cusbl.UpdateCustomer(Custb); }
public List <EmployeeRole> LoadRole() { // this is the load method, its returns everything from the Register table where IsDeleted = false using (LoyaltyPointSystemEntities db = new LoyaltyPointSystemEntities()) { return(db.EmployeeRoles.ToList()); } }
public List <Club> loadClubs() { // this is the load method, its returns everything from the Register table where IsDeleted = false using (LoyaltyPointSystemEntities db = new LoyaltyPointSystemEntities()) { return(db.Clubs.ToList()); } }
public void CreateEmployeeRole(Models.EmployeeRole model) { using (LoyaltyPointSystemEntities db = new LoyaltyPointSystemEntities()) { Models.EmployeeRole role = new Models.EmployeeRole(); role.RoleName = model.RoleName; db.EmployeeRoles.Add(role); } }
public void CreateGender(Models.Gender model) { using (LoyaltyPointSystemEntities db = new LoyaltyPointSystemEntities()) { Models.Gender ger = new Models.Gender(); ger.GenderName = model.GenderName; db.Genders.Add(ger); } }
public void UpdateCustomer(Models.Customer model) { using (LoyaltyPointSystemEntities db = new LoyaltyPointSystemEntities()) { var cus = db.Customers.ToList().FirstOrDefault(x => x.ID == model.ID); cus.ID = model.ID; cus.Loyalty_Points = model.Loyalty_Points; db.SaveChanges(); } }
public void SaveCustomerPurchase() { //string www= labbbbb.Text; CustomerPurchaseBL busEmp = new CustomerPurchaseBL(); using (LoyaltyPointSystemEntities db = new LoyaltyPointSystemEntities()) { Models.Customer_Purchase cusP = new Models.Customer_Purchase(); string s = txtTotalAmount.Text; cusP.Date = DateTime.Now; cusP.CustomerID = CustomerID; cusP.RecieptNo = txtRecieptNo.Text; double fee = double.Parse(txtTotalAmount.Text, CultureInfo.InvariantCulture); cusP.TotalPrice = (decimal)fee; cusP.RecieptDate = DateTime.Now; //cusP.RecieptDate = Convert.ToDateTime(txtReieptDate.Text.ToString("dd/m/yyyy")); double points = 0; if (Convert.ToDecimal(txtTotalAmount.Text) == 100) { points = double.Parse("10", CultureInfo.InvariantCulture); cusP.LoyaltyPoints = (decimal)points; } else if (Convert.ToDecimal(txtTotalAmount.Text) == 1000) { points = double.Parse("100", CultureInfo.InvariantCulture); cusP.LoyaltyPoints = (decimal)points; } else if (Convert.ToDecimal(txtTotalAmount.Text) < 100) { points = double.Parse("1", CultureInfo.InvariantCulture); cusP.LoyaltyPoints = (decimal)points; } else if (Convert.ToDecimal(txtTotalAmount.Text) > 1000) { points = double.Parse("150", CultureInfo.InvariantCulture); cusP.LoyaltyPoints = (decimal)points; } busEmp.CreateCustomerPurchase(cusP); } }
public void CreateCustomerPurchase(Models.Customer_Purchase model) { using (LoyaltyPointSystemEntities db = new LoyaltyPointSystemEntities()) { Models.Customer_Purchase CusPur = new Models.Customer_Purchase(); CusPur.Date = model.Date; CusPur.CustomerID = model.CustomerID; CusPur.EmployeeID = model.EmployeeID; CusPur.LoyaltyPoints = model.LoyaltyPoints; CusPur.TotalPrice = model.TotalPrice; CusPur.RecieptDate = model.RecieptDate; CusPur.RecieptNo = model.RecieptNo; db.Customer_Purchase.Add(CusPur); } }
public void SaveCustomer() { CustomerBL busEmp = new CustomerBL(); using (LoyaltyPointSystemEntities db = new LoyaltyPointSystemEntities()) { Models.Customer emp = new Models.Customer(); emp.GenderID = Convert.ToInt16(ddlGender.SelectedValue); emp.ID_No = txtIDNumber.Text; emp.Name = txtName.Text; emp.Surname = txtSurname.Text; emp.Cell_No = txtCellPhoneNO.Text; emp.Email = txtEmail.Text; busEmp.CreateCustomer(emp); } }
protected void GenerateQrScan() { using (LoyaltyPointSystemEntities db = new LoyaltyPointSystemEntities()) { var data = db.Customers.ToList().FirstOrDefault(x => x.ID == CustomerID); string code = data.ID_No + data.Name + data.Surname; QRCodeGenerator qrGenerator = new QRCodeGenerator(); QRCodeData qrCodeData = qrGenerator.CreateQrCode(code, QRCodeGenerator.ECCLevel.Q); QRCode qrCode = new QRCode(qrCodeData); System.Web.UI.WebControls.Image imgBarCode = new System.Web.UI.WebControls.Image(); imgBarCode.Height = 150; imgBarCode.Width = 150; using (Bitmap bitMap = qrCode.GetGraphic(20)) { using (MemoryStream ms = new MemoryStream()) { bitMap.Save(ms, System.Drawing.Imaging.ImageFormat.Png); byte[] byteImage = ms.ToArray(); imgBarCode.ImageUrl = "data:image/png;base64," + Convert.ToBase64String(byteImage); } PlaceHolder1.Controls.Add(imgBarCode); //EmailBL EML = new EmailBL(); //EML.Email("You have successfully Registered for Loyalty Points: " + data.Name + " " + data.Surname, "Dear" + data.Name // + "<br/> <br/>" // + "This is your QrScan :" + "< img src = " + imgBarCode + " >" + "<br/>" + // "Your application has been Approve. " + "<br/>" + // "<br/>" + "This is an automatically generated email. Please do not reply. " + // "<br/> <br/>" + "For more details feel free to call us on 031 455 4576." + "<br/> <br/>" + // "Regards" + "<br/>" + // "Loyalty Point", data.Email, "Loyalty Point", "*****@*****.**"); } } }
public void CreateCustomer(Models.Customer model) { using (LoyaltyPointSystemEntities db = new LoyaltyPointSystemEntities()) { Models.Customer cus = new Models.Customer(); cus.Cell_No = model.Cell_No; cus.DateCreated = model.DateCreated; cus.Email = model.Email; cus.GenderID = model.GenderID; cus.ID_No = model.ID_No; cus.Loyalty_Points = model.Loyalty_Points; cus.Name = model.Name; cus.Surname = model.Surname; db.Customers.Add(cus); db.SaveChanges(); } }
public void sendEmail() { using (LoyaltyPointSystemEntities db = new LoyaltyPointSystemEntities()) { EmailBL EML = new EmailBL(); EML.Email("Status Notification for Reference No: " + "refNo", "Dear Applicant" + "<br/> <br/>" + "Your Reference is :" + "refNo" + "<br/>" + "Your application has been Approve. " + "<br/>" + "<br/>" + "This is an automatically generated email. Please do not reply. " + "<br/> <br/>" + "For more details feel free to call us on 031 455 4576." + "<br/> <br/>" + "Regards" + "<br/>" + "Ethekwini Municipality", "*****@*****.**", "Ethekwini Municipality", "*****@*****.**"); } }
public void CreateEmployee(Models.Employee model) { using (LoyaltyPointSystemEntities db = new LoyaltyPointSystemEntities()) { Models.Employee emp = new Models.Employee(); emp.Employee_No = model.Employee_No; emp.GenderID = model.GenderID; emp.ID_No = model.ID_No; emp.Name = model.Name; emp.Surname = model.Surname; emp.Password = model.Password; emp.RoleID = model.RoleID; emp.Username = model.Username; emp.Email = model.Email; emp.CellPhone = model.CellPhone; emp.ClubName = model.ClubName; emp.IsDeleted = false; db.Employees.Add(emp); db.SaveChanges(); } }
public void SaveEmployee() { EmployeeBL busEmp = new EmployeeBL(); using (LoyaltyPointSystemEntities db = new LoyaltyPointSystemEntities()) { Models.Employee emp = new Models.Employee(); emp.RoleID = Convert.ToInt16(ddlEmployeeRole.SelectedValue); emp.Employee_No = GetEmployeeNo(); emp.GenderID = Convert.ToInt16(ddlGender.SelectedValue); emp.ID_No = txtIDNumber.Text; emp.Name = txtName.Text; emp.Password = txtPassword.Text; emp.Surname = txtSurname.Text; emp.Username = txtEmail.Text; emp.CellPhone = txtCellPhoneNO.Text; emp.Email = txtEmail.Text; emp.ClubName = ddlLoungeName.SelectedItem.Text; busEmp.CreateEmployee(emp); } }
public void UpdateRedeemPointsCustomer() { LoyaltyPointSystemEntities db = new LoyaltyPointSystemEntities(); CustomerBL Cusbl = new CustomerBL(); Models.Customer Custb = new Models.Customer(); var data = db.Customers.ToList().FirstOrDefault(x => x.ID == CustomerID); Custb.ID = data.ID; double points = 0; if (data.Loyalty_Points > 0) { if (Convert.ToDecimal(txtAmountToBeDeducted.Text) == 100) { if (data.Loyalty_Points >= 10) { points = double.Parse("10", CultureInfo.InvariantCulture); Custb.Loyalty_Points = data.Loyalty_Points - (decimal)points; } else { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Insufficient Points')", true); } } else if (Convert.ToDecimal(txtAmountToBeDeducted.Text) == 1000) { if (data.Loyalty_Points >= 100) { points = double.Parse("100", CultureInfo.InvariantCulture); Custb.Loyalty_Points = data.Loyalty_Points - (decimal)points; } else { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Insufficient Points')", true); } } else if (Convert.ToDecimal(txtAmountToBeDeducted.Text) < 100) { if (data.Loyalty_Points >= 1) { points = double.Parse("1", CultureInfo.InvariantCulture); Custb.Loyalty_Points = data.Loyalty_Points - (decimal)points; } else { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Insufficient Points')", true); } } else if (Convert.ToDecimal(txtAmountToBeDeducted.Text) > 1000) { if (data.Loyalty_Points >= 150) { points = double.Parse("150", CultureInfo.InvariantCulture); Custb.Loyalty_Points = data.Loyalty_Points - (decimal)points; } else { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Insufficient Points')", true); } } } else { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('You don't have points to Redeem')", true); } Cusbl.UpdateCustomer(Custb); }
protected void btnLogin_Click(object sender, EventArgs e) { using (LoyaltyPointSystemEntities db = new LoyaltyPointSystemEntities()) { string username = txtUsername.Text; string password = txtPassword.Text; var user = db.Employees.ToList().FirstOrDefault(x => x.Username == username && x.Password == txtPassword.Text.Trim()); if (user != null) { Session["UserId"] = user.ID; //Decrypt password Session["UserName"] = user.Username; Session["UserRole"] = user.RoleID; Session["Name"] = user.Name; //Session["UserId"] = user.UserId; // string dencryptedPassword = business.Decrypt(user.Password); var pass = db.Employees.ToList().FirstOrDefault(x => x.Username == username && x.Password == txtPassword.Text.Trim()); if (password == pass.Password) { //Store user login details in Session Session["UserName"] = user.Username; //Session["UserRole"] = user.RoleID; Session["UserId"] = user.ID; Session["Name"] = user.Name; if (user.RoleID == 1) { Session["UserRole"] = "General Employee"; Response.Redirect("~/Views/ViewAllCustomers.aspx?"); } else if (user.RoleID == 2) { Session["UserRole"] = "Administrator"; Response.Redirect("~/Views/ViewAllCustomers.aspx?"); } else if (user.RoleID == 3) { Session["UserRole"] = "Supervisor"; Response.Redirect("~/Views/ViewAllCustomers.aspx?"); } else { lblErrorMessage.Visible = true; lblErrorMessage.Text = "The password provided is incorrect."; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Please enter Correct UserName and Password!')", true); } } else { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Please enter Correct UserName and Password!')", true); } } else { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Please enter Correct UserName and Password!')", true); } } }