protected void Page_Load(object sender, EventArgs e) { if (Session["userId"] != null) { lblUsername.Text = Session["userId"].ToString(); } else { Response.Redirect("../Index.html"); } if (!IsPostBack) { BindDate(); BindChart(ChartOrderBar, "Select Name,Count(Name) from order_table WHERE OrderBy = 'Customer' GROUP BY Name ORDER BY COUNT(Name) DESC", "Ordered Products"); BindPieChart(ChartOrderPie, "Select Name,Count(Name) from order_table WHERE OrderBy = 'Customer' GROUP BY Name ORDER BY COUNT(Name) DESC"); BindChart(ChartHiredBar, "Select Name,Count(Name) from hired_table GROUP BY Name ORDER BY COUNT(Name) DESC", "Hired Products"); BindPieChart(ChartHiredPie, "Select Name,Count(Name) from hired_table GROUP BY Name ORDER BY COUNT(Name) DESC"); } CricketSystemEntities context = new CricketSystemEntities(); //counting all Orders var countOrdersAll = context.order_table.Count(t => t.OrderBy == "Customer"); lblTotSoldOrders.Text = countOrdersAll.ToString(); //counting all Orders var countHiredAll = context.hired_table.Count(); lblTotHiredOrders.Text = countHiredAll.ToString(); }
protected void btnlnkEstimate_Click(object sender, EventArgs e) { lblRegisterError.Text = ""; lblReturnMessage.Text = ""; lblYouGet.Text = ""; lblYouReturn.Text = ""; if (txtCollectionDate.Text == "") { lblRegisterError.Text = "Please Select collection Date."; } else if (txtQuantity.Text == "") { lblRegisterError.Text = "Please provide Quantity."; } else if (Convert.ToInt32(txtQuantity.Text) < 1) { lblRegisterError.Text = "Quantity cannot be lessthan 1."; } else if (ddlConditon.SelectedIndex == 0) { lblRegisterError.Text = "Please select Conditon type."; } else { CricketSystemEntities context = new CricketSystemEntities(); pawn_table tbl = new pawn_table(); int prod_id = Convert.ToInt32(lblItemId.Text); int userid = Convert.ToInt32(Session["userId"].ToString()); string collectionDate = txtCollectionDate.Text; int Quantity = Convert.ToInt32(txtQuantity.Text); string condition = ddlConditon.SelectedValue; double fee = Convert.ToDouble(txtAmount.Text); double ammountdue = 0; double topay = 0; if (ddlConditon.SelectedIndex == 1) { topay = Quantity * fee * 0.7; ammountdue = topay + (topay * 0.29); } else if (ddlConditon.SelectedIndex == 2) { topay = Quantity * fee * 0.6; ammountdue = topay + (topay * 0.32); } else { topay = Quantity * fee * 0.45; ammountdue = topay + (topay * 0.35); } ammountdue = Math.Round(ammountdue, 2); topay = Math.Round(topay, 2); lblReturnMessage.Text = "The item(s) will be kept for not more than 90 days"; lblYouGet.Text = "Amount you will get R" + topay; lblYouReturn.Text = "Amount you must return R" + ammountdue; } }
public int GetUserId(string username) { using (CricketSystemEntities objUser = new CricketSystemEntities()) { int userId = (from p in objUser.user_table where p.Username == username select p.User_id).FirstOrDefault(); return(userId); } }
public string GetUsername(int userid) { using (CricketSystemEntities objUser = new CricketSystemEntities()) { string username = (from p in objUser.user_table where p.User_id == userid select p.Username).FirstOrDefault(); return(username.ToString()); } }
public int GetProductId(string product, string usertype) { using (CricketSystemEntities objUser = new CricketSystemEntities()) { int productId = (from p in objUser.product_table where p.UserType == usertype && p.Name == product && p.product_purpose == "Hire" select p.Product_id).FirstOrDefault(); return(productId); } }
public int GetProductNo(int productId) { using (CricketSystemEntities objUser = new CricketSystemEntities()) { int purchCount = (from p in objUser.product_table where p.Product_id == productId select p.ProductNo).FirstOrDefault(); return(purchCount); } }
private void LoginUser(string userName, string password) { using (CricketSystemEntities objUser = new CricketSystemEntities()) { if (userName == "" && password == "") { lblLoginError.Text = "Provide Username and Password."; } else { var results = objUser.user_table.Where(v => v.Username == userName && v.Password == password); var count = results.Count(); if (count > 0) { var a = from p in objUser.user_table where p.Username == userName && p.Status == "Active" select p; if (a.Any()) { var role = (from r in objUser.user_table where r.Username == userName select r.User_type).FirstOrDefault(); LoginHistory(userName); if (role == "Admin") { Session["userId"] = GetUserId(userName); Response.Redirect("Admin/Index.aspx"); } else if (role == "Customer") { Session["userId"] = GetUserId(userName); Response.Redirect("Customer/Index.aspx"); } else if (role == "Supplier") { Session["userId"] = GetUserId(userName); Response.Redirect("Supplier/Index.aspx"); } else if (role == "Staff") { Session["userId"] = GetUserId(userName); Response.Redirect("Staff/Orders.aspx"); } } else { lblLoginError.Text = "Your account is currently Deactivated - Please contact us."; } } else { lblLoginError.Text = "User does not exist in our database."; } } } }
private void BindDataUser() { string status = ddlFilterByStatus.SelectedValue; string day = ddlFilterByDate.SelectedValue; CricketSystemEntities context = new CricketSystemEntities(); if (ddlFilterByStatus.SelectedIndex > 0) { //counting all Orders var countOrdersAll = context.order_table.Count(t => t.OrderBy == "Customer" && t.Status == status); lblTotSoldOrders.Text = countOrdersAll.ToString(); //counting all Orders var countHiredAll = context.hired_table.Count(t => t.Status == status); lblTotHiredOrders.Text = countHiredAll.ToString(); BindChart(ChartOrderBar, "Select Name,Count(Name) from order_table WHERE OrderBy = 'Customer' AND Status = '" + status + "' GROUP BY Name ORDER BY COUNT(Name) DESC", "Ordered Products"); BindPieChart(ChartOrderPie, "Select Name,Count(Name) from order_table WHERE OrderBy = 'Customer' AND Status = '" + status + "' GROUP BY Name ORDER BY COUNT(Name) DESC"); BindChart(ChartHiredBar, "Select Name,Count(Name) from hired_table WHERE Status = '" + status + "' GROUP BY Name ORDER BY COUNT(Name) DESC", "Hired Products"); BindPieChart(ChartHiredPie, "Select Name,Count(Name) from hired_table WHERE Status = '" + status + "' GROUP BY Name ORDER BY COUNT(Name) DESC"); } else if (ddlFilterByDate.SelectedIndex > 0) { //counting all Orders var countOrdersAll = context.order_table.Count(t => t.OrderBy == "Customer" && t.Date == day); lblTotSoldOrders.Text = countOrdersAll.ToString(); //counting all Orders var countHiredAll = context.hired_table.Count(t => t.Date == day); lblTotHiredOrders.Text = countHiredAll.ToString(); BindChart(ChartOrderBar, "Select Name,Count(Name) from order_table WHERE OrderBy = 'Customer' AND Date = '" + day + "' GROUP BY Name ORDER BY COUNT(Name) DESC", "Ordered Products"); BindPieChart(ChartOrderPie, "Select Name,Count(Name) from order_table WHERE OrderBy = 'Customer' AND Date = '" + day + "' GROUP BY Name ORDER BY COUNT(Name) DESC"); BindChart(ChartHiredBar, "Select Name,Count(Name) from hired_table WHERE Date = '" + day + "' GROUP BY Name ORDER BY COUNT(Name) DESC", "Hired Products"); BindPieChart(ChartHiredPie, "Select Name,Count(Name) from hired_table WHERE Date = '" + day + "' GROUP BY Name ORDER BY COUNT(Name) DESC"); } else { //counting all Orders var countOrdersAll = context.order_table.Count(t => t.OrderBy == "Customer"); lblTotSoldOrders.Text = countOrdersAll.ToString(); //counting all Orders var countHiredAll = context.hired_table.Count(); lblTotHiredOrders.Text = countHiredAll.ToString(); BindChart(ChartOrderBar, "Select Name,Count(Name) from order_table WHERE OrderBy = 'Customer' GROUP BY Name ORDER BY COUNT(Name) DESC", "Ordered Products"); BindPieChart(ChartOrderPie, "Select Name,Count(Name) from order_table WHERE OrderBy = 'Customer' GROUP BY Name ORDER BY COUNT(Name) DESC"); BindChart(ChartHiredBar, "Select Name,Count(Name) from hired_table GROUP BY Name ORDER BY COUNT(Name) DESC", "Hired Products"); BindPieChart(ChartHiredPie, "Select Name,Count(Name) from hired_table GROUP BY Name ORDER BY COUNT(Name) DESC"); } }
public string getNames(int username) { string names = ""; using (CricketSystemEntities objUser = new CricketSystemEntities()) { names = (from r in objUser.user_table where r.User_id == username select r.Firstname + " " + r.Lastname).FirstOrDefault(); } return(names); }
private void LoginHistory(string username) { CricketSystemEntities context = new CricketSystemEntities(); login_history_table tbl = new login_history_table(); tbl.Username = username; tbl.User_id = GetUserId(username); tbl.DateAndTime = DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString(); context.login_history_table.Add(tbl); context.SaveChanges(); }
private void AddProducts() { CricketSystemEntities context = new CricketSystemEntities(); pawn_product_table tbl = new pawn_product_table(); string fileName = System.IO.Path.GetFileName(FileUploadAdd.FileName); if (txtProductname.Text == "") { lblRegisterError.Text = "Please provide Product name."; } else if (ddlType.SelectedIndex == 0) { lblRegisterError.Text = "Please select product type."; } else if (txtAmount.Text == "") { lblRegisterError.Text = "Please provide product amount."; } else if (FileUploadAdd.FileName == "") { lblRegisterError.Text = "Please select product Image."; } else { //Set the Image File Path. string filePath = "~/Pictures/Products/" + fileName; int userId = Convert.ToInt32(lblUsername.Text); //Save the Image File in Folder. FileUploadAdd.SaveAs(Server.MapPath(filePath)); tbl.Name = UpperCaseFirst(txtProductname.Text); tbl.Product_type = ddlType.SelectedValue; tbl.Amount = Convert.ToDecimal(txtAmount.Text); tbl.Image_url = filePath; context.pawn_product_table.Add(tbl); context.SaveChanges(); lblRegisterError.Text = "Product Added."; lblRegisterError.ForeColor = Color.MidnightBlue; TextBox[] txt = { txtProductname, txtAmount }; for (int i = 0; i < txt.Length; i++) { txt[i].Text = ""; } ddlType.SelectedIndex = 0; } }
public bool IsIdNumberExist(string IdNNumber) { using (CricketSystemEntities dc = new CricketSystemEntities()) { var v = dc.user_table.Where(a => a.IDNumber == IdNNumber).FirstOrDefault(); if (v != null) { return(true); } else { return(false); } } }
public bool IsUsernameExist(string Username) { using (CricketSystemEntities dc = new CricketSystemEntities()) { var v = dc.user_table.Where(a => a.Username == Username).FirstOrDefault(); if (v != null) { return(true); } else { return(false); } } }
public bool IsCellNoExist(string CellNo) { using (CricketSystemEntities dc = new CricketSystemEntities()) { var v = dc.user_table.Where(a => a.Cellno == CellNo).FirstOrDefault(); if (v != null) { return(true); } else { return(false); } } }
public void UpdateStock(int soldnumber, string name) { using (CricketSystemEntities ctx = new CricketSystemEntities()) { var p = (from y in ctx.product_table where y.Name.Equals(name) && y.product_purpose.Equals("Hire") && y.UserType.Equals("Admin") select y) .ToList(); foreach (var x in p) { x.ProductNo = x.ProductNo - soldnumber; ctx.SaveChanges(); } } }
public bool IsEmailExist(string emailID) { using (CricketSystemEntities dc = new CricketSystemEntities()) { var v = dc.user_table.Where(a => a.Email == emailID).FirstOrDefault(); if (v != null) { return(true); } else { return(false); } } }
protected void getPawnProduct() { int prod_id = Convert.ToInt32(lblItemId.Text); using (CricketSystemEntities objUser = new CricketSystemEntities()) { var results = objUser.pawn_product_table.Where(v => v.Pawn_Product_id == prod_id); var count = results.Count(); if (count > 0) { foreach (var r in results) { prod_img.ImageUrl = r.Image_url; txtName.Text = r.Name; txtAmount.Text = r.Amount.ToString(); txtType.Text = r.Product_type; } } } }
protected void getUserProfile() { int userid = Convert.ToInt32(lblUsername.Text); using (CricketSystemEntities objUser = new CricketSystemEntities()) { var results = objUser.user_table.Where(v => v.User_id == userid); var count = results.Count(); if (count > 0) { foreach (var r in results) { txtFirstname.Text = r.Firstname; txtLastname.Text = r.Lastname; txtCellno.Text = r.Cellno; txtEmail.Text = r.Email; } } } }
public void sendEmail() { CricketSystemEntities objUser = new CricketSystemEntities(); string emailTo = txtEmail.Text; var pass = (from r in objUser.user_table where r.Email == txtEmail.Text select r.Password).FirstOrDefault(); lblError.Text = ""; lblError.ForeColor = Color.Red; string body = "Your password is: " + pass; try { MailMessage mail = new MailMessage(); mail.To.Add(emailTo); mail.From = new MailAddress("*****@*****.**"); mail.Subject = "Forgot Password"; mail.Body = body; mail.IsBodyHtml = true; SmtpClient smtp = new SmtpClient(); smtp.Host = "smtp.gmail.com"; //Or Your SMTP Server Address smtp.Credentials = new System.Net.NetworkCredential("*****@*****.**", "GioSystem2"); // ***use valid credentials*** smtp.Port = 587; //Or your Smtp Email ID and Password smtp.EnableSsl = true; smtp.Send(mail); lblError.Text = "Thank you, Your password has been sent to your email address."; lblError.ForeColor = Color.MidnightBlue; } catch (Exception ex) { //(ex.Message); } }
public void SavePaymentDetails(int orderId) { using (CricketSystemEntities context = new CricketSystemEntities()) { payment_table tbl = new payment_table(); tbl.Purchase_id = orderId; tbl.Purchase_Type = "Sell"; tbl.User_id = Convert.ToInt32(lblUsername.Text); tbl.Bank = ddlBank.SelectedValue; tbl.Card_number = card_number.Text; tbl.Card_holder = card_holder.Text; tbl.Cvv = cvv.Text; tbl.ExpMM = Convert.ToInt32(expMM.Text); tbl.ExpYY = Convert.ToInt32(expYY.Text); tbl.Date = DateTime.Now.ToShortDateString(); tbl.Time = DateTime.Now.ToShortTimeString(); tbl.totatAmount = Convert.ToDecimal(lblTotalDue.Text); tbl.Status = "Success"; context.payment_table.Add(tbl); context.SaveChanges(); } }
public void updateStatus(int Hireid) { if (ddlStatus.SelectedIndex > 0) { using (CricketSystemEntities ctx = new CricketSystemEntities()) { var p = (from y in ctx.hired_table where y.Hire_id.Equals(Hireid) select y) .ToList(); foreach (var x in p) { x.Status = ddlStatus.SelectedValue; ctx.SaveChanges(); BindDataOrders(); } } } else { lblUpdateResults.Text = "Please select status to update."; lblUpdateResults.ForeColor = Color.Red; } }
protected void btnUpdateProfile_Click(object sender, EventArgs e) { lblUpdateResults.Text = ""; int userid = Convert.ToInt32(lblUsername.Text); string emailPattern = @"^\w+@[a-zA-Z_]+?\.[a-zA-Z]{2,3}$"; string phonePattern = @"^((?:\+27|27)|0)(=99|72|82|73|83|74|78|84|79|81|71|76|64|65|66|60|61|62|63|67)(\d{7})$"; bool isEmailValid = Regex.IsMatch(txtEmail.Text, emailPattern); bool isEmailExist = IsEmailExist(txtEmail.Text); bool isPhoneValid = Regex.IsMatch(txtCellno.Text, phonePattern); bool isCellExist = IsCellNoExist(txtCellno.Text); bool isUsernameExist = IsUsernameExist(txtUsername.Text); if (!Regex.Match(UpperCaseFirst(txtFirstname.Text), "^[A-Z][a-zA-Z]*$").Success) { lblUpdateResults.Text = "Invalid Firstname."; } else if (txtLastname.Text == "") { lblUpdateResults.Text = "Please enter Lastname."; } else if (!Regex.Match(UpperCaseFirst(txtLastname.Text), "^[A-Z][a-zA-Z-]*$").Success) { lblUpdateResults.Text = "Invalid Lastname."; } else if (txtCellno.Text == "") { lblUpdateResults.Text = "Please provide Cellphone number to update"; lblUpdateResults.ForeColor = Color.Red; } else if (!isPhoneValid) { lblUpdateResults.Text = "Please enter a valid Cell Number."; lblUpdateResults.ForeColor = Color.Red; } else if (txtUsername.Text == "") { lblUpdateResults.Text = "Please provide Username to update"; lblUpdateResults.ForeColor = Color.Red; } else if (txtEmail.Text == "") { lblUpdateResults.Text = "Please provide Email address to update"; lblUpdateResults.ForeColor = Color.Red; } else if (!isEmailValid) { lblUpdateResults.Text = "Please enter a valid Email Address."; lblUpdateResults.ForeColor = Color.Red; } else { using (CricketSystemEntities ctx = new CricketSystemEntities()) { var p = (from y in ctx.user_table where y.User_id.Equals(userid) select y) .ToList(); foreach (var x in p) { x.Firstname = txtFirstname.Text; x.Lastname = txtLastname.Text; x.Cellno = txtCellno.Text; x.Username = txtUsername.Text; x.Email = txtEmail.Text; ctx.SaveChanges(); lblUpdateResults.Text = "Profile Updated Successfully"; lblUpdateResults.ForeColor = Color.MidnightBlue; getUserProfile(); } } } }
protected void btnUpdateProfile_Click(object sender, EventArgs e) { lblRegisterError.Text = ""; //lblReturnMessage.Text = ""; //lblYouGet.Text = ""; //lblYouReturn.Text = ""; if (txtCollectionDate.Text == "") { lblRegisterError.Text = "Please Select collection Date."; } else if (txtQuantity.Text == "") { lblRegisterError.Text = "Please provide Quantity."; } else if (ddlConditon.SelectedIndex == 0) { lblRegisterError.Text = "Please select Conditon type."; } else if (lblReturnMessage.Text == "") { lblRegisterError.Text = "Please 'Get Estimation' before you proceed."; } else { CricketSystemEntities context = new CricketSystemEntities(); pawn_table tbl = new pawn_table(); int prod_id = Convert.ToInt32(lblItemId.Text); int userid = Convert.ToInt32(Session["userId"].ToString()); string collectionDate = txtCollectionDate.Text; int Quantity = Convert.ToInt32(txtQuantity.Text); string condition = ddlConditon.SelectedValue; double fee = Convert.ToDouble(txtAmount.Text); double ammountdue = 0; double topay = 0; if (ddlConditon.SelectedIndex == 1) { topay = Quantity * fee * 0.7; ammountdue = topay + (topay * 0.29); } else if (ddlConditon.SelectedIndex == 2) { topay = Quantity * fee * 0.6; ammountdue = topay + (topay * 0.32); } else { topay = Quantity * fee * 0.45; ammountdue = topay + (topay * 0.35); } tbl.Pawn_Product_id = prod_id; tbl.User_id = userid; tbl.Quantity = Quantity; tbl.LoanAmount = Convert.ToDecimal(topay); tbl.AmountDue = Convert.ToDecimal(ammountdue); tbl.Status = "Pending"; tbl.Condition = condition; tbl.Date = DateTime.Now.ToShortDateString(); tbl.Time = DateTime.Now.ToShortTimeString(); tbl.collectionDate = collectionDate; context.pawn_table.Add(tbl); context.SaveChanges(); Response.Redirect("Pawn.aspx"); } }
public void SaveOrder() { CricketSystemEntities context = new CricketSystemEntities(); //calling delivery table int count = grdProduct.Rows.Count; var id = context.hired_table.Count() + 1; int userId = Convert.ToInt32(lblUsername.Text); if (count > 0) { for (int i = 0; i < count; i++) { int prodId = GetProductId(grdProduct.Rows[i].Cells[0].Text, "Admin"); //string hired_table tbl = new hired_table(); TextBox quant = (TextBox)grdProduct.Rows[i].FindControl("txtQuantity"); TextBox days = (TextBox)grdProduct.Rows[i].FindControl("txtNoDays"); tbl.Name = grdProduct.Rows[i].Cells[0].Text; tbl.Hire_No = id; tbl.User_id = Convert.ToInt32(lblUsername.Text); tbl.Username = GetUsername(userId); tbl.Price = Convert.ToDecimal(grdProduct.Rows[i].Cells[1].Text); tbl.Quantity = Convert.ToInt32(quant.Text); tbl.NoDays = Convert.ToInt32(days.Text); tbl.Date = DateTime.Now.ToShortDateString(); tbl.Time = DateTime.Now.ToShortTimeString(); tbl.Status = "Pending"; tbl.ReturnDate = DateTime.Now.AddDays(Convert.ToInt32(days.Text)).ToString(); UpdateStock(tbl.Quantity, tbl.Name); //sendEmail(); //delivery context.hired_table.Add(tbl); } try { context.SaveChanges(); SavePaymentDetails(id); System.Threading.Thread.Sleep(1000); Response.Redirect("ConfirmHire.aspx"); } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { Exception raise = dbEx; foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { string message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage); raise = new InvalidOperationException(message, raise); } } throw raise; } } }
private void Register() { CricketSystemEntities context = new CricketSystemEntities(); user_table tbl = new user_table(); string gender = ""; lblRegisterError.Text = ""; lblRegisterError.ForeColor = Color.Red; string emailPattern = @"^\w+@[a-zA-Z_]+?\.[a-zA-Z]{2,3}$"; string phonePattern = @"^((?:\+27|27)|0)(=99|72|82|73|83|74|78|84|86|79|81|71|76|64|65|66|60|61|62|63|65|66|67)(\d{7})$"; string IDCodePattern = @"^(((\d{2}((0[13578]|1[02])(0[1-9]|[12]\d|3[01])|(0[13456789]|1[012])(0[1-9]|[12]\d|30)|02(0[1-9]|1\d|2[0-8])))|([02468][048]|[13579][26])0229))(( |-)(\d{4})( |-)(\d{3})|(\d{7}))$"; bool isEmailValid = Regex.IsMatch(txtEmail.Text, emailPattern); bool isEmailExist = IsEmailExist(txtEmail.Text); bool isIDValid = Regex.IsMatch(txtIdNo.Text, IDCodePattern); bool isIDExist = IsIdNumberExist(txtIdNo.Text); bool isPhoneValid = Regex.IsMatch(txtCellno.Text, phonePattern); bool isCellExist = IsCellNoExist(txtCellno.Text); bool isUsernameExist = IsUsernameExist(txtUsernames.Text); string age = getAge(txtIdNo.Text); if (txtFirstname.Text == "") { lblRegisterError.Text = "Please enter Firstname."; } else if (!Regex.Match(UpperCaseFirst(txtFirstname.Text), "^[A-Z][a-zA-Z]*$").Success) { lblRegisterError.Text = "Invalid Firstname."; } else if (txtLastname.Text == "") { lblRegisterError.Text = "Please enter Lastname."; } else if (!Regex.Match(UpperCaseFirst(txtLastname.Text), "^[A-Z][a-zA-Z-]*$").Success) { lblRegisterError.Text = "Invalid Lastname."; } else if (txtIdNo.Text == "") { lblRegisterError.Text = "Please enter ID Number."; } else if (!isIDValid) { lblRegisterError.Text = "Please enter a valid ID Number."; } else if (Convert.ToInt32(age) < 18) { lblRegisterError.Text = "User must be 18 years or older to register."; } else if (isIDExist) { lblRegisterError.Text = "ID Number already exist."; } else if (ddlType.SelectedIndex == 0) { lblRegisterError.Text = "Please select your UserType."; } else if (txtCellno.Text == "") { lblRegisterError.Text = "Please enter Cell Number."; } else if (!isPhoneValid) { lblRegisterError.Text = "Please enter a valid Cell Number."; } else if (isCellExist) { lblRegisterError.Text = "Cellphone Number already exist."; } else if (txtEmail.Text == "") { lblRegisterError.Text = "Please enter Email Address."; } else if (!isEmailValid) { lblRegisterError.Text = "Please enter a valid Email Address."; } else if (isEmailExist) { lblRegisterError.Text = "Email already exist"; } else if (txtUsernames.Text == "") { lblRegisterError.Text = "Please enter Username."; } else if (isUsernameExist) { lblRegisterError.Text = "Username already exist"; } else if (txtPasswords.Text == "") { lblRegisterError.Text = "Please enter Password."; } else if (txtPasswords.Text.Length < 6) { lblRegisterError.Text = "Password must be atleast 6 characters long."; lblRegisterError.ForeColor = Color.Red; } else { var id = context.user_table.Count() + 1; if (Convert.ToInt32(txtIdNo.Text.Substring(6, 4)) > 4999) { gender = "Male"; } else { gender = "Female"; } tbl.User_type = ddlType.SelectedValue; tbl.Firstname = UpperCaseFirst(txtFirstname.Text); tbl.Lastname = UpperCaseFirst(txtLastname.Text); tbl.IDNumber = txtIdNo.Text; tbl.Gender = gender; tbl.Cellno = txtCellno.Text; tbl.Email = txtEmail.Text; tbl.Username = txtUsernames.Text; tbl.Password = txtPasswords.Text; tbl.Date_created = DateTime.Now.Date; tbl.Status = "Active"; context.user_table.Add(tbl); context.SaveChanges(); lblRegisterError.Text = "Staff Added."; lblRegisterError.ForeColor = Color.MidnightBlue; TextBox [] txt = { txtFirstname, txtLastname, txtIdNo, txtCellno, txtEmail, txtPasswords, txtUsernames }; for (int i = 0; i < txt.Length; i++) { txt[i].Text = ""; } ddlType.SelectedIndex = 0; } }
private void AddProducts() { CricketSystemEntities context = new CricketSystemEntities(); product_table tbl = new product_table(); string fileName = System.IO.Path.GetFileName(FileUploadAdd.FileName); if (txtProductname.Text == "") { lblRegisterError.Text = "Please provide Product name."; } else if (ddlType.SelectedIndex == 0) { lblRegisterError.Text = "Please select product type."; } else if (txtProductPrice.Text == "") { lblRegisterError.Text = "Please provide Product price."; } else if (txtProductNo.Text == "") { lblRegisterError.Text = "Please provide No of Products available in stock."; } else if (!Regex.Match(txtProductPrice.Text, "^\\$?(\\d{1,3},(\\d{3},)*\\d{3}|\\d+)(.\\d{1,4})?$").Success) { lblRegisterError.Text = "Invalid Product price."; } else if (FileUploadAdd.FileName == "") { lblRegisterError.Text = "Please select product Image."; } else { //Set the Image File Path. string filePath = "~/Pictures/Products/" + fileName; int userId = Convert.ToInt32(lblUsername.Text); //Save the Image File in Folder. FileUploadAdd.SaveAs(Server.MapPath(filePath)); tbl.Name = UpperCaseFirst(txtProductname.Text); tbl.product_purpose = "Sell"; tbl.Product_type = ddlType.SelectedValue; tbl.Price = txtProductPrice.Text; tbl.ProductNo = Convert.ToInt32(txtProductNo.Text); tbl.Image_url = filePath; tbl.Username = GetUsername(userId); tbl.User_id = userId; tbl.UserType = "Supplier"; context.product_table.Add(tbl); context.SaveChanges(); lblRegisterError.Text = "Product Added."; lblRegisterError.ForeColor = Color.MidnightBlue; TextBox[] txt = { txtProductname, txtProductPrice, txtProductNo }; for (int i = 0; i < txt.Length; i++) { txt[i].Text = ""; } ddlType.SelectedIndex = 0; } }