protected void button1_Click1(object sender, EventArgs e) { DAL.myClass userDal = new DAL.myClass(); string Username = TextBox1.Text; string Password = txtPassword.Text; if (Username == "" || Password == "") { Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('No data');</script>"); } else { int result = userDal.Login(Username, Password); if (result == 1) { Session["user_id"] = TextBox1.Text; Label1.Text = "Login Successful!"; Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert(" + Session["user_id"].ToString() + "');</script>"); Response.Redirect("~/Home.aspx"); } else if (result == 0) { Session["user_id"] = null; Label1.Text = "Login Unsuccessful!"; } else if (result == -5) { Session["user_id"] = null; Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('SQL Error');</script>"); } } }
protected void Button2_Click(object sender, EventArgs e) { DAL.myClass userDal = new DAL.myClass(); string id = TextBox1.Text; string name = TextBox2.Text; string mid = TextBox3.Text; string quantity = TextBox4.Text; string amount = TextBox5.Text; if (id == "" || name == "" || mid == "" || quantity == "" || amount == "") { Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Kindly Enter Data');</script>"); } else { int result = userDal.customer(id, name, mid, quantity, amount); int result1 = userDal.Bill(id); int result2 = userDal.repetedcustomer(id); if (result == -5 || result1 == -5 || result2 == -5) { Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('SQL Error');</script>"); } else { Response.Redirect("~/Output4.aspx"); } } }
protected void button2_Click(object sender, EventArgs e) { DAL.myClass userDal = new DAL.myClass(); DataTable DT = new DataTable(); if (TextBox8.Text != TextBox9.Text) { Label1.Text = "Password not same!"; } if (TextBox1.Text == "" || TextBox2.Text == "" || TextBox3.Text == "" || TextBox4.Text == "" || TextBox5.Text == "" || TextBox6.Text == "" || TextBox7.Text == "" || TextBox8.Text == "" || TextBox9.Text == "") { Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Kindly Enter Data');</script>"); } else if (TextBox8.Text == TextBox9.Text) { int result = userDal.Signup(TextBox1.Text, TextBox2.Text, TextBox3.Text, TextBox4.Text, Int32.Parse(TextBox5.Text), TextBox7.Text, TextBox6.Text, TextBox8.Text); if (result == 0) { Label1.Text = "Username already exists!"; } else if (result == 1) { Label1.Text = "Account made successfully!"; } else if (result == -5) { Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('SQL Error');</script>"); } } }
protected void Button2_Click(object sender, EventArgs e) { DAL.myClass userDal = new DAL.myClass(); string PurchaseID = TextBox1.Text; string DealerID = TextBox2.Text; string Medicineid = TextBox3.Text; string PurchaseDate = TextBox4.Text; string Quantity = TextBox5.Text; string price = TextBox6.Text; string Totalprice = TextBox7.Text; if (TextBox1.Text == "" || TextBox2.Text == "" || TextBox3.Text == "" || TextBox4.Text == "" || TextBox5.Text == "" || TextBox6.Text == "" || TextBox7.Text == "") { Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Kindly Enter Data');</script>"); } else { int result = userDal.dealer(PurchaseID, DealerID, Medicineid, PurchaseDate, Quantity, price, Totalprice); userDal.showdealerbill(); if (result == -5) { Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('SQL Error');</script>"); } else { Response.Redirect("~/Output5.aspx"); } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["user_id"] == null) { Response.Redirect("Login.aspx"); } else if (Session["Employ"].ToString() == "1") { DAL.myClass userDal = new DAL.myClass(); DataTable table = new DataTable(); table = userDal.showallEmployees(); GridView1.DataSource = table; GridView1.EmptyDataText = "No Records Found"; GridView1.DataBind(); } else if (Session["Employ"].ToString() == "2") { DAL.myClass userDal = new DAL.myClass(); DataTable table = new DataTable(); table = userDal.findemploy(Session["Eid"].ToString()); GridView1.DataSource = table; GridView1.EmptyDataText = "No Records Found"; GridView1.DataBind(); } else if (Session["Employ"].ToString() == "3") { DAL.myClass userDal = new DAL.myClass(); DataTable table = new DataTable(); table = userDal.findemployname(Session["Eid"].ToString()); GridView1.DataSource = table; GridView1.EmptyDataText = "No Records Found"; GridView1.DataBind(); } }
protected void button2_Click(object sender, EventArgs e) { DAL.myClass userDal = new DAL.myClass(); DataTable DT = new DataTable(); if (Password.Text != ConfPassword.Text) { Label1.Text = "Password not same!"; } if (Name.Text == "" || Address.Text == "" || Salary.Text == "" || Designation.Text == "" || Email.Text == "" || Password.Text == "" || ConfPassword.Text == "" || Contact.Text == "" || UName.Text == "") { Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Kindly Enter Data');</script>"); } else if (Password.Text == ConfPassword.Text) { int result = userDal.Signup(Name.Text, Contact.Text, Address.Text, Designation.Text, Int32.Parse(Salary.Text), Email.Text, Gender.Text, UName.Text, Password.Text); if (result == 0) { Label1.Text = "Username already exists!"; } else if (result == 1) { Label1.Text = "Account made successfully!"; } else if (result == -5) { Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('SQL Error');</script>"); } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["Did"].ToString() == "1") { DAL.myClass userDal = new DAL.myClass(); DataTable table = new DataTable(); table = userDal.showalldealers(); GridView1.DataSource = table; GridView1.EmptyDataText = "No Records Found"; GridView1.DataBind(); } else if (Session["Did"].ToString() == "2") { DAL.myClass userDal = new DAL.myClass(); DataTable table = new DataTable(); table = userDal.showallcompanies(); GridView1.DataSource = table; GridView1.EmptyDataText = "No Records Found"; GridView1.DataBind(); } else if (Session["Did"].ToString() == "3") { DAL.myClass userDal = new DAL.myClass(); DataTable table = new DataTable(); table = userDal.showallpurchases(); GridView1.DataSource = table; GridView1.EmptyDataText = "No Records Found"; GridView1.DataBind(); } else if (Session["Did"].ToString() == "4") { DAL.myClass userDal = new DAL.myClass(); DataTable table = new DataTable(); table = userDal.showallsales(); GridView1.DataSource = table; GridView1.EmptyDataText = "No Records Found"; GridView1.DataBind(); } else if (Session["Did"].ToString() == "5") { DAL.myClass userDal = new DAL.myClass(); DataTable table = new DataTable(); table = userDal.searchdealerbyid(Session["Did2"].ToString()); GridView1.DataSource = table; GridView1.EmptyDataText = "No Records Found"; GridView1.DataBind(); } else if (Session["Did"].ToString() == "6") { DAL.myClass userDal = new DAL.myClass(); DataTable table = new DataTable(); table = userDal.DealernamefromCompID(Session["Did2"].ToString()); GridView1.DataSource = table; GridView1.EmptyDataText = "No Records Found"; GridView1.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { DAL.myClass userDal = new DAL.myClass(); DataTable table = new DataTable(); table = userDal.showdealerbill(); GridView1.DataSource = table; GridView1.EmptyDataText = "Amount is less or due to another fault No record found"; GridView1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["user_id"] == null) { Response.Redirect("Login.aspx"); } else { DAL.myClass userDal = new DAL.myClass(); DataTable table = new DataTable(); table = userDal.showdealerbill(); GridView1.DataSource = table; GridView1.EmptyDataText = "Amount is less or due to another fault No record found"; GridView1.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["user_id"] == null) { Response.Redirect("Login.aspx"); } else { DAL.myClass userDal = new DAL.myClass(); MedicineID.DataSource = userDal.getMedicineIdList(); MedicineID.DataBind(); CustomerID.DataSource = userDal.getCustomerIdList(); CustomerID.DataBind(); } }
protected void Button1_Click(object sender, EventArgs e) { DAL.myClass userDal = new DAL.myClass(); string id = TextBox1.Text; string name = TextBox2.Text; string mid = TextBox3.Text; string quantity = TextBox4.Text; string amount = TextBox5.Text; if (id == "" || name == "" || mid == "" || quantity == "" || amount == "") { Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Kindly Enter Data');</script>"); } else { userDal.customer(id, name, mid, quantity, amount); TextBox3.Text = ""; TextBox4.Text = ""; } }
protected void Page_Load(object sender, EventArgs e) { if (Session["user_id"] == null) { Response.Redirect("Login.aspx"); } else if (Session["Button"].ToString() == "1") { DAL.myClass userDal = new DAL.myClass(); DataTable table = new DataTable(); table = userDal.showallMedicine(); GridView1.DataSource = table; GridView1.EmptyDataText = "No Records Found"; GridView1.DataBind(); } else if (Session["Button"].ToString() == "2") { DAL.myClass userDal = new DAL.myClass(); DataTable table = new DataTable(); table = userDal.showOutOfStock(); GridView1.DataSource = table; GridView1.EmptyDataText = "No Records Found"; GridView1.DataBind(); } else if (Session["Button"].ToString() == "3") { DAL.myClass userDal = new DAL.myClass(); DataTable table = new DataTable(); table = userDal.showAllExpired(); GridView1.DataSource = table; GridView1.EmptyDataText = "No Records Found"; GridView1.DataBind(); } else if (Session["Button"].ToString() == "4") { DAL.myClass userDal = new DAL.myClass(); DataTable table = new DataTable(); table = userDal.searchMedicinebyId(Session["id"].ToString()); GridView1.DataSource = table; GridView1.EmptyDataText = "No Records Found"; GridView1.DataBind(); } else if (Session["Button"].ToString() == "5") { DAL.myClass userDal = new DAL.myClass(); DataTable table = new DataTable(); table = userDal.ExpireMedicinebyId(Session["id"].ToString()); GridView1.DataSource = table; GridView1.EmptyDataText = "No Records Found"; GridView1.DataBind(); } else if (Session["Button"].ToString() == "6") { DAL.myClass userDal = new DAL.myClass(); DataTable table = new DataTable(); table = userDal.whotookthesemedicine(Session["id"].ToString()); GridView1.DataSource = table; GridView1.EmptyDataText = "No Records Found"; GridView1.DataBind(); } else if (Session["Button"].ToString() == "7") { DAL.myClass userDal = new DAL.myClass(); DataTable table = new DataTable(); table = userDal.findallinfo(Session["id"].ToString()); GridView1.DataSource = table; GridView1.EmptyDataText = "No Records Found"; GridView1.DataBind(); } else if (Session["Button"].ToString() == "8") { DAL.myClass userDal = new DAL.myClass(); DataTable table = new DataTable(); table = userDal.quantityleft(Session["id"].ToString()); GridView1.DataSource = table; GridView1.EmptyDataText = "No Records Found"; GridView1.DataBind(); } else if (Session["Button"].ToString() == "9") { DAL.myClass userDal = new DAL.myClass(); DataTable table = new DataTable(); table = userDal.purchasedate(Session["id"].ToString()); GridView1.DataSource = table; GridView1.EmptyDataText = "No Records Found"; GridView1.DataBind(); } else if (Session["Button"].ToString() == "10") { DAL.myClass userDal = new DAL.myClass(); DataTable table = new DataTable(); table = userDal.noofsale(Session["id"].ToString()); GridView1.DataSource = table; GridView1.EmptyDataText = "No Records Found"; GridView1.DataBind(); } else if (Session["Button"].ToString() == "11") { DAL.myClass userDal = new DAL.myClass(); DataTable table = new DataTable(); table = userDal.updatemanf(Session["id"].ToString(), Session["id2"].ToString()); GridView1.DataSource = table; GridView1.EmptyDataText = "No Records Found"; GridView1.DataBind(); } else if (Session["Button"].ToString() == "12") { DAL.myClass userDal = new DAL.myClass(); DataTable table = new DataTable(); table = userDal.updateexpiry(Session["id"].ToString(), Session["id2"].ToString()); GridView1.DataSource = table; GridView1.EmptyDataText = "No Records Found"; GridView1.DataBind(); } }