protected void BtnSave_Click(object sender, EventArgs e)
{
try
{
if (int.Parse(txtApproveQty.Text) <= 0)
{
// lblMessage.Text = "<font color='red'>Sorry! Invalid data. Approve quantity cannot be zero or negetive. Please enter correct data</font>";
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Sorry! Invalid data. Approve quantity cannot be zero or negetive. Please enter correct data')", true);
return;
}
int Id = int.Parse(hdnId.Value);
int ApproveQty = int.Parse(txtApproveQty.Text);
if (RequisionBll.Approve(Id, ApproveQty, "Head"))
{
// lblMessage.Text = "<font color='green'>" + txtProduct.Text + " with quantity " + txtApproveQty.Text + " has been approved!</font>";
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Product has been approved')", true);
txtReqNo.Text = "";
LoadRequisitions(txtReqNo.Text);
ClearForm();
}
else
{
// not success
lblMessage.Text = "<font color='red'>Error in approval! Please try again</font>";
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Error in approval! Please try again')", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
private void LoadRequisitions(string EID)
{
Guid userId = ((SessionUser)Session["SessionUser"]).UserId;
grdRequisition.DataSource = RequisionBll.GetStoreRequisition(userId, EID, "DPT");
grdRequisition.DataBind();
}
private void LoadForm(string Id)
{
DataTable dt = new DataTable();
try
{
dt = RequisionBll.GetSelectedProductToDeliver(Id);
foreach (DataRow dr in dt.Rows)
{
ddlRequisition.SelectedValue = dr["ReqNo"].ToString();;
txtDepartment.Text = dr["DPT_NAME"].ToString();
hdnEID.Value = dr["EID"].ToString();
txtBalQty.Text = dr["BalQty"].ToString();
txtDelQty.Text = dr["Qty"].ToString();
txtProductName.Text = dr["ProductName"].ToString();
txtUnit.Text = dr["UnitName"].ToString();
hdnBarCode.Value = dr["BarCode"].ToString();
txtChalanNo.Text = aChallanBll.GetNewChalanNo(dr["DPT_NAME"].ToString(), DateTime.Parse(txtTransferDate.Text), "DPT");
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
protected void btnPost_Click(object sender, EventArgs e)
{
Hashtable ht = new Hashtable();
if (grdRequisition.Rows.Count == 0)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('No item selected for requisition!')", true);
return;
}
BindRequisitionNo();
//if (RequisionBll.AddStore_Requisition(ht))
RequisionBll aReqBll = new RequisionBll();
var result = aReqBll.AddTempToStoreReq(txtRequisitionNo.Text.ToString());
if (result == 1)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Requisition added successfully')", true);
//lblMessage.Text = "<font color='green'>Requisition for this item added successfully!</font>";
//LoadRequisitions(txtRequisitionNo.Text);
ClearFullForm();
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Error in adding requisition!')", true);
//lblMessage.Text = "<font color='red'>Error in adding requisition! Please try again</font>";
}
}
//shabda...
private void ShowRequisitionData()
{
string QNO = Session["RequisitionNo"].ToString();
DataTable dt = new DataTable();
dt = RequisionBll.GetStoreRequisitions(QNO);
if (dt.Rows.Count != null)
{
foreach (DataRow dr in dt.Rows)
{
//txtEID.Text = dr["EID"].ToString();
txtRequisitionNo.Text = dr["ReqNo"].ToString();
txtDate.Text = Convert.ToDateTime(dr["ReqDate"]).ToShortDateString();
txtRequisitionNo.Text = dr["ReqNo"].ToString();
txtExpectedDate.Text = Convert.ToDateTime(dr["DesiredRcvDate"]).ToShortDateString();
LoadEmployeeLists();
ddlEmployee.SelectedValue = dr["EID"].ToString();
FillDepartment();
ddlDepartment.SelectedValue = dr["DPT_CODE"].ToString();
txtDesignation.Text = dr["DEG_NAME"].ToString();
// ddlDepartment.SelectedValue = dr["DPT_CODE"].ToString();
txtJustification.Text = dr["Reason_Justification"].ToString();
BtnSave.Text = "Update";
}
}
}
private void FillRequisitionCombo()
{
ddlRequisition.DataSource = RequisionBll.GetUniqueRequisitionsToDeliver();
ddlRequisition.DataValueField = "ReqNo";
ddlRequisition.DataTextField = "ReqNo";
ddlRequisition.DataBind();
ddlRequisition.Items.Insert(0, new ListItem("Select One", "0"));
}
private void LoadRequisitions(string ReqNo)
{
string DPT_CODE = ddlDepartment.SelectedValue;
string Status = ddlStatus.SelectedItem.Text;
string FromDate = txtFromDate.Text;
string ToDate = txtToDate.Text;
grdRequisition.DataSource = RequisionBll.GetPendingPurchaseRequisitionForAdmin(ReqNo, "Head", DPT_CODE, Status, FromDate, ToDate);
grdRequisition.DataBind();
}
//private void LoadRequisitions(string ReqNo)
//{
// string FromDate = txtFromDate.Text;
// string ToDate = txtToDate.Text;
// grdRequisition.DataSource = RequisionBll.GetPendingPurchaseRequisition(ReqNo, "Manager");
// grdRequisition.DataBind();
//}
private void LoadRequisitions(string ReqNo)
{
//string FromDate = txtFromDate.Text;
//string ToDate = txtToDate.Text;
//grdRequisition.DataSource = RequisionBll.GetPendingPurchaseRequisitionByDateToDate(ReqNo, "Manager", FromDate, ToDate);
//grdRequisition.DataBind();
grdRequisition.DataSource = RequisionBll.GetPendingPurchaseRequisition(ReqNo, "Manager");
grdRequisition.DataBind();
}
protected void BtnSave_Click(object sender, EventArgs e)
{
try
{
string BarCode = ddlProduct.SelectedValue;
string Quantity = txtQuantity.Text;
string ReqDate = txtDate.Text;
if (BarCode == "" || Quantity == "" || ReqDate == "" || ddlDepartment.SelectedValue == "0" || ddlEmployee.SelectedValue == "0" || txtRequisitionNo.Text == "")
{
return;
}
if (int.Parse(txtQuantity.Text) <= 0)
{
// lblMessage.Text = "<font color='red'>Sorry! Invalid data. Requisition quantity cannot be zero or negetive. Please enter correct data</font>";
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Sorry! Invalid data. Requisition quantity cannot be zero or negetive. Please enter correct data')", true);
return;
}
try
{
Hashtable ht = new Hashtable();
ht.Add("ReqNo", txtRequisitionNo.Text);
ht.Add("ReqType", "FROM_DPT_EMP");
ht.Add("CompanyCode", "");
ht.Add("DPT_CODE", ddlDepartment.SelectedValue);
ht.Add("EID", ddlEmployee.SelectedValue);
ht.Add("BarCode", ddlProduct.SelectedValue);
ht.Add("Qty", txtQuantity.Text);
ht.Add("ReqDate", txtDate.Text);
ht.Add("DesiredRcvDate", txtExpectedDate.Text);
ht.Add("OCode", ((SessionUser)Session["SessionUser"]).OCode);
if (RequisionBll.AddRequisition(ht))
{
//lblMessage.Text = "<font color='green'>Requisition for this product has been inserted successfully!</font>";
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Requisition for this product has been inserted successfully!')", true);
LoadRequisitions(txtRequisitionNo.Text);
ClearForm();
}
else
{
// lblMessage.Text = "<font color='red'>Error in adding requisition! Please try again</font>";
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Error in adding requisition! Please try again')", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
private void ShowRequisitionDataForGrid()
{
string QNO = Session["RequisitionNo"].ToString();
DataTable dt = new DataTable();
dt = RequisionBll.GetRequisitionGrid(QNO);
if (dt.Rows.Count != null)
{
grdRequisition.DataSource = dt;
grdRequisition.DataBind();
}
}
private void LoadRequisitionsearch()
{
string ReqNo = "";
DataTable dt = new DataTable();
dt = RequisionBll.GetAll_PurchaseReqList(ReqNo, "Head", hdnEID.Value, txtFromDate.Text, txtToDate.Text);
if (dt.Rows.Count > 0)
{
grdRequisition.DataSource = dt;
grdRequisition.DataBind();
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('No purchase requisition found!')", true);
grdRequisition.DataSource = null;
grdRequisition.DataBind();
}
}
private void SearcheByDepartment()
{
// string ReqNo = "";
string DEPT = ddlDepartment.SelectedValue;
DataTable dt = new DataTable();
dt = RequisionBll.GetAllRequisitionByDepartment("Management", DEPT);
if (dt.Rows.Count > 0)
{
grdRequisition.DataSource = dt;
grdRequisition.DataBind();
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('No purchase requisition found!')", true);
grdRequisition.DataSource = null;
grdRequisition.DataBind();
}
}
private void LoadRequisitionsearch()
{
string ReqNo = "";
string Dept = ddlDepartment.SelectedValue;
DataTable dt = new DataTable();
dt = RequisionBll.GetAll_StoreReqListByDepartment(ReqNo, "Head", ddlEmployee.SelectedValue, txtFromDate.Text, txtToDate.Text, Dept);
if (dt.Rows.Count > 0)
{
grdRequisition.DataSource = dt;
grdRequisition.DataBind();
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('No store requisition found!')", true);
grdRequisition.DataSource = null;
grdRequisition.DataBind();
}
}
private void SearcheByDPT()
{
//string ReqNo = "";
string DPT_CODE = ddlDepartment.SelectedValue;
DataTable dt = new DataTable();
dt = RequisionBll.GetPendingPurchaseRequisitionForAdminByDPTCasceding("Head", DPT_CODE);
if (dt.Rows.Count > 0)
{
grdRequisition.DataSource = dt;
grdRequisition.DataBind();
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('No purchase requisition found!')", true);
grdRequisition.DataSource = null;
grdRequisition.DataBind();
}
}
private void SearcheByStatus()
{
// string ReqNo = "";
string Status = ddlStatus.SelectedItem.Text;
DataTable dt = new DataTable();
dt = RequisionBll.GetPendingListForManager("Head", Status);
if (dt.Rows.Count > 0)
{
grdRequisition.DataSource = dt;
grdRequisition.DataBind();
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('No purchase requisition found!')", true);
grdRequisition.DataSource = null;
grdRequisition.DataBind();
}
}
protected void btnPost_Click(object sender, EventArgs e)
{
Hashtable ht = new Hashtable();
//ht.Add("ReqNo", txtRequisitionNo.Text);
//ht.Add("ReqType", "Purchase");
//ht.Add("CompanyCode", "");
//ht.Add("DPT_CODE", ddlDepartment.SelectedValue);
//ht.Add("EID", ddlEmployee.SelectedValue);
////ht.Add("BarCode", ddlProduct.SelectedValue);
//ht.Add("Qty", txtQuantity.Text);
//ht.Add("ReqDate", txtDate.Text);
//ht.Add("DesiredRcvDate", txtExpectedDate.Text);
//ht.Add("OCode", ((SessionUser)Session["SessionUser"]).OCode);
//ht.Add("RecomendBy", "n/a");
//ht.Add("Reason_Justification", txtJustification.Text);
//ht.Add("Remarks", txtRemarks.Text);
if (grdRequisition.Rows.Count == 0)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('No item selected for requisition!')", true);
return;
}
if (RequisionBll.AddPurchase_Requisition(ht))
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Requisition added successfully')", true);
//lblMessage.Text = "<font color='green'>Requisition for this item added successfully!</font>";
//LoadRequisitions(txtRequisitionNo.Text);
ClearFullForm();
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Error in adding requisition!')", true);
//lblMessage.Text = "<font color='red'>Error in adding requisition! Please try again</font>";
}
}
public void LoadRequisitions(string ReqNo)
{
grdRequisition.DataSource = RequisionBll.GetAllAcceptedRequisitions(ReqNo);//.GetRequisitionToApprove(ReqNo, "Head");
grdRequisition.DataBind();
}
private void LoadRequisitions(string ReqNo)
{
grdRequisition.DataSource = RequisionBll.GetStoreRequisition(ReqNo, "DPT");
grdRequisition.DataBind();
}
protected void BtnSave_Click(object sender, EventArgs e)
{
try
{
//shabda
if (BtnSave.Text == "Update")
{
if (ddlProduct.SelectedValue == "")
{
Hashtable ht = new Hashtable();
ht.Add("ReqNo", txtRequisitionNo.Text);
ht.Add("ReqType", "Purchase");
ht.Add("CompanyCode", "");
ht.Add("DPT_CODE", ddlDepartment.SelectedValue);
ht.Add("EID", ddlEmployee.SelectedValue);
ht.Add("OCode", ((SessionUser)Session["SessionUser"]).OCode);
ht.Add("RecomendBy", "n/a");
ht.Add("Reason_Justification", txtJustification.Text);
ht.Add("ReqDate", txtDate.Text);
ht.Add("DesiredRcvDate", txtExpectedDate.Text);
ht.Add("Remarks", txtRemarks.Text);
if (RequisionBll.updatepurchaseRequisition(ht) == false)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Requisition updated successfully')", true);
ShowRequisitionDataForGrid();
ClearForm();
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Requisition updating error!')", true);
//lblMessage.Text = "<font color='red'>Error in updating requisition! Please try again</font>";
}
}
else if (Convert.ToInt32(ddlProduct.SelectedValue) == 0)
{
Hashtable ht = new Hashtable();
ht.Add("ReqNo", txtRequisitionNo.Text);
ht.Add("ReqType", "Purchase");
ht.Add("CompanyCode", "");
ht.Add("DPT_CODE", ddlDepartment.SelectedValue);
ht.Add("EID", ddlEmployee.SelectedValue);
ht.Add("OCode", ((SessionUser)Session["SessionUser"]).OCode);
ht.Add("RecomendBy", "n/a");
ht.Add("Reason_Justification", txtJustification.Text);
ht.Add("ReqDate", txtDate.Text);
ht.Add("DesiredRcvDate", txtExpectedDate.Text);
ht.Add("Remarks", txtRemarks.Text);
if (RequisionBll.updatepurchaseRequisition(ht) == false)
{
ClearForm();
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Requisition updated successfully')", true);
ShowRequisitionDataForGrid();
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Requisition updating error!')", true);
//lblMessage.Text = "<font color='red'>Error in updating requisition! Please try again</font>";
}
}
else if (Convert.ToInt32(ddlProductGroup.SelectedValue) != 0 && Convert.ToInt32(ddlProduct.SelectedValue) != 0)
{
DataTable dt = new DataTable();
string ReqNo = txtRequisitionNo.Text;
string Barocde = ddlProduct.SelectedValue;
dt = RequisionBll.GetBarCode(ReqNo, Barocde);
if (dt.Rows.Count > 0)
{
Hashtable ht = new Hashtable();
ht.Add("ReqNo", txtRequisitionNo.Text);
ht.Add("ReqType", "Purchase");
ht.Add("CompanyCode", "");
ht.Add("DPT_CODE", ddlDepartment.SelectedValue);
ht.Add("EID", ddlEmployee.SelectedValue);
ht.Add("OCode", ((SessionUser)Session["SessionUser"]).OCode);
ht.Add("RecomendBy", "n/a");
ht.Add("Reason_Justification", txtJustification.Text);
ht.Add("ReqDate", txtDate.Text);
ht.Add("DesiredRcvDate", txtExpectedDate.Text);
ht.Add("Remarks", txtRemarks.Text);
ht.Add("Qty", txtQuantity.Text);
ht.Add("BarCode", ddlProduct.SelectedValue);
if (RequisionBll.updatePurchaseRequisitions(ht) == false)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Requisition updated successfully')", true);
ShowRequisitionDataForGrid();
ClearForm();
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Requisition updating error!')", true);
//lblMessage.Text = "<font color='red'>Error in updating requisition! Please try again</font>";
}
}
else
{
Hashtable ht = new Hashtable();
ht.Add("ReqNo", txtRequisitionNo.Text);
ht.Add("ReqType", "Purchase");
ht.Add("CompanyCode", "");
ht.Add("DPT_CODE", ddlDepartment.SelectedValue);
ht.Add("EID", ddlEmployee.SelectedValue);
ht.Add("BarCode", ddlProduct.SelectedValue);
ht.Add("Qty", txtQuantity.Text);
ht.Add("ReqDate", txtDate.Text);
ht.Add("DesiredRcvDate", txtExpectedDate.Text);
ht.Add("OCode", ((SessionUser)Session["SessionUser"]).OCode);
ht.Add("RecomendBy", "n/a");
ht.Add("Reason_Justification", txtJustification.Text);
ht.Add("Remarks", txtRemarks.Text);
if (RequisionBll.AddPurchaseRequisition(ht))
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Requisition updated successfully')", true);
LoadRequisitions(txtRequisitionNo.Text);
ClearForm();
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Requisition updating error!')", true);
//lblMessage.Text = "<font color='red'>Error in updating requisition! Please try again</font>";
}
}
}
}
}
catch { }
}
protected void BtnSave_Click(object sender, EventArgs e)
{
try
{
BindRequisitionNo();
string BarCode = ddlProduct.SelectedValue;
string Quantity = txtQuantity.Text;
string ReqDate = txtDate.Text;
if (BarCode == "" || Quantity == "" || ReqDate == "" || ddlDepartment.SelectedValue == "0" || ddlEmployee.SelectedValue == "0" || txtRequisitionNo.Text == "")
{
return;
}
if (int.Parse(txtQuantity.Text) <= 0)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Requisition quantity cannot be zero or negative!')", true);
//lblMessage.Text = "<font color='red'>Sorry! Invalid data. Requisition quantity cannot be zero or negative. Please enter correct data</font>";
return;
}
Inv_Product product = productBll.GetAllItem(int.Parse(ddlProduct.SelectedValue), txtDescription.Text);
if (BtnSave.Text == "Add")
{
if (product == null)
{
Inv_Product productObj = new Inv_Product();
string pronductNameandBrand = ddlProduct.SelectedItem.ToString();
string[] values = pronductNameandBrand.Split('-');
productObj.ProductName = values[0].ToString();
productObj.StyleAndSize = txtDescription.Text;
productObj.ReOrderQty = 0;
productObj.Brand = "HB";
productObj.GroupId = Convert.ToInt32(ddlProductGroup.SelectedValue);
productObj.GroupName = ddlProductGroup.SelectedItem.Text;
productObj.UnitId = int.Parse(ddlUnit.SelectedValue);
productObj.UnitName = ddlUnit.SelectedItem.Text;
productObj.ProductType = "Consumable Product";
productObj.EditDate = DateTime.Now;
//productObj.EditUser = Guid.Parse("a376708d-757f-4777-bd05-bfc89b6971ce");
productObj.EditUser = ((SessionUser)Session["SessionUser"]).UserId;
productObj.OCode = ((SessionUser)Session["SessionUser"]).OCode.ToString();
//productObj.OCode = "8989";
productBll.InsertProduct(productObj);
//PRQ_Requisitions requisition = new PRQ_Requisitions();
//requisition.ReqNo = txtRequisitionNo.Text;
//requisition.ReqType = "Purchase";
////requisition.CompanyCode = "";
//requisition.DPT_CODE = ddlDepartment.SelectedValue;
//requisition.EID = ddlEmployee.SelectedValue;
//requisition.Qty = int.Parse(txtQuantity.Text);
//requisition.ReqDate = DateTime.Parse(txtDate.Text);
//requisition.DesiredRcvDate = DateTime.Parse(txtExpectedDate.Text);
//requisition.OCode = ((SessionUser)Session["SessionUser"]).OCode;
//requisition.RecomendBy = txtRecommendedBy.Text;
//requisition.Reason_Justification = txtJustification.Text;
//requisition.Remarks = txtRemarks.Text;
//aRequisionBll.AddPurchaseRequisition_ForNewItem(values[0].ToString(), txtDescription.Text);
Hashtable ht = new Hashtable();
ht.Add("ReqNo", txtRequisitionNo.Text);
ht.Add("ReqType", "Purchase");
ht.Add("CompanyCode", "");
ht.Add("DPT_CODE", ddlDepartment.SelectedValue);
ht.Add("EID", ddlEmployee.SelectedValue);
//ht.Add("BarCode", ddlProduct.SelectedValue);
ht.Add("Qty", txtQuantity.Text);
ht.Add("ReqDate", txtDate.Text);
ht.Add("DesiredRcvDate", txtExpectedDate.Text);
ht.Add("OCode", ((SessionUser)Session["SessionUser"]).OCode);
ht.Add("RecomendBy", "n/a");
ht.Add("Reason_Justification", txtJustification.Text);
ht.Add("Remarks", txtRemarks.Text);
if (RequisionBll.AddPurchaseRequisition_ForNewItem(ht, values[0].ToString(), txtDescription.Text))
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Requisition for this item added successfully')", true);
//lblMessage.Text = "<font color='green'>Requisition for this item added successfully!</font>";
LoadRequisitions(txtRequisitionNo.Text);
ClearForm();
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Error in adding requisition!')", true);
//lblMessage.Text = "<font color='red'>Error in adding requisition! Please try again</font>";
}
}
else
{
Hashtable ht = new Hashtable();
ht.Add("ReqNo", txtRequisitionNo.Text);
ht.Add("ReqType", "Purchase");
ht.Add("CompanyCode", "");
ht.Add("DPT_CODE", ddlDepartment.SelectedValue);
ht.Add("EID", ddlEmployee.SelectedValue);
ht.Add("BarCode", ddlProduct.SelectedValue);
ht.Add("Qty", txtQuantity.Text);
ht.Add("ReqDate", txtDate.Text);
ht.Add("DesiredRcvDate", txtExpectedDate.Text);
ht.Add("OCode", ((SessionUser)Session["SessionUser"]).OCode);
ht.Add("RecomendBy", "n/a");
ht.Add("Reason_Justification", txtJustification.Text);
ht.Add("Remarks", txtRemarks.Text);
if (RequisionBll.AddPurchaseRequisition(ht))
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Requisition for this item added successfully')", true);
//lblMessage.Text = "<font color='green'>Requisition for this item added successfully!</font>";
LoadRequisitions(txtRequisitionNo.Text);
ClearForm();
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Error in adding requisition!')", true);
//lblMessage.Text = "<font color='red'>Error in adding requisition! Please try again</font>";
}
}
}
else if (BtnSave.Text == "Update")
{
DataTable dt = new DataTable();
string ReqNo = txtRequisitionNo.Text;
string Barocde = ddlProduct.SelectedValue;
dt = RequisionBll.GetBarCode(ReqNo, Barocde);
if (dt.Rows.Count > 0)
{
Hashtable ht = new Hashtable();
ht.Add("ReqNo", txtRequisitionNo.Text);
ht.Add("ReqType", "Purchase");
ht.Add("CompanyCode", "");
ht.Add("DPT_CODE", ddlDepartment.SelectedValue);
ht.Add("EID", ddlEmployee.SelectedValue);
ht.Add("OCode", ((SessionUser)Session["SessionUser"]).OCode);
ht.Add("RecomendBy", "n/a");
ht.Add("Reason_Justification", txtJustification.Text);
ht.Add("ReqDate", txtDate.Text);
ht.Add("DesiredRcvDate", txtExpectedDate.Text);
ht.Add("Remarks", txtRemarks.Text);
ht.Add("Qty", txtQuantity.Text);
ht.Add("BarCode", ddlProduct.SelectedValue);
if (RequisionBll.updatePurchaseRequisitions(ht) == false)
{
ClearForm();
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Requisition for this item updated successfully')", true);
LoadRequisitions(txtRequisitionNo.Text);
BtnSave.Text = "Add";
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Error in adding requisition!')", true);
//lblMessage.Text = "<font color='red'>Error in adding requisition! Please try again</font>";
}
}
}
}
catch { }
}
private void LoadRequisitions(string ReqNo)
{
grdRequisition.DataSource = RequisionBll.GetAll_PurchaseReqList(ReqNo, "Head", hdnEID.Value, txtFromDate.Text, txtToDate.Text);
grdRequisition.DataBind();
}
private void LoadRequisitions(string ReqNo)
{
grdRequisition.DataSource = RequisionBll.GetPendingPurchaseRequisition(ReqNo, "Manager2");
grdRequisition.DataBind();
}
//protected void txtDate_TextChanged(object sender, EventArgs e)
//{
// BindRequisitionNo();
//}
protected void BtnSave_Click(object sender, EventArgs e)
{
try
{
//string BarCode = ddlProduct.SelectedValue;
//string Quantity = txtQuantity.Text;
//string ReqDate = txtDate.Text;
//if (BarCode == "" || Quantity == "" || ReqDate == "" || ddlDepartment.SelectedValue == "0" || ddlEmployee.SelectedValue == "0" || txtRequisitionNo.Text == "")
//{
// return;
//}
//if (int.Parse(txtQuantity.Text) <= 0)
//{
// lblMessage.Text = "<font color='red'>Sorry! Invalid data. Requisition quantity cannot be zero or negative. Please enter correct data</font>";
// return;
//}
//Hashtable ht = new Hashtable();
//ht.Add("ReqNo", txtRequisitionNo.Text);
//ht.Add("ReqType", "Store");
//ht.Add("CompanyCode", "");
//ht.Add("DPT_CODE", ddlDepartment.SelectedValue);
////ht.Add("DPT_CODE", hdnDEPT_CODE.Value);
//ht.Add("EID", ddlEmployee.SelectedValue);
////ht.Add("EID", txtEID.Text);
//ht.Add("BarCode", ddlProduct.SelectedValue);
//ht.Add("Qty", txtQuantity.Text);
//ht.Add("ReqDate", txtDate.Text);
//ht.Add("DesiredRcvDate", txtExpectedDate.Text);
//ht.Add("OCode", ((SessionUser)Session["SessionUser"]).OCode);
//ht.Add("RecomendBy", txtRecommendedBy.Text);
//ht.Add("RequisitionFor", txtRequisitionFor.Text);
//ht.Add("Remarks", txtRemarks.Text);
//ht.Add("Supervisor_EID", hidReportingBossID.Value);
if (BtnSave.Text == "Update")
{
if (ddlProduct.SelectedValue == "")
{
Hashtable ht = new Hashtable();
ht.Add("ReqNo", txtRequisitionNo.Text);
ht.Add("ReqType", "Store");
ht.Add("CompanyCode", "");
ht.Add("DPT_CODE", ddlDepartment.SelectedValue);
//ht.Add("DPT_CODE", hdnDEPT_CODE.Value);
ht.Add("EID", ddlEmployee.SelectedValue);
//ht.Add("EID", txtEID.Text);
//ht.Add("BarCode", ddlProduct.SelectedValue);
ht.Add("Qty", txtQuantity.Text);
ht.Add("ReqDate", txtDate.Text);
ht.Add("DesiredRcvDate", txtExpectedDate.Text);
ht.Add("OCode", ((SessionUser)Session["SessionUser"]).OCode);
ht.Add("RecomendBy", txtRecommendedBy.Text);
ht.Add("RequisitionFor", txtRequisitionFor.Text);
ht.Add("Remarks", txtRemarks.Text);
ht.Add("Supervisor_EID", hidReportingBossID.Value);
bool result = RequisionBll.updateStoreRequisition(ht);
if (result == false)
{
//lblMessage.Text = "<font color='green'>Requisition for this item update successfully!</font>";
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Requisition updated successfully')", true);
LoadRequisitions(txtRequisitionNo.Text);
ClearForm();
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Requisition updating error!')", true);
//lblMessage.Text = "<font color='red'>Error in updating requisition! Please try again</font>";
}
}
else if (ddlProductGroup.SelectedValue != "")
{
DataTable dt = new DataTable();
string ReqNo = txtRequisitionNo.Text;
string Barocde = ddlProduct.SelectedValue;
dt = RequisionBll.GetBarCode(ReqNo, Barocde);
if (dt.Rows.Count > 0)
{
Hashtable ht = new Hashtable();
ht.Add("ReqNo", txtRequisitionNo.Text);
ht.Add("ReqType", "Store");
ht.Add("CompanyCode", "");
ht.Add("DPT_CODE", ddlDepartment.SelectedValue);
//ht.Add("DPT_CODE", hdnDEPT_CODE.Value);
ht.Add("EID", ddlEmployee.SelectedValue);
//ht.Add("EID", txtEID.Text);
//if (ddlProduct.SelectedValue == "")
//{
// ht.Add("BarCode", HiddenField2.Value);
//}
//else
//{
ht.Add("BarCode", Barocde);
//}
if (txtQuantity.Text == "")
{
ht.Add("Qty", HiddenField1.Value);
}
else
{
ht.Add("Qty", txtQuantity.Text);
}
ht.Add("ReqDate", txtDate.Text);
ht.Add("DesiredRcvDate", txtExpectedDate.Text);
ht.Add("OCode", ((SessionUser)Session["SessionUser"]).OCode);
ht.Add("RecomendBy", txtRecommendedBy.Text);
ht.Add("RequisitionFor", txtRequisitionFor.Text);
ht.Add("Remarks", txtRemarks.Text);
ht.Add("Supervisor_EID", hidReportingBossID.Value);
bool result = RequisionBll.updateStoreRequisitions(ht);
if (result == false)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Requisition updated successfully')", true);
LoadRequisitions(txtRequisitionNo.Text);
ClearForm();
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Requisition updating error!')", true);
//lblMessage.Text = "<font color='red'>Error in updating requisition! Please try again</font>";
}
}
else
{
Hashtable ht = new Hashtable();
ht.Add("ReqNo", txtRequisitionNo.Text);
ht.Add("ReqType", "Store");
ht.Add("CompanyCode", "");
ht.Add("DPT_CODE", ddlDepartment.SelectedValue);
//ht.Add("DPT_CODE", hdnDEPT_CODE.Value);
ht.Add("EID", ddlEmployee.SelectedValue);
//ht.Add("EID", txtEID.Text);
ht.Add("BarCode", ddlProduct.SelectedValue);
ht.Add("Qty", txtQuantity.Text);
ht.Add("ReqDate", txtDate.Text);
ht.Add("DesiredRcvDate", txtExpectedDate.Text);
ht.Add("OCode", ((SessionUser)Session["SessionUser"]).OCode);
ht.Add("RecomendBy", txtRecommendedBy.Text);
ht.Add("RequisitionFor", txtRequisitionFor.Text);
ht.Add("Remarks", txtRemarks.Text);
ht.Add("Supervisor_EID", hidReportingBossID.Value);
if (RequisionBll.AddStoreRequisition(ht) == true)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Requisition updated successfully')", true);
LoadRequisitions(txtRequisitionNo.Text);
ClearForm();
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Requisition updating error!')", true);
//lblMessage.Text = "<font color='red'>Error in updating requisition! Please try again</font>";
}
}
}
}
}
catch { }
}
//protected void txtDate_TextChanged(object sender, EventArgs e)
//{
// BindRequisitionNo();
//}
protected void BtnSave_Click(object sender, EventArgs e)
{
try
{
Guid userId = ((SessionUser)Session["SessionUser"]).UserId;
string pronductNameandBrand = ddlProduct.SelectedItem.ToString();
string[] values = pronductNameandBrand.Split('-');
string EID = txtEID.Text;
string Barocode = ddlProduct.SelectedValue;
string BarCode = ddlProduct.SelectedValue;
string Quantity = txtQuantity.Text;
string ReqDate = txtDate.Text;
if (BarCode == "" || Quantity == "" || ReqDate == "" || ddlDepartment.SelectedValue == "0" || ddlEmployee.SelectedValue == "0")
{
return;
}
string OCODE = ((SessionUser)Session["SessionUser"]).OCode;
string barCode = ddlProduct.SelectedValue.ToString();
var result1 = productBll.GetProductById(Convert.ToInt32(ddlProduct.SelectedValue));
double inputBalance = Convert.ToDouble(txtQuantity.Text);
var details = productBll.GetProductBalanceByIdForReq(Convert.ToInt32(ddlProduct.SelectedValue));
var details2 = productBll.GetProductBalanceForRequisition(Convert.ToInt32(ddlProduct.SelectedValue));
double?reqQty = 0;
double?balanceqty = 0;
if (details2 != null)
{
reqQty = details2.PrqBalanceQuanity;
}
else
{
reqQty = 0;
}
if (details != null)
{
balanceqty = details.BalanceQuanity;
}
else
{
balanceqty = 0;
}
if (reqQty + inputBalance > balanceqty)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Stock Not Available!')", true);
return;
}
if (int.Parse(txtQuantity.Text) <= 0)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Requisition quantity cannot be zero or negative!')", true);
//lblMessage.Text = "<font color='red'>Sorry! Invalid data. Requisition quantity cannot be zero or negative. Please enter correct data</font>";
return;
}
if (BtnSave.Text == "Add")
{
Hashtable ht = new Hashtable();
//ht.Add("ReqNo", txtRequisitionNo.Text);
ht.Add("ReqType", "Store");
ht.Add("CompanyCode", "");
ht.Add("DPT_CODE", ddlDepartment.SelectedValue);
//ht.Add("DPT_CODE", hdnDEPT_CODE.Value);
ht.Add("EID", ddlEmployee.SelectedValue);
//ht.Add("EID", txtEID.Text);
ht.Add("GroupId", ddlProductGroup.SelectedValue);
ht.Add("BarCode", ddlProduct.SelectedValue);
ht.Add("Qty", txtQuantity.Text);
ht.Add("ReqDate", txtDate.Text);
ht.Add("DesiredRcvDate", txtExpectedDate.Text);
ht.Add("OCode", ((SessionUser)Session["SessionUser"]).OCode);
ht.Add("RecomendBy", "");
// ht.Add("Program", ddlProgram.SelectedValue);
ht.Add("Reason_Justification", "");
ht.Add("RequisitionFor", txtRequisitionFor.Text);
ht.Add("Location", txtLocation.Text);
ht.Add("Remarks", txtRemarks.Text);
ht.Add("Supervisor_EID", hidReportingBossID.Value);
ht.Add("EditUser", ((SessionUser)Session["SessionUser"]).UserId.ToString());
ht.Add("EditDate", DateTime.Now);
PRQ_Requisition_Temp reqItem = aRequisionBll.GetReq_temp_ItemByProductInfo(txtEID.Text, Convert.ToInt16(ddlProduct.SelectedValue), userId);
if (reqItem != null)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Item already in the list!')", true);
return;
}
if (RequisionBll.PRQ_AddStoreRequisitionTemp(ht))
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Requisition for this item added successfully')", true);
//lblMessage.Text = "<font color='green'>Requisition for this item added successfully!</font>";
//Load_Requisitions(txtRequisitionNo.Text);
LoadRequisitions(txtEID.Text);
ClearForm();
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Error in adding requisition!')", true);
//lblMessage.Text = "<font color='red'>Error in adding requisition! Please try again</font>";
}
}
if (BtnSave.Text == "Update")
{
DataTable dt = new DataTable();
//string ReqNo = txtRequisitionNo.Text;
// string Barocde =ddlProduct.SelectedValue;
dt = RequisionBll.GetBarCode(EID, BarCode);
if (dt.Rows.Count > 0)
{
Hashtable ht = new Hashtable();
//ht.Add("ReqNo", txtRequisitionNo.Text);
ht.Add("ReqType", "Store");
ht.Add("CompanyCode", "");
ht.Add("DPT_CODE", ddlDepartment.SelectedValue);
//ht.Add("DPT_CODE", hdnDEPT_CODE.Value);
ht.Add("EID", ddlEmployee.SelectedValue);
//ht.Add("EID", txtEID.Text);
//if (ddlProduct.SelectedValue == "")
//{
// ht.Add("BarCode", HiddenField2.Value);
//}
//else
//{
ht.Add("BarCode", BarCode);
//}
//if (txtQuantity.Text == "")
//{
// ht.Add("Qty", HiddenField1.Value);
//}
//else
//{
ht.Add("Qty", txtQuantity.Text);
//}
ht.Add("ReqDate", txtDate.Text);
ht.Add("DesiredRcvDate", txtExpectedDate.Text);
ht.Add("OCode", ((SessionUser)Session["SessionUser"]).OCode);
ht.Add("RecomendBy", "");
ht.Add("RequisitionFor", txtRequisitionFor.Text);
ht.Add("Location", txtLocation.Text);
ht.Add("Remarks", txtRemarks.Text);
ht.Add("Supervisor_EID", hidReportingBossID.Value);
// ht.Add("Program", ddlProgram.SelectedValue);
bool result = RequisionBll.updateStoreRequisitions(ht);
if (result == false)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Requisition for this item updated successfully')", true);
//Load_Requisitions(txtRequisitionNo.Text);
LoadRequisitions(txtEID.Text);
ClearForm();
BtnSave.Text = "Add";
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Error in adding requisition!')", true);
//lblMessage.Text = "<font color='red'>Error in adding requisition! Please try again</font>";
}
}
}
}
catch { }
}
private void LoadRequisitionsearch()
{
string ReqNo = "";
string DPT_CODE = ddlDepartment.SelectedValue;
string Status = ddlStatus.SelectedItem.Text;
string FromDate = txtFromDate.Text;
string ToDate = txtToDate.Text;
if (ddlDepartment.SelectedValue != "" && ddlStatus.SelectedItem.Text != "--Select One--" && txtFromDate.Text != "" && txtToDate.Text != "")
{
if (ddlStatus.SelectedItem.Text == "Pending")
{
DataTable dt = new DataTable();
dt = RequisionBll.GetPendingPurchaseRequisitionForAdmin(ReqNo, "Head", DPT_CODE, Status, FromDate, ToDate);
if (dt.Rows.Count > 0)
{
grdRequisition.DataSource = dt;
grdRequisition.DataBind();
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('No purchase requisition found!')", true);
grdRequisition.DataSource = null;
grdRequisition.DataBind();
}
}
else if (ddlStatus.SelectedItem.Text == "Approve")
{
DataTable dt = new DataTable();
dt = RequisionBll.GetPendingPurchaseRequisitionForAdminApprove(ReqNo, "Head", DPT_CODE, Status, FromDate, ToDate);
if (dt.Rows.Count > 0)
{
grdRequisition.DataSource = dt;
grdRequisition.DataBind();
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('No purchase requisition found!')", true);
grdRequisition.DataSource = null;
grdRequisition.DataBind();
}
}
else
{
DataTable dt = new DataTable();
dt = RequisionBll.GetPendingPurchaseRequisitionForAdminAllStatus(ReqNo, "Head", DPT_CODE, Status, FromDate, ToDate);
if (dt.Rows.Count > 0)
{
grdRequisition.DataSource = dt;
grdRequisition.DataBind();
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('No purchase requisition found!')", true);
grdRequisition.DataSource = null;
grdRequisition.DataBind();
}
}
}
else if (ddlDepartment.SelectedValue != "0" && txtFromDate.Text != "" && txtToDate.Text != "" && ddlStatus.SelectedItem.Text == "--Select One--")
{
DataTable dt = new DataTable();
dt = RequisionBll.GetPendingPurchaseRequisitionForAdminByDPT(ReqNo, "Head", DPT_CODE, FromDate, ToDate);
if (dt.Rows.Count > 0)
{
grdRequisition.DataSource = dt;
grdRequisition.DataBind();
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('No purchase requisition found!')", true);
grdRequisition.DataSource = null;
grdRequisition.DataBind();
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Select Department or Status!')", true);
grdRequisition.DataSource = null;
grdRequisition.DataBind();
}
}
private void LoadRequisitions(string ReqNo)
{
grdRequisition.DataSource = RequisionBll.GetAll_StoreReqList(ReqNo, "Head", ddlEmployee.SelectedValue, txtFromDate.Text, txtToDate.Text);
grdRequisition.DataBind();
}
private void LoadRequisitions(string ReqNo)
{
grdRequisition.DataSource = RequisionBll.GetRequisitionToApprove(ReqNo, "Head");
grdRequisition.DataBind();
}
