protected void SupplierGridView_PageIndexChanging(object sender, GridViewPageEventArgs e) { SupplierGridView.DataSource = SupplierBizLogic.ListSupplier(); SupplierGridView.PageIndex = e.NewPageIndex; SupplierGridView.DataBind(); BindGrid(); }
private void BindGrid() { int DeptID = (int)HttpContext.Current.Session["DeptID"]; DelegationHistoryGridView.DataSource = SupplierBizLogic.FindDelegation2(DeptID).ToList(); DelegationHistoryGridView.DataBind(); DelegationScheduleGridView.DataSource = SupplierBizLogic.FindDelegation(DeptID).ToList(); DelegationScheduleGridView.DataBind(); }
protected void BindData(int DepID) { Label2.Text = SupplierBizLogic.FindCollectionByDepID(DepID).EmployeeName.ToString(); URDropDownList.DataSource = SupplierBizLogic.FindEmpByDepID(DepID); URDropDownList.DataTextField = "Name"; URDropDownList.DataValueField = "EmployeeID"; URDropDownList.DataBind(); }
protected void DelegationScheduleGridView_PageIndexChanging(object sender, GridViewPageEventArgs e) { //adin for page index int DeptID = (int)HttpContext.Current.Session["DeptID"]; DelegationScheduleGridView.DataSource = SupplierBizLogic.FindDelegation(DeptID).ToList(); DelegationScheduleGridView.PageIndex = e.NewPageIndex; DelegationScheduleGridView.DataBind(); }
protected void GoButton_Click(object sender, EventArgs e) { ItemID = ItemDropDownList.SelectedItem.Value; Label1.Text = "Current 1st Priorty Supplier : " + SupplierBizLogic.FindItemSupplierByID(ItemID).P1Supplier; Label2.Text = "Current 2nd Priorty Supplier : " + SupplierBizLogic.FindItemSupplierByID(ItemID).P2Supplier; Label3.Text = "Current 3rd Priorty Supplier : " + SupplierBizLogic.FindItemSupplierByID(ItemID).P3Supplier; Label4.Text = "Select for your updates :"; Label5.Text = "Select for your updates :"; Label6.Text = "Select for your updates :"; Priority1DropDownList.Visible = true; Priority2DropDownList.Visible = true; Priority3DropDownList.Visible = true; UpdateButton.Visible = true; }
protected void SupplierGridView_RowUpdating(object sender, GridViewUpdateEventArgs e) { GridViewRow row = SupplierGridView.Rows[e.RowIndex]; int SupplierID = Convert.ToInt32(SupplierGridView.DataKeys[e.RowIndex].Values[0]); //string name = (row.FindControl("Textbox1") as TextBox).Text; string address = (row.FindControl("Textbox2") as TextBox).Text; string phone = (row.FindControl("Textbox3") as TextBox).Text; SupplierBizLogic.UpdateSupplier(SupplierID, address, phone); SupplierGridView.EditIndex = -1; this.BindGrid(); }
protected void DelegationScheduleGridView_RowDeleting(object sender, GridViewDeleteEventArgs e) { int Id = Convert.ToInt32(DelegationScheduleGridView.DataKeys[e.RowIndex].Values[0]); GridViewRow row = DelegationScheduleGridView.Rows[e.RowIndex]; DateTime? start = SupplierBizLogic.findStartDate(Id); DateTime? end; if (start >= DateTime.Now.Date) { SupplierBizLogic.DeleteDelegation(Id); this.BindGrid(); } else { end = DateTime.Now.Date.AddDays(-1); SupplierBizLogic.UpdateDelegation(Id, end); } }
protected void UpdateButton_Click(object sender, EventArgs e) { //int DepID = 2001; int DepID = (int)HttpContext.Current.Session["DeptID"]; int NewCollectionID = Convert.ToInt32(CPRadioButtonList.SelectedValue); UserRepCollection updatedDeptURCollection = new UserRepCollection { }; // must declare a variable here first before using it in try block or else not detectable try { updatedDeptURCollection = SupplierBizLogic.UpdateURcollectiontableCollection(DepID, NewCollectionID); // changed this to return a userrepcollection object Response.Write("<script>alert('Collection Point updated!');</script>"); } catch (Exception exp) { Response.Write(exp.ToString()); } // added code below: try { //to clerk string oldCollection = Label1.Text; String from = "*****@*****.**"; List <String> toAddress = MailBizLogic.ClerkEmail(); String subject = String.Format("[Auto Notification] Changes on Collection Point for {0}", updatedDeptURCollection.Department.Description); String body = String.Format("Collection Point For '{0}' has been changed from '{1}' to '{2}'." + "\n\nNote: This is an auto-generated email. Please do not reply to this email." + "\n\nThis email is confidential and may be privileged.If you are not the intended recipient, " + "please delete it and notify us immediately; you should not copy or use it for any purpose, " + "nor disclose its contents to any other person.\n\nThank you.", updatedDeptURCollection.Department.Description, oldCollection, updatedDeptURCollection.Collection.Location); foreach (String to in toAddress) { MailBizLogic.sendMail(from, to, subject, body); } BindData(DepID); } catch (Exception ex) { Response.Write("Could not send the e-mail - error: " + ex.Message); } }
protected void UpdateButton_Click(object sender, EventArgs e) { int Priority1 = Convert.ToInt32(Priority1DropDownList.SelectedItem.Value); int Priority2 = Convert.ToInt32(Priority2DropDownList.SelectedItem.Value); int Priority3 = Convert.ToInt32(Priority3DropDownList.SelectedItem.Value); try { ItemID = ItemDropDownList.SelectedItem.Value; SupplierBizLogic.UpdateItemSupplier(ItemID, Priority1, Priority2, Priority3); //Response.Redirect("Default2.aspx?username="******"<script>alert('Suppliers Priority has been updated !');</script>"); Label1.Text = ""; Label2.Text = ""; Label3.Text = ""; Label4.Text = ""; Label5.Text = ""; Label6.Text = ""; ItemDropDownList.SelectedIndex = 0; Priority1DropDownList.Visible = false; Priority2DropDownList.Visible = false; Priority3DropDownList.Visible = false; //send mail to clerk String from = "*****@*****.**"; List <String> toAddress = MailBizLogic.ClerkEmail(); String subject = "[Auto Notification] Item supplier update"; String body = String.Format("Supplier's priority has been changed for item {0}. Check website for further details." + "\n\nNote: This is an auto-generated email. Please do not reply to this email." + "\n\nThis email is confidential and may be privileged.If you are not the intended recipient, " + "please delete it and notify us immediately; you should not copy or use it for any purpose, " + "nor disclose its contents to any other person.\n\nThank you.", ItemID); foreach (String to in toAddress) { MailBizLogic.sendMail(from, to, subject, body); } } catch (Exception exp) { Response.Write(exp.ToString()); } }
protected void UpdateButton_Click(object sender, EventArgs e) { int DepID = (int)HttpContext.Current.Session["DeptID"]; int NewEmployeeID = Convert.ToInt32(URDropDownList.SelectedValue); //changed from CPRadioButtonList to URDropDownList int OldEmployeeID = Convert.ToInt32(SupplierBizLogic.FindCollectionByDepID(DepID).EmployeeID); UserRepCollection updatedDeptURCollection = new UserRepCollection { }; // must declare a variable here first before using it in try block or else not detectable try { SupplierBizLogic.UpdateNewURinEmptable(NewEmployeeID); SupplierBizLogic.UpdateOldURinEmptable(OldEmployeeID); updatedDeptURCollection = SupplierBizLogic.UpdateURcollectiontableUR(DepID, NewEmployeeID); Response.Write("<script>alert('User Representative changed!');</script>"); } catch (Exception exp) { Response.Write(exp.ToString()); } // added code below: try { String from = "*****@*****.**"; List <String> toAddress = MailBizLogic.ClerkEmail(); String subject = String.Format("[Auto Notification] Changes on User Representative for {0}", updatedDeptURCollection.Department.Description); String body = String.Format("New User Representative For '{0}' has been assigned to {1}." + "\n\nNote: This is an auto-generated email. Please do not reply to this email." + "\n\nThis email is confidential and may be privileged.If you are not the intended recipient, " + "please delete it and notify us immediately; you should not copy or use it for any purpose, " + "nor disclose its contents to any other person.\n\nThank you.", updatedDeptURCollection.Department.Description, updatedDeptURCollection.Employee.Name); foreach (String to in toAddress) { MailBizLogic.sendMail(from, to, subject, body); } Label2.Text = SupplierBizLogic.FindCollectionByDepID(DepID).EmployeeName.ToString(); } catch (Exception ex) { Response.Write("Could not send the e-mail - error: " + ex.Message); } }
protected void Page_Load(object sender, EventArgs e) { if (HttpContext.Current.Session["EmpID"] == null) { Response.Redirect("/Account/Login.aspx"); } else { if (!this.IsPostBack) { int EmpID = (int)HttpContext.Current.Session["EmpID"]; int DeptID = (int)HttpContext.Current.Session["DeptID"]; SelectStaffDropDownList.DataSource = SupplierBizLogic.FindEmpByDepID2(DeptID, EmpID); SelectStaffDropDownList.DataTextField = "Name"; SelectStaffDropDownList.DataValueField = "EmployeeID"; SelectStaffDropDownList.DataBind(); } } }
protected void SubmitButton_Click(object sender, EventArgs e) { if (Label1.Text != "Invalid Selection" && Label2.Text != "Invalid Selection") { int DeptID = (int)HttpContext.Current.Session["DeptID"]; int EmpID = Convert.ToInt32(SelectStaffDropDownList.SelectedValue); DateTime start = Convert.ToDateTime(Label1.Text); DateTime end = Convert.ToDateTime(Label2.Text); if (SupplierBizLogic.IsDuplicate(DeptID, start, end)) { Response.Write("<script>alert('The selected dates already assigned !');</script>"); Label1.Text = ""; Label2.Text = ""; Label3.Text = ""; Label4.Text = ""; Calendar1.SelectedDate = DateTime.Now.Date; SelectStaffDropDownList.SelectedIndex = 0; DateRadioButtonList.SelectedIndex = 0; count = 0; } else { SupplierBizLogic.CreateDelegation(EmpID, start, end, DeptID); Response.Write("<script>alert('Job Delegated !');</script>"); Label1.Text = ""; Label2.Text = ""; Label3.Text = ""; Label4.Text = ""; Calendar1.SelectedDate = DateTime.Now.Date; SelectStaffDropDownList.SelectedIndex = 0; DateRadioButtonList.SelectedIndex = 0; } } else { Response.Write("<script>alert('Invalid Selection');</script>"); } }
protected void AddNewSupButton_Click(object sender, EventArgs e) { string name = SupplierName.Text; string add = SupplierAdd.Text; string phone = SupplierPhone.Text; { try { SupplierBizLogic.AddSupplier(name, add, phone); //Response.Redirect("Default2.aspx?username="******"<script>alert('New Supplier has been Added!');</script>"); SupplierName.Text = ""; SupplierAdd.Text = ""; SupplierPhone.Text = ""; //send mail to clerk String from = "*****@*****.**"; List <String> toAddress = MailBizLogic.ClerkEmail(); String subject = "[Auto Notification] Added new supplier"; String body = String.Format("New supplier {0} has been added. Check website for further details." + "\n\nNote: This is an auto-generated email. Please do not reply to this email." + "\n\nThis email is confidential and may be privileged.If you are not the intended recipient, " + "please delete it and notify us immediately; you should not copy or use it for any purpose, " + "nor disclose its contents to any other person.\n\nThank you.", name); foreach (String to in toAddress) { MailBizLogic.sendMail(from, to, subject, body); } } catch (Exception exp) { Response.Write(exp.ToString()); } } }
protected void BindData(int DepID) { Label1.Text = SupplierBizLogic.FindCollectionByDepID(DepID).CollectionPoint.ToString(); CPRadioButtonList.SelectedValue = SupplierBizLogic.FindCollectionByDepID(DepID).CollectionPointID.ToString(); }
private void BindGrid() { SupplierGridView.DataSource = SupplierBizLogic.ListSupplier(); SupplierGridView.DataBind(); }
protected void AddNewButton_Click(object sender, EventArgs e) { string ItemID = ItemIdTextBox.Text; int CatID = Convert.ToInt32(CategoryDropDownList.SelectedItem.Value); string Item_Description = DescTextBox.Text; string UnitOfMeasure = UoMTextBox.Text; double UnitCost = Convert.ToDouble(UPTextBox.Text); int Priority1 = Convert.ToInt32(Priority1DropDownList.SelectedItem.Value); int Priority2 = Convert.ToInt32(Priority2DropDownList.SelectedItem.Value); int Priority3 = Convert.ToInt32(Priority3DropDownList.SelectedItem.Value); List <String> l = SupplierBizLogic.ListAllItem(); Boolean check = true; for (int i = 0; i < l.Count; i++) { if (ItemID == l[i]) { check = false; } } if (check == true) { try { SupplierBizLogic.AddItem(ItemID, CatID, Item_Description, UnitOfMeasure, UnitCost, Priority1, Priority2, Priority3); //Response.Redirect("Default2.aspx?username="******"<script>alert('Item Added to Inventory!');</script>"); ItemIdTextBox.Text = ""; CategoryDropDownList.SelectedIndex = 0; DescTextBox.Text = ""; UoMTextBox.Text = ""; UPTextBox.Text = ""; Priority1DropDownList.SelectedIndex = 0; Priority2DropDownList.SelectedIndex = 0; Priority3DropDownList.SelectedIndex = 0; //send mail to clerk String from = "*****@*****.**"; List <String> toAddress = MailBizLogic.ClerkEmail(); String subject = "[Auto Notification] Added new item"; String body = String.Format("New item - {0} has been added to the inventory. Check inventory for further details." + "\n\nNote: This is an auto-generated email. Please do not reply to this email." + "\n\nThis email is confidential and may be privileged.If you are not the intended recipient, " + "please delete it and notify us immediately; you should not copy or use it for any purpose, " + "nor disclose its contents to any other person.\n\nThank you.", Item_Description); foreach (String to in toAddress) { MailBizLogic.sendMail(from, to, subject, body); } } catch (Exception exp) { Response.Write(exp.ToString()); } } else { Response.Write("<script>alert('Item Already Exist');</script>"); } }