internal int PurchaseReqApprovalByManagement(List <PRQ_Requisitions> lstPRQ_Requisitions)
{
try
{
foreach (PRQ_Requisitions aReq in lstPRQ_Requisitions)
{
PRQ_Requisitions obj = _context.PRQ_Requisitions.First(x => x.ReqNo == aReq.ReqNo && x.BarCode == aReq.BarCode);
obj.ManagementAppQty = aReq.ManagementAppQty;
obj.IsAcceptedByManagement = aReq.IsAcceptedByManagement;
obj.Status = aReq.Status;
//obj.Req_File = aReq.Req_File;
obj.RFile_Name = aReq.RFile_Name;
obj.RFile_Type = aReq.RFile_Type;
obj.File_Path = aReq.File_Path;
obj.Management_Status = aReq.Management_Status;
_context.SaveChanges();
}
_context.SaveChanges();
return(1);
}
catch (Exception)
{
throw;
}
}
protected void BtnSave_Click(object sender, EventArgs e)
{
try
{
PRQ_Requisitions aPRQ_Requisitions = new PRQ_Requisitions();
var result = aRequisionBll.GetRequisitionInfo(txtEID.Text);
if (result.Count > 0)
{
var objRequisitionInfo = result.First();
aPRQ_Requisitions.Old_Supervisor_EID = objRequisitionInfo.Supervisor_EID;
}
aPRQ_Requisitions.Supervisor_EID = ddlSupervisorEID.SelectedValue;
aRequisionBll.UpdateSupervisor(aPRQ_Requisitions, txtEID.Text);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Supervisor updated successfully for this employee')", true);
//lblMessage.Text = "Supervisor updated successfully for this employee.";
ClearForm();
}
catch
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Supervisor updating failed!')", true);
//lblMessage.Text = "<font color='red'>Supervisor update failed!</font>";
}
}
public int UpdateSupervisor(PRQ_Requisitions aPRQ_Requisitions, string eId)
{
try
{
PRQ_Requisitions requisition = _context.PRQ_Requisitions.First(x => x.EID == eId);
requisition.Old_Supervisor_EID = aPRQ_Requisitions.Old_Supervisor_EID;
requisition.Supervisor_EID = aPRQ_Requisitions.Supervisor_EID;
//requisition.EID = aPRQ_Requisitions.EID;
_context.SaveChanges();
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
internal int PurchaseReqApprovalBySupervisor2(List <PRQ_Requisitions> lstPRQ_Requisitions)
{
try
{
foreach (PRQ_Requisitions aReq in lstPRQ_Requisitions)
{
PRQ_Requisitions obj = _context.PRQ_Requisitions.First(x => x.ReqNo == aReq.ReqNo && x.BarCode == aReq.BarCode);
obj.Manager2ApproveQty = aReq.Manager2ApproveQty;
obj.IsAcceptedByManager2 = aReq.IsAcceptedByManager2;
//obj.Status = aReq.Status;
_context.SaveChanges();
}
_context.SaveChanges();
return(1);
}
catch (Exception)
{
throw;
}
}
protected void BtnSave_Click(object sender, EventArgs e)
{
try
{
List <PRQ_Requisitions> lstPRQ_Requisitions = new List <PRQ_Requisitions>();
foreach (GridViewRow gvr in grvReqItemList.Rows)
{
PRQ_Requisitions objPRQ_Requisitions = new PRQ_Requisitions();
Label lblReqNo = (Label)gvr.FindControl("lblReqNo");
Label lblBarcode = (Label)gvr.FindControl("lblBarcode");
TextBox txtApproveQty = (TextBox)gvr.FindControl("txtApproveQty");
int ApproveQty = int.Parse(txtApproveQty.Text);
//DropDownList ddlStatus = (DropDownList)gvr.FindControl("ddlStatus");
//string Status = ddlStatus.SelectedItem.Text;
objPRQ_Requisitions.Manager2ApproveQty = ApproveQty;
objPRQ_Requisitions.IsAcceptedByManager2 = true;
objPRQ_Requisitions.ReqNo = lblReqNo.Text;
objPRQ_Requisitions.BarCode = Convert.ToInt16(lblBarcode.Text);
//objPRQ_Requisitions.Status = Status;
lstPRQ_Requisitions.Add(objPRQ_Requisitions);
}
int result = aRequisionBll.PurchaseReqApprovalBySupervisor2(lstPRQ_Requisitions);
LoadRequisitions("");
grvReqItemList.DataSource = null;
grvReqItemList.DataBind();
//LoadRequisitionsItem(reqNo);
//lblMessage.Text = "Requisition Approved Successfully.";
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Requisition approved successfully')", true);
}
catch
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Error in approval!')", true);
//lblMessage.Text = "<font color='red'>Error in approval! Please try again</font>";
}
}
internal int StoreReqApprovalByAdmin(List <PRQ_Requisitions> lstPRQ_Requisitions)
{
try
{
foreach (PRQ_Requisitions aReq in lstPRQ_Requisitions)
{
PRQ_Requisitions obj = _context.PRQ_Requisitions.First(x => x.ReqNo == aReq.ReqNo && x.BarCode == aReq.BarCode);
obj.HeadApproveQty = aReq.HeadApproveQty;
obj.IsAcceptedByManager = aReq.IsAcceptedByManager;
obj.IsAcceptedByHead = aReq.IsAcceptedByHead;
obj.Status = aReq.Status;
obj.Admin_EID = aReq.Admin_EID;
_context.SaveChanges();
}
_context.SaveChanges();
return(1);
}
catch (Exception)
{
throw;
}
}
protected void BtnSave_Click(object sender, EventArgs e)
{
try
{
List <PRQ_Requisitions> lstPRQ_Requisitions = new List <PRQ_Requisitions>();
foreach (GridViewRow gvr in grvReqItemList.Rows)
{
PRQ_Requisitions objPRQ_Requisitions = new PRQ_Requisitions();
Label lblReqNo = (Label)gvr.FindControl("lblReqNo");
Label lblBarcode = (Label)gvr.FindControl("lblBarcode");
Label lblBalance = (Label)gvr.FindControl("lblBalance");
Label lblItem = (Label)gvr.FindControl("lblItem");
Label lblTotalAppQty = (Label)gvr.FindControl("lblTotalAppQty");
TextBox txtRemarks = (TextBox)gvr.FindControl("txtRemarks");
TextBox txtApproveQty = (TextBox)gvr.FindControl("txtApproveQty");
int ApproveQty = int.Parse(txtApproveQty.Text);
TextBox txtPrice = (TextBox)gvr.FindControl("txtPrice");
int itemPrice = int.Parse(txtPrice.Text);
DropDownList ddlStatus = (DropDownList)gvr.FindControl("ddlStatus");
string Status = ddlStatus.SelectedItem.Text;
objPRQ_Requisitions.HeadApproveQty = ApproveQty;
objPRQ_Requisitions.Price = itemPrice;
if (ddlStatus.SelectedItem.Text == "Re-Forward")
{
objPRQ_Requisitions.IsAcceptedByManager = false;
objPRQ_Requisitions.IsAcceptedByHead = false;
}
else if (ddlStatus.SelectedItem.Text == "Approve")
{
objPRQ_Requisitions.IsAcceptedByManager = true;
objPRQ_Requisitions.IsAcceptedByHead = true;
}
else
{
objPRQ_Requisitions.IsAcceptedByHead = false;
objPRQ_Requisitions.IsAcceptedByManager = true;
}
objPRQ_Requisitions.Remarks = txtRemarks.Text;
objPRQ_Requisitions.ReqNo = lblReqNo.Text;
objPRQ_Requisitions.BarCode = Convert.ToInt16(lblBarcode.Text);
objPRQ_Requisitions.Status = Status;
objPRQ_Requisitions.Admin_EID = hdnAdminEID.Value; //Approved By
//if (ApproveQty > (Convert.ToInt16(lblBalance.Text) - Convert.ToInt16(lblTotalAppQty.Text)))
//{
// lblMessage.Text = "<font color='red'>'" + lblItem.Text + "' approve quantity can not be larger than stock!</font>";
// return;
//}
//if (ApproveQty >= Convert.ToInt16(lblTotalAppQty.Text))
//{
// lblMessage.Text = "<font color='red'>" + lblItem.Text + " approve quantity exceeded!</font>";
// return;
//}
lstPRQ_Requisitions.Add(objPRQ_Requisitions);
}
int result = aRequisionBll.PurchaseReqApprovalByAdmin(lstPRQ_Requisitions);
LoadRequisitions("");
grvReqItemList.DataSource = null;
grvReqItemList.DataBind();
//LoadRequisitionsItem(reqNo);
//lblMessage.Text = "Data Recorded Successfully.";
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data recorded successfully')", true);
}
catch
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Adding Failure!')", true);
//lblMessage.Text = "<font color='red'>Data Adding Failure!</font>";
}
}
protected void BtnProcess_Click(object sender, EventArgs e)
{
try
{
List <PRQ_Requisitions> lstPRQ_Requisitions = new List <PRQ_Requisitions>();
//bool status = true;
bool CheckStatus = false;
foreach (GridViewRow gvRow in grvReqItemList.Rows)
{
CheckBox rowChkBox = ((CheckBox)gvRow.FindControl("rowLevelCheckBox"));
if (rowChkBox.Checked == true)
{
CheckStatus = true;
}
}
if (CheckStatus)
{
foreach (GridViewRow gvr in grvReqItemList.Rows)
{
PRQ_Requisitions objPRQ_Requisitions = new PRQ_Requisitions();
Label lblReqNo = (Label)gvr.FindControl("lblReqNo");
Label lblBarcode = (Label)gvr.FindControl("lblBarcode");
TextBox txtApproveQty = (TextBox)gvr.FindControl("txtApproveQty");
int ApproveQty = int.Parse(txtApproveQty.Text);
DropDownList ddlStatus = (DropDownList)gvr.FindControl("ddlStatus");
string Status = ddlStatus.SelectedItem.Text;
if (ddlStatus.SelectedItem.Text == "Re-Forward")
{
objPRQ_Requisitions.Status = "Re-Forward";
objPRQ_Requisitions.IsAcceptedByManager = false;
objPRQ_Requisitions.IsAcceptedByHead = false;
}
else if (ddlStatus.SelectedItem.Text == "Approved")
{
objPRQ_Requisitions.Status = "Pending";
objPRQ_Requisitions.ManagerApproveQty = ApproveQty;
objPRQ_Requisitions.IsAcceptedByManager = true;
}
else if (ddlStatus.SelectedItem.Text == "Cancel")
{
objPRQ_Requisitions.Status = "Cancel";
objPRQ_Requisitions.IsAcceptedByManager = false;
}
else if (ddlStatus.SelectedItem.Text == "Pending")
{
objPRQ_Requisitions.Status = "Pending";
objPRQ_Requisitions.IsAcceptedByManager = true;
}
objPRQ_Requisitions.ManagerApproveQty = ApproveQty;
objPRQ_Requisitions.ReqNo = lblReqNo.Text;
objPRQ_Requisitions.BarCode = Convert.ToInt16(lblBarcode.Text);
// objPRQ_Requisitions.Supervisor_EID = ddlSupervisor1EID.SelectedValue;
string EID = ((SessionUser)Session["SessionUser"]).EID;
objPRQ_Requisitions.Supervisor_EID = EID;
lstPRQ_Requisitions.Add(objPRQ_Requisitions);
}
int result = aRequisionBll.StoreReqApprovalBySupervisor(lstPRQ_Requisitions);
LoadRequisitions("");
grvReqItemList.DataSource = null;
grvReqItemList.DataBind();
//LoadRequisitionsItem(reqNo);
//lblMessage.Text = "Requisition Approved Successfully.";
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Requisition approved successfully')", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('No Item Selected!')", true);
}
}
catch (Exception ex)
{
//lblMessage.Text = "<font color='red'>Error in approval! Please try again</font>";
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
protected void BtnSave_Click(object sender, EventArgs e)
{
try
{
List <PRQ_Requisitions> lstPRQ_Requisitions = new List <PRQ_Requisitions>();
foreach (GridViewRow gvr in grvReqItemList.Rows)
{
PRQ_Requisitions objPRQ_Requisitions = new PRQ_Requisitions();
Label lblReqNo = (Label)gvr.FindControl("lblReqNo");
Label lblBarcode = (Label)gvr.FindControl("lblBarcode");
Label lblBalance = (Label)gvr.FindControl("lblBalance");
Label lblItem = (Label)gvr.FindControl("lblItem");
Label lblTotalAppQty = (Label)gvr.FindControl("lblTotalAppQty");
TextBox txtApproveQty = (TextBox)gvr.FindControl("txtApproveQty");
int ApproveQty = int.Parse(txtApproveQty.Text);
DropDownList ddlStatus = (DropDownList)gvr.FindControl("ddlStatus");
string Status = ddlStatus.SelectedItem.Text;
objPRQ_Requisitions.ManagementAppQty = ApproveQty;
if (ddlStatus.SelectedItem.Text == "Approve")
{
objPRQ_Requisitions.IsAcceptedByManagement = true;
objPRQ_Requisitions.Management_Status = "Approve";
}
else
{
objPRQ_Requisitions.IsAcceptedByManagement = false;
objPRQ_Requisitions.Management_Status = "Pending";
}
objPRQ_Requisitions.ReqNo = lblReqNo.Text;
string ReQNo = "Req";
String FILE_TYPE = Path.GetExtension(ReqFileUpload.FileName);
string FILE_NAME = Path.GetFileName(ReqFileUpload.PostedFile.FileName);
string OCODE = "8989";
string REQ = lblReqNo.Text;
EnsureTrackDirectoriesExist(ReQNo);
string DB_FILE_PATH = "" + ReQNo.ToString() + "\\" + REQ + FILE_NAME;
// ReqFileUpload.SaveAs(Server.MapPath("~/Requisition/Req_Document/" + "/" + FILE_NAME));
ReqFileUpload.SaveAs(Server.MapPath("~/Requisition/Req_Document/" + ReQNo.ToString() + "/" + REQ + FILE_NAME));
// objPRQ_Requisitions.Req_File = ReqFileUpload.FileBytes;
objPRQ_Requisitions.File_Path = DB_FILE_PATH;
objPRQ_Requisitions.BarCode = Convert.ToInt16(lblBarcode.Text);
objPRQ_Requisitions.RFile_Name = FILE_NAME;
objPRQ_Requisitions.RFile_Type = FILE_TYPE;
objPRQ_Requisitions.Status = Status;
//objPRQ_Requisitions.Admin_EID = hdnAdminEID.Value; //Approved By
//if (ApproveQty > (Convert.ToInt16(lblBalance.Text) - Convert.ToInt16(lblTotalAppQty.Text)))
//{
// lblMessage.Text = "<font color='red'>'" + lblItem.Text + "' approve quantity can not be larger than stock!</font>";
// return;
//}
//if (ApproveQty >= Convert.ToInt16(lblTotalAppQty.Text))
//{
// lblMessage.Text = "<font color='red'>" + lblItem.Text + " approve quantity exceeded!</font>";
// return;
//}
lstPRQ_Requisitions.Add(objPRQ_Requisitions);
}
int result = aRequisionBll.PurchaseReqApprovalByManagement(lstPRQ_Requisitions);
LoadRequisitions("");
grvReqItemList.DataSource = null;
grvReqItemList.DataBind();
//LoadRequisitionsItem(reqNo);
//lblMessage.Text = "Data Recorded Successfully.";
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data recorded successfully')", true);
}
catch
{
//lblMessage.Text = "<font color='red'>Data Adding Failure!</font>";
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data adding failure!')", true);
}
}
protected void BtnSave_Click(object sender, EventArgs e)
{
try
{
List <PRQ_Requisitions> lstPRQ_Requisitions = new List <PRQ_Requisitions>();
bool CheckStatus = false;
foreach (GridViewRow gvRow in grvReqItemList.Rows)
{
CheckBox rowChkBox = ((CheckBox)gvRow.FindControl("rowLevelCheckBox"));
if (rowChkBox.Checked == true)
{
CheckStatus = true;
}
}
if (CheckStatus)
{
foreach (GridViewRow gvr in grvReqItemList.Rows)
{
PRQ_Requisitions objPRQ_Requisitions = new PRQ_Requisitions();
Label lblReqNo = (Label)gvr.FindControl("lblReqNo");
Label lblBarcode = (Label)gvr.FindControl("lblBarcode");
Label lblBalance = (Label)gvr.FindControl("lblBalance");
Label lblItem = (Label)gvr.FindControl("lblItem");
Label lblTotalAppQty = (Label)gvr.FindControl("lblTotalAppQty");
TextBox txtApproveQty = (TextBox)gvr.FindControl("txtApproveQty");
int ApproveQty = int.Parse(txtApproveQty.Text);
DropDownList ddlStatus = (DropDownList)gvr.FindControl("ddlStatus");
string Status = ddlStatus.SelectedItem.Text;
objPRQ_Requisitions.HeadApproveQty = ApproveQty;
if (ddlStatus.SelectedItem.Text == "Re-Forward")
{
objPRQ_Requisitions.IsAcceptedByManager = false;
objPRQ_Requisitions.IsAcceptedByHead = false;
}
else if (ddlStatus.SelectedItem.Text == "Approve")
{
objPRQ_Requisitions.IsAcceptedByManager = true;
objPRQ_Requisitions.IsAcceptedByHead = true;
}
else if (ddlStatus.SelectedItem.Text == "Cancel")
{
objPRQ_Requisitions.Status = "Cancel";
objPRQ_Requisitions.IsAcceptedByManager = false;
}
else
{
objPRQ_Requisitions.IsAcceptedByHead = false;
objPRQ_Requisitions.IsAcceptedByManager = true;
}
//if (ddlStatus.SelectedItem.Text == "Approve")
//{
// objPRQ_Requisitions.IsAcceptedByHead = true;
//}
//else
//{
// objPRQ_Requisitions.IsAcceptedByHead = false;
//}
objPRQ_Requisitions.ReqNo = lblReqNo.Text;
objPRQ_Requisitions.BarCode = Convert.ToInt16(lblBarcode.Text);
objPRQ_Requisitions.Status = Status;
//objPRQ_Requisitions.Admin_EID = hdnAdminEID.Value; //Approved By
// objPRQ_Requisitions.Admin_EID = ddlSupervisor1EID.SelectedValue;
string EID = ((SessionUser)Session["SessionUser"]).EID;
objPRQ_Requisitions.Admin_EID = EID;
//if (ApproveQty > (Convert.ToInt16(lblBalance.Text) - Convert.ToInt16(lblTotalAppQty.Text)))
//{
// lblMessage.Text = "<font color='red'>'" + lblItem.Text + "' approve quantity can not be larger than stock!</font>";
// return;
//}
//if (ApproveQty >= Convert.ToInt16(lblTotalAppQty.Text))
//{
// lblMessage.Text = "<font color='red'>" + lblItem.Text + " approve quantity exceeded!</font>";
// return;
//}
lstPRQ_Requisitions.Add(objPRQ_Requisitions);
}
int result = aRequisionBll.StoreReqApprovalByAdmin(lstPRQ_Requisitions);
LoadRequisitions("");
grvReqItemList.DataSource = null;
grvReqItemList.DataBind();
//LoadRequisitionsItem(reqNo);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data recorded successfully')", true);
//lblMessage.Text = "Data Recorded Successfully.";
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('No Item Selected!')", true);
}
}
catch (Exception ex)
{
//lblMessage.Text = "<font color='red'>Error in approval! Please try again</font>";
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
public int UpdateSupervisor(PRQ_Requisitions aPRQ_Requisitions, string eId)
{
return(aRequisitionDAL.UpdateSupervisor(aPRQ_Requisitions, eId));
}
