protected void btnGenerate_Click(object sender, EventArgs e) { rptGRNPreApproval rpt = new rptGRNPreApproval(); DataTable dtbl = GRNApprovalModel.GetGRNsForPreApproval(CurrentWarehouse, new Guid(ddlLIC.SelectedValue)); rpt.DataSource = dtbl; WebViewer1.Report = rpt; }
protected void GRNApprovalByLIC() { countError = 0; DateTime GRNCreationDate; string dateEntered; string timeEntered; string GRNNo; string GRN_No; Messages1.ClearMessage(); string GRNApprovalXML = "<GRNApproval>"; foreach (GridViewRow gvr in this.grvGRNApproval.Rows) { if (((CheckBox)gvr.FindControl("chkSelect")).Checked == true) { // check if date and time is not empty dateEntered = ((TextBox)grvGRNApproval.Rows[gvr.RowIndex].FindControl("txtDateTimeLICSigned")).Text; timeEntered = ((TextBox)grvGRNApproval.Rows[gvr.RowIndex].FindControl("txtTimeLICSigned")).Text; GRNNo = grvGRNApproval.DataKeys[gvr.RowIndex].Value.ToString(); GRN_No = ((Label)grvGRNApproval.Rows[gvr.RowIndex].FindControl("lblGRNNo")).Text; GRNCreationDate = DateTime.Parse(((Label)grvGRNApproval.Rows[gvr.RowIndex].FindControl("lblGRNCreatedDate")).Text); if (isValidDateTime(dateEntered, timeEntered, GRNCreationDate)) { GRNApprovalXML += "<GRNApprovalItem> <ID>" + GRNNo + "</ID>" + "<LICApprovedBy>" + UserBLL.CurrentUser.UserId + "</LICApprovedBy>" + "<LICApprovedDateTime>" + dateEntered + " " + timeEntered + "</LICApprovedDateTime>" + "<LICApprovedTimeStamp>" + DateTime.Now + "</LICApprovedTimeStamp>" + "<LICStatus>" + ((DropDownList)grvGRNApproval.Rows[gvr.RowIndex].FindControl("drpLICStatus")).SelectedValue + "</LICStatus>" + "<Status>" + 2 + "</Status>" + "</GRNApprovalItem>"; } } } if (countError == 0) { try { GRNApprovalXML += "</GRNApproval>"; GRNApprovalModel.ApproveGRN(GRNApprovalXML); BindGRNApprovalGridview(); Messages1.SetMessage("Approved successfully.", WarehouseApplication.Messages.MessageType.Success); ///////BindLIC(status); } catch (Exception ex) { Messages1.SetMessage(ex.Message, WarehouseApplication.Messages.MessageType.Error); } } else { btnApprove.Style["visibility"] = "visible"; } }
public void BindLIC(int status) { //ddlLIC.Items.Clear(); //ddlLIC.Items.Add(new ListItem("Select LIC", "")); ddlLIC.DataSource = GRNApprovalModel.GetLICsForGRNApproval(CurrentWarehouse, status); ddlLIC.DataTextField = "Name"; ddlLIC.DataValueField = "ID"; ddlLIC.DataBind(); }
protected void btnApprove_Click(object sender, EventArgs e) { DateTime GRNCreationDate; string dateEntered; string timeEntered; string GRNNo; string GRN_No; Messages1.ClearMessage(); countError = 0; string GRNApprovalXML = "<GRNApproval>"; foreach (GridViewRow gvr in this.grvGRNClientSign.Rows) { if (((CheckBox)gvr.FindControl("chkSelect")).Checked == true) { // check if date and time is not empty dateEntered = ((TextBox)grvGRNClientSign.Rows[gvr.RowIndex].FindControl("txtDateTimeLICSigned")).Text; timeEntered = ((TextBox)grvGRNClientSign.Rows[gvr.RowIndex].FindControl("txtTimeLICSigned")).Text; GRNNo = grvGRNClientSign.DataKeys[gvr.RowIndex].Value.ToString(); GRN_No = ((Label)grvGRNClientSign.Rows[gvr.RowIndex].FindControl("lblGRNNo")).Text; GRNCreationDate = DateTime.Parse(((Label)grvGRNClientSign.Rows[gvr.RowIndex].FindControl("lblGRNCreatedDate")).Text); if (isValidDateTime(dateEntered, timeEntered, GRNCreationDate)) { GRNApprovalXML += "<GRNApprovalItem> <GRNID>" + GRNNo + "</GRNID>" + "<CreatedBy>" + UserBLL.CurrentUser.UserId + "</CreatedBy>" + "<ClientSignedDate>" + dateEntered + " " + timeEntered + "</ClientSignedDate>" + "<CreatedTimeStamp>" + DateTime.Now + "</CreatedTimeStamp>" + "</GRNApprovalItem>"; } } } GRNApprovalXML += "</GRNApproval>"; if (countError == 0) { try { GRNApprovalModel.GRNSigned(GRNApprovalXML); BindGRNClientSignGridView(); btnApprove.Style["visibility"] = "hidden"; Messages1.SetMessage("Signed successfully.", WarehouseApplication.Messages.MessageType.Success); BindLIC(0); } catch (Exception ex) { Messages1.SetMessage(ex.Message, WarehouseApplication.Messages.MessageType.Error); } } else { btnApprove.Style["visibility"] = "visible"; } }
public void BindLIC(int status) { ddLIC.Items.Clear(); ddLIC.DataSource = GRNApprovalModel.GetAllLICs(new Guid(Session["CurrentWarehouse"].ToString())); ddLIC.DataTextField = "Name"; ddLIC.DataValueField = "ID"; ddLIC.Items.Add(new ListItem("Select LIC", null)); ddLIC.DataBind(); }
public void BindWHShed(Guid LIC) { DDLShed.Items.Clear(); DDLShed.DataSource = GRNApprovalModel.GetWHShedsbyLIC(new Guid(Session["CurrentWarehouse"].ToString()), LIC); DDLShed.DataTextField = "ShedNumber"; DDLShed.DataValueField = "ID"; DDLShed.Items.Add(new ListItem("Select Shed . . .", null)); DDLShed.DataBind(); }
protected void GRNApprovalEdit() { string dateEntered; string timeEntered; Guid GRNNo; string GRN_No; int response; Messages1.ClearMessage(); int countError = 0; dateEntered = ((TextBox)grvGRNApproval.Rows[0].FindControl("txtDateTimeLICSigned")).Text; timeEntered = ((TextBox)grvGRNApproval.Rows[0].FindControl("txtTimeLICSigned")).Text; GRNNo = new Guid(grvGRNApproval.DataKeys[0].Value.ToString()); GRN_No = ((Label)grvGRNApproval.Rows[0].FindControl("lblGRNNo")).Text; response = int.Parse(((DropDownList)grvGRNApproval.Rows[0].FindControl("drpLICStatus")).SelectedValue); if (dateEntered == "" || timeEntered == "") { Messages1.SetMessage("Enter values to GRN No: <b>" + GRN_No + "</b><br/>", WarehouseApplication.Messages.MessageType.Warning); countError++; } if (countError == 0) { try { GRNApprovalModel.UpdateGRNSupervisorApproval(GRNNo, UserBLL.CurrentUser.UserId, response, (DateTime.Parse(dateEntered + " " + timeEntered)), DateTime.Now); // if Superevisor Accept it create WarehouseReciept.... if (response == 1) { GRN_BL objGrnNew = new GRN_BL(); GRNBLL objGrnOld = objGrnNew.GetWarehouseReciptByGRNNumber(GRN_No); WarehouseRecieptBLL objWR = new WarehouseRecieptBLL(objGrnOld); objWR.Save(); } BindGRNApprovalGridviewForEdit(); Messages1.SetMessage("Updated successfully.", Messages.MessageType.Success); } catch (Exception ex) { Messages1.SetMessage(ex.Message, Messages.MessageType.Error); } } else { btnApprove.Style["visibility"] = "visible"; } }
public void UpdateGRNs() { string GRNNo = txtGRNNo.Text; Guid LICName2Id = new Guid(ddLIC.SelectedValue.ToString()); string LICName2 = ddLIC.SelectedItem.ToString(); string quad = TxtQuadrant.Text;; string Shed = DDLShed.SelectedItem.ToString(); //GRN_BL objGrnNew = new GRN_BL(); //GRNBLL objGrnOld = objGrnNew.GetWarehouseReciptByGRNNumber(GRNNo); GRNApprovalModel.EditGRNToWarehouse(GRNNo, Shed, LICName2Id, quad); //WarehouseRecieptBLL objWR = new WarehouseRecieptBLL(objGrnOld); }
public void BindGRNApprovalGridview() { if (ddLIC.SelectedValue != "") { DataTable dt = GRNApprovalModel.GetGRNForApproval(new Guid(Session["CurrentWarehouse"].ToString()), 2, new Guid(ddLIC.SelectedValue), txtGRNNo.Text, txtClientId.Text); ViewState.Add("dtblI", dt); grvGRNApproval.DataSource = dtblI; grvGRNApproval.DataBind(); if (dtblI.Rows.Count == 0) { BindLIC(2); } } }
public void BindGRNApprovalGridviewForEdit() { dtbl = GRNApprovalModel.GetGRNApprovalForSupervisorEdit(CurrentWarehouse, GRNID); grvGRNApproval.DataSource = dtbl; grvGRNApproval.DataBind(); if (dtbl.Rows[0]["ApprovedStatus"].ToString() == "1") // if Supervisor already accept it, Can't Edit { grvGRNApproval.Enabled = false; } else { ((DropDownList)grvGRNApproval.Rows[0].FindControl("drpLICStatus")).SelectedValue = "2"; } lblDetail.Text = "Supervisor GRN Approval Edit"; }
public void BindGRNApprovalGridviewForEdit() { DataTable dt = GRNApprovalModel.GetGRNApprovalForEdit(new Guid(Session["CurrentWarehouse"].ToString()), new Guid(Request.QueryString["GRNID"].ToString())); ViewState.Add("dtblE", dt); grvGRNApproval.DataSource = dtblE; grvGRNApproval.DataBind(); ((DropDownList)grvGRNApproval.Rows[0].FindControl("drpLICStatus")).SelectedValue = dtblE.Rows[0]["ApprovedStatus"].ToString(); if (Request.QueryString["GRNStatus"] == "3") // LIC can't edit if Supervisor already Approve { grvGRNApproval.Enabled = false; } lblDetail.Text = "Data assistant GRN Approval Edit"; }
protected void GRNApprovalEdit() { DateTime GRNCreationDate; string dateEntered; string timeEntered; Guid GRNNo; string GRN_No; int response; Messages1.ClearMessage(); dateEntered = ((TextBox)grvGRNApproval.Rows[0].FindControl("txtDateTimeLICSigned")).Text; timeEntered = ((TextBox)grvGRNApproval.Rows[0].FindControl("txtTimeLICSigned")).Text; GRNNo = new Guid(grvGRNApproval.DataKeys[0].Value.ToString()); GRN_No = ((Label)grvGRNApproval.Rows[0].FindControl("lblGRNNo")).Text; response = int.Parse(((DropDownList)grvGRNApproval.Rows[0].FindControl("drpLICStatus")).SelectedValue); GRNCreationDate = DateTime.Parse(((Label)grvGRNApproval.Rows[0].FindControl("lblGRNCreatedDate")).Text); if (isValidDateTime(dateEntered, timeEntered, GRNCreationDate)) { try { GRNApprovalModel.UpdateGRNApproval(GRNNo, UserBLL.CurrentUser.UserId, response, (DateTime.Parse(dateEntered + " " + timeEntered)), DateTime.Now); BindGRNApprovalGridviewForEdit(); Messages1.SetMessage("Updated successfully.", Messages.MessageType.Success); } catch (Exception ex) { Messages1.SetMessage(ex.Message, Messages.MessageType.Error); } } else { btnApprove.Style["visibility"] = "visible"; } }
protected void GRNApprovalBySupervisor() { string dateEntered; string timeEntered; string GRNNo; string GRN_No; int response; Messages1.ClearMessage(); int countError = 0; string GRNApprovalXML = "<GRNApproval>"; foreach (GridViewRow gvr in this.grvGRNApproval.Rows) { if (((CheckBox)gvr.FindControl("chkSelect")).Checked == true) { // check if date and time is not empty dateEntered = ((TextBox)grvGRNApproval.Rows[gvr.RowIndex].FindControl("txtDateTimeLICSigned")).Text; timeEntered = ((TextBox)grvGRNApproval.Rows[gvr.RowIndex].FindControl("txtTimeLICSigned")).Text; GRNNo = grvGRNApproval.DataKeys[gvr.RowIndex].Value.ToString(); GRN_No = ((Label)grvGRNApproval.Rows[gvr.RowIndex].FindControl("lblGRNNo")).Text; response = int.Parse(((DropDownList)grvGRNApproval.Rows[0].FindControl("drpLICStatus")).SelectedValue); // if Superevisor Accept it create WarehouseReciept.... if (response == 1) { GRN_BL objGrnNew = new GRN_BL(); GRNBLL objGrnOld = objGrnNew.GetWarehouseReciptByGRNNumber(GRN_No); WarehouseRecieptBLL objWR = new WarehouseRecieptBLL(objGrnOld); objWR.Save(); } if (dateEntered == "" || timeEntered == "") { Messages1.SetMessage("Enter values to GRN No: <b>" + GRN_No + "</b><br/>", WarehouseApplication.Messages.MessageType.Warning); countError++; } if (countError == 0) { GRNApprovalXML += "<GRNApprovalItem> <ID>" + GRNNo + "</ID>" + "<WarehouseSupervisorApprovedBy>" + UserBLL.CurrentUser.UserId + "</WarehouseSupervisorApprovedBy>" + "<WarehouseSupervisorApprovedDateTime>" + dateEntered + " " + timeEntered + "</WarehouseSupervisorApprovedDateTime>" + "<WarehouseSupervisorApprovedTimeStamp>" + DateTime.Now + "</WarehouseSupervisorApprovedTimeStamp>" + "<WarehouseSupervisorStatus>" + response + "</WarehouseSupervisorStatus>" + "<Status>" + 3 + "</Status>" + "<StackID>" + ((Label)grvGRNApproval.Rows[gvr.RowIndex].FindControl("lblStackID")).Text + "</StackID>" + "</GRNApprovalItem>"; } } } if (countError == 0) { try { GRNApprovalXML += "</GRNApproval>"; GRNApprovalModel.ApproveGRNBySupervisor(GRNApprovalXML); BindGRNApprovalGridview(); Messages1.SetMessage("Approved successfully.", Messages.MessageType.Success); BindLIC(status); } catch (Exception ex) { Messages1.SetMessage(ex.Message, Messages.MessageType.Error); } } else { btnApprove.Style["visibility"] = "visible"; } }
public void BindGRNApprovalGridview() { dtbl1 = GRNApprovalModel.GetGRNForApproval(CurrentWarehouse, status, new Guid(ddLIC.SelectedValue), txtGRNNo.Text, txtClientId.Text); grvGRNApproval.DataSource = dtbl1; grvGRNApproval.DataBind(); }
protected void grvGRNApproval_SelectedIndexChanged(object sender, EventArgs e) { Guid ID, StackID; DateTime LICApprovedDate; string dateEntered, timeEntered, GRN_No, message; int response; ID = new Guid(grvGRNApproval.SelectedDataKey.Value.ToString()); StackID = new Guid(((Label)grvGRNApproval.SelectedRow.FindControl("lblStackID")).Text); dateEntered = ((TextBox)grvGRNApproval.SelectedRow.FindControl("txtDateTimeLICSigned")).Text; timeEntered = ((TextBox)grvGRNApproval.SelectedRow.FindControl("txtTimeLICSigned")).Text; GRN_No = ((Label)grvGRNApproval.SelectedRow.FindControl("lblGRNNo")).Text; response = int.Parse(((DropDownList)grvGRNApproval.SelectedRow.FindControl("drpLICStatus")).SelectedValue); LICApprovedDate = DateTime.Parse(((Label)grvGRNApproval.SelectedRow.FindControl("lblGRNCreatedDate")).Text); if (isValidDateTime(dateEntered, timeEntered, LICApprovedDate)) { try { if (((bool)ViewState["edit"])) { GRNApprovalModel.UpdateGRNSupervisorApproval(ID, UserBLL.CurrentUser.UserId, response, DateTime.Parse(dateEntered + " " + timeEntered), DateTime.Now); BindGRNApprovalGridviewForEdit(); message = "Updated successfully."; } else { if (response == 1) //if Superevisor Accept it create WarehouseReciept.... { GRN_BL objGrnNew = new GRN_BL(); GRNBLL objGrnOld = objGrnNew.GetWarehouseReciptByGRNNumber(GRN_No); // Create the TransactionScope to execute the commands TransactionOptions option = new TransactionOptions(); option.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; option.Timeout = new TimeSpan(0, 0, 60); using (TransactionScope transaction = new TransactionScope(TransactionScopeOption.Required, option)) { GRNApprovalModel.ApproveGRNBySupervisor(ID, StackID, UserBLL.CurrentUser.UserId, response, DateTime.Parse(dateEntered + " " + timeEntered), DateTime.Now); BindGRNApprovalGridview(); //create WarehouseReciept WarehouseRecieptBLL objWR = new WarehouseRecieptBLL(objGrnOld); objWR.Save2(); // The Complete method commits the transaction transaction.Complete(); } } else { GRNApprovalModel.ApproveGRNBySupervisor(ID, StackID, UserBLL.CurrentUser.UserId, response, DateTime.Parse(dateEntered + " " + timeEntered), DateTime.Now); BindGRNApprovalGridview(); } message = "Approved successfully"; Messages1.SetMessage(message, Messages.MessageType.Success); } } catch (Exception ex) { Messages1.SetMessage("Unable to save record. Please try again.", WarehouseApplication.Messages.MessageType.Error); } } }
public void BindGRNClientSignGridView() { dtbl = GRNApprovalModel.GetGRNForClientSign(CurrentWarehouse, txtGRNNo.Text, txtClientId.Text, new Guid(ddLIC.SelectedValue)); grvGRNClientSign.DataSource = dtbl; grvGRNClientSign.DataBind(); }