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