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;
}
}
