/***********************this confirm button simulates the scene after scanning QRcode (only for Test)**********************************/
/**********************To confirm specified dept disbursement**************************************************************/
protected void Button3_Click(object sender, EventArgs e)
{
int disburseID = Convert.ToInt32(ViewState["disburseID"]);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('you are generate the Disbursement " + disburseID + " ?')", true);
//here should send message box yes or no
DisbursementDAO disDAO = new DisbursementDAO();
//disburList
ConfirmBtn.Enabled = false;
disDAO.updateDisbursementStatus(Convert.ToInt32(ViewState["disburseID"]), "Completed");
disburseGridView.SelectedIndex = -1;
disburseBindGrid();
disburseUpdatePanel.Update();
disburseItemGridView.DataSource = null;
disburseItemGridView.DataBind();
//send email and notification to rep
SA45_Team09_LogicUEntities context = new SA45_Team09_LogicUEntities();
string repID = context.Departments.Where(x => x.deptID == deptid).Select(x => x.repStaffID).ToList().First();
string repName = context.DeptStaffs.Where(x => x.staffID == repID).Select(x => x.staffName).ToList().First();
string confirmDate = DateTime.Now.ToShortDateString();
NotificationDAO nDAO = new NotificationDAO();
nDAO.addDeptNotification(repID, "Disbursement " + disburseID + " is confirmed on " + confirmDate, DateTime.Now);
Email email = new Email();
email.sendConfirmedDisbursementEmailToRep(repName, confirmDate, disburseID.ToString());
}
protected void reSubmit_Click(object sender, EventArgs e)
{
SA45_Team09_LogicUEntities context = new SA45_Team09_LogicUEntities();
RequisitionDAO rdao = new RequisitionDAO();
Requisition newRequisition = new Requisition();
Requisition oldRequisition = rdao.findRequisitionByrequisitionId(reqID);
if (oldRequisition.status != "pending")
{
newRequisition.staffID = oldRequisition.staffID;
newRequisition.deptID = oldRequisition.deptID;
newRequisition.requisitionDate = DateTime.Now;
newRequisition.status = "pending";
context.Requisitions.Add(newRequisition);
var oldRequisitionItemsList = oldRequisition.RequisitionItems;
foreach (RequisitionItem item in oldRequisitionItemsList)
{
RequisitionItem newItem = new RequisitionItem();
newItem.requisitionID = newRequisition.requisitionID;
newItem.itemID = item.itemID;
newItem.requisitionQty = item.requisitionQty;
context.RequisitionItems.Add(newItem);
}
context.SaveChanges();
Response.Redirect("Emp_MyRequisition.aspx");
}
else
{
ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>win.alert('Warning', 'You can not resubmit a pending requisition！');</script>");
}
}
public int updateDisbursementItemByItemID(cartList_JSON cart_JSON, string disID)
{
List <WCFDisbursementCart> cart_wcf = cart_JSON.DiscartList;
int disID_int = Int32.Parse(disID);
using (SA45_Team09_LogicUEntities context = new SA45_Team09_LogicUEntities())
{
List <DisbursementItem> ldisitem = context.DisbursementItems.Where(x => x.disbursementID == (disID_int)).ToList();
for (int i = 0; i < cart_wcf.Count; i++)
{
foreach (var j in ldisitem)
{
if (j.itemID == cart_wcf[i].ItemID)
{
j.actualQty = cart_wcf[i].Actual;
break;
}
}
}
try
{
context.SaveChanges();
return(1);
}
catch (Exception e)
{
return(0);
}
}
}
protected void btnUpdateRep_Click(object sender, EventArgs e)
{
//Update
string newRepName = ddlEmp.SelectedValue;
DeptStaff newRep = new DeptStaff();
if (newRepName != "---Select Name---")
{
newRep = deptStaffDAO.findStaffByName(newRepName);
logInDept = newRep.deptID;
Department dept = deptDAO.findByDeptId(logInDept);
DeptStaff oldRep = deptStaffDAO.findDeptRep(logInDept);
deptStaffDAO.updateRepName(newRep, oldRep);
deptDAO.UpdateDeptRep(dept, newRep);
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Please Select Name First!')", true);
return;
}
//send feedback email and notification to employee
SA45_Team09_LogicUEntities context = new SA45_Team09_LogicUEntities();
string headID = Session["loginID"].ToString();
string headName = Session["loginName"].ToString();
string staffID = newRep.staffID;
string staffName = newRepName;
NotificationDAO nDAO = new NotificationDAO();
nDAO.addDeptNotification(staffID, headName + " chose you as representative. ", DateTime.Now);
Email email = new Email();
email.sendRepNotificationToEmployee(staffName, headName);
//Refesh display
DisplayCurrentRep(logInDept);
DisplayAvaliableEmp(logInDept);
ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>win.alert('', 'Successful！');</script>");
}
protected void submit_button_Click(object sender, EventArgs e)
{
string selectedStaffId = employee_dropList.SelectedValue.ToString();
if (textBox_startDate.Text != "" || textBox_endDate.Text != "")
{
DateTime sDate = Convert.ToDateTime(textBox_startDate.Text);
DateTime eDate = Convert.ToDateTime(textBox_endDate.Text);
if (IsValidDate(sDate, eDate))
{
delegateDAO.addDelegate(selectedStaffId, sDate, eDate);
bindData(deptID);
//send feedback email and notification to employee
SA45_Team09_LogicUEntities context = new SA45_Team09_LogicUEntities();
string headID = Session["loginID"].ToString();
string headName = Session["loginName"].ToString();
string staffID = selectedStaffId;
string staffName = context.DeptStaffs.Where(x => x.staffID == staffID).Select(x => x.staffName).ToList().First();
NotificationDAO nDAO = new NotificationDAO();
nDAO.addDeptNotification(staffID, headName + " delegate you as head from " + sDate + " to " + eDate, DateTime.Now);
Email email = new Email();
email.sendDelegateEmailToEmployee(staffName, headName, sDate.ToShortDateString(), eDate.ToShortDateString());
ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>win.alert('Notice', 'Delegated succussfully!');</script>");
}
else
{
ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>win.alert('Notice', 'Please select valid date!');</script>");
}
}
else
{
ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>win.alert('Notice', 'Please select valid date!');</script>");
}
}
protected void NotifyButton_Click(object sender, EventArgs e)
{
NotifyButton.Enabled = false;
//send email and notification to rep
Label s = disburseGridView.SelectedRow.FindControl("disburseIDLabel") as Label;
string a = s.Text;
int disburseID = Convert.ToInt32(a);
SA45_Team09_LogicUEntities context = new SA45_Team09_LogicUEntities();
Disbursement disbursement = disDAO.getDisbursmentbyId(disburseID);
string deptid = disbursement.deptID;
string repID = context.Departments.Where(x => x.deptID == deptid).Select(x => x.repStaffID).ToList().First();
string repName = context.DeptStaffs.Where(x => x.staffID == repID).Select(x => x.staffName).ToList().First();
string disbursementDate = disbursement.disburseDate.ToShortDateString();
string collectionPointID = context.Departments.Where(x => x.deptID == deptid).Select(x => x.collectionPointID).ToList().First();
string collectionPoint = context.CollectionPoints.Where(x => x.collectionPointID == collectionPointID).Select(x => x.description).ToList().First();
NotificationDAO nDAO = new NotificationDAO();
nDAO.addDeptNotification(repID, "Disbursement " + disbursement.disbursementID + " is confirmed on " + disbursementDate, DateTime.Now);
Email email = new Email();
email.sendDisbursementEmailToRep(repName, disbursementDate, collectionPoint);
}
protected void btn_SendToManager_Click(object sender, EventArgs e)
{
AdjustmentVoucher adjv = adjvdao.findAdjustmentVoucherByadjvId(adjvoucherID);
adjvdao.SendtoManageranother(adjv);//Method2
//send email and notification to rep
SA45_Team09_LogicUEntities context = new SA45_Team09_LogicUEntities();
string supervisorName = Session["loginName"].ToString();
StoreStaff manager = context.StoreStaffs.Where(x => x.role == "manager").ToList().First();
string managerID = manager.storeStaffID;
string managerName = manager.storeStaffName;
string confirmDate = DateTime.Now.ToShortDateString();
NotificationDAO nDAO = new NotificationDAO();
nDAO.addStoreNotification(managerID, supervisorName + " has send an adjustment voucher!" + confirmDate, DateTime.Now);
Email email = new Email();
email.sendAdjustmentEmailToManager(supervisorName, managerName);
Response.Redirect("./SS_ViewAdjustment.aspx");
}
protected void Btn_Reject_Click(object sender, EventArgs e)
{
string remark = TextBox_Remarks.Text;
Requisition req = reqDAO.findRequisitionByrequisitionId(reqID);
reqDAO.updateRequisition(req, remark, "Rejected");
//send feedback email and notification to employee
SA45_Team09_LogicUEntities context = new SA45_Team09_LogicUEntities();
string headID = Session["loginID"].ToString();
string headName = Session["loginName"].ToString();
string staffID = req.staffID;
string staffName = context.DeptStaffs.Where(x => x.staffID == staffID).Select(x => x.staffName).ToList().First();
string requisitionDate = req.requisitionDate.ToString();
NotificationDAO nDAO = new NotificationDAO();
nDAO.addDeptNotification(staffID, headName + " rejected your requisition on " + requisitionDate, DateTime.Now);
Email email = new Email();
email.sendFeedBackEmailToEmployee(staffName, headName, requisitionDate, "Rejected");
Response.Redirect("./DH_ViewPendingRequisition.aspx");
}
private void Initialize()
{
instance = new SA45_Team09_LogicUEntities();
}
protected void Submit_Click(object sender, EventArgs e)
{
string name = this.staffID;
SA45_Team09_LogicUEntities m = new DBEntities().getDBInstance();
List <AdjustmentVoucherItemcart> lac = new List <AdjustmentVoucherItemcart>();
lac = (List <AdjustmentVoucherItemcart>)Session["adjvcart"];
if (lac.Count > 0)
{
int num = 0;
int judge = 0;
foreach (Control i in cartRepeater.Items) //get Quantity
{
LinkButton deletebtn = i.FindControl("cart_deleteButton") as LinkButton; //get itemID
TextBox cartqty = i.FindControl("cart_qtyTextBox") as TextBox; //get quantity
TextBox cartrecord = i.FindControl("cart_recordTextBox") as TextBox; //get record
lac[num].ItemID = deletebtn.CommandArgument.ToString();
if (cartqty.Text.Trim() == "")
{
judge = 1;
break;
}
try
{
lac[num].Qty = Int32.Parse(cartqty.Text.ToString());
}
catch
{
judge = 1;
break;
}
if ((lac[num].Qty % 1 != 0) || (lac[num].Qty == 0))
{
judge = 1;
break;
}
if ((lac[num].Qty < 0) && (Math.Abs(lac[num].Qty) > itemDAO.getItemByitemID(lac[num].ItemID).First().qtyOnHand))
{
judge = 2;
break;
}
lac[num].Record = cartrecord.Text;
num++;
}
if (judge == 0)
{
AdjustmentVoucherDAO adjvdao = new AdjustmentVoucherDAO();
adjvdao.addAdjustmentVoucher(name, lac);
lac = new List <AdjustmentVoucherItemcart>();//clear the cart session
Session["adjvcart"] = lac;
//send email and notification to rep
SA45_Team09_LogicUEntities context = new SA45_Team09_LogicUEntities();
string clerkName = Session["loginName"].ToString();
StoreStaff supervisor = context.StoreStaffs.Where(x => x.role == "supervisor").ToList().First();
string supervisorID = supervisor.storeStaffID;
string supervisorName = supervisor.storeStaffName;
string confirmDate = DateTime.Now.ToShortDateString();
NotificationDAO nDAO = new NotificationDAO();
nDAO.addStoreNotification(supervisorID, clerkName + " has send an adjustment voucher!" + confirmDate, DateTime.Now);
Email email = new Email();
email.sendAdjustmentEmailToSupervisor(clerkName, supervisorName);
HttpContext.Current.Response.Redirect("SC_ViewAdjustmentVoucher.aspx");
}
else
{
if (judge == 1)
{
ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>win.alert('Notice', 'Input must be integer！');</script>");
}
else
{
ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>win.alert('Notice', 'Input must be lower than qty on hand！');</script>");
}
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage2", "alert('Nothing in cart')", true);
return;
}
}