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