protected void btnApprove_Click(object sender, EventArgs e) { BLL_PURC_Purchase objApproval = new BLL_PURC_Purchase(); BLL_PURC_LOG.Ins_Log_Remark(Convert.ToInt32(Request.QueryString["LOG_ID"].ToString()), txtApproverRemark.Text, Convert.ToInt32(Session["USERID"]), 2); btnApprove.Enabled = false; SaveLPODetails(); DataTable dtSuppDate = BLL_PURC_Common.Get_Supplier_ValidDate("'" + uc_SupplierList1.SelectedValue + "'"); if (dtSuppDate.Rows.Count > 0) { if (Convert.ToDateTime(dtSuppDate.Rows[0]["ASL_Status_Valid_till"]) < DateTime.Now) { String msg = String.Format("alert('Selected Supplier has been expired/blacklisted');"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg451", msg, true); } else { decimal TotalAmountToApproved = UDFLib.ConvertToDecimal(hdf_TotalAmount_USD.Value); ViewState["TotalAmountToApproved"] = TotalAmountToApproved; /*Below code is commented due to this JIT_8823 as below method checks for department as it doesnt required for Logistic Po.*/ //DataTable dtApproval = objApproval.Get_Approval_Limit(Convert.ToInt32(Session["USERID"]), ViewState["Dept_Code"].ToString()); decimal Applimit = BLL_PURC_LOG.Get_Log_Logistic_Approval_Limit(Convert.ToInt32(Session["USERID"])); //decimal Applimit = decimal.Parse(dtApproval.Rows[0]["Approval_Limit"].ToString()); if (Applimit < 1) { string msgmodal = String.Format("alert('Approval limit not found !')"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "Apprmodal", msgmodal, true); } else if (Applimit >= TotalAmountToApproved) { BLL_PURC_LOG.Ins_Log_Logistic_Approval_Entry(Convert.ToInt32(Session["USERID"].ToString()), Convert.ToInt32(Session["USERID"].ToString()), TotalAmountToApproved, Convert.ToInt32(Request.QueryString["LOG_ID"].ToString()), "", txtApproverRemark.Text, 1); string msgmodal = String.Format("alert('Approved successfully');parent.ReloadParent_ByButtonID();"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "Apprmodala", msgmodal, true); } else { ViewState["islimit<Total"] = 1; string msgmodal = String.Format("showModal('divSendForApproval');alert('The total PO amount is beyond your approval limit.Please forward to one of the following for approval')"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "Apprmodal", msgmodal, true); } } } }
public void BindDataItems() { int is_Fetch_Count = ucCustomPagerPO.isCountRecord; gvOrderList.DataSource = BLL_PURC_LOG.Get_Log_PO_List(int.Parse(DDLVessel.SelectedValue), UDFLib.ConvertStringToNull(uc_SupplierList1.SelectedValue), UDFLib.ConvertStringToNull(txtPoNumber.Text), ucCustomPagerPO.CurrentPageIndex, ucCustomPagerPO.PageSize, ref is_Fetch_Count); gvOrderList.DataBind(); ucCustomPagerPO.CountTotalRec = is_Fetch_Count.ToString(); ucCustomPagerPO.BuildPager(); }
protected void btnDeleteLPO_Click(object s, EventArgs e) { BLL_PURC_LOG.Ins_Log_Remark(Convert.ToInt32(Request.QueryString["LOG_ID"].ToString()), txtremarkDeleteLPO.Text, Convert.ToInt32(Session["USERID"]), 4); if (BLL_PURC_LOG.Upd_Log_Delete_LogisticPO(Convert.ToInt32(Request.QueryString["LOG_ID"]), Convert.ToInt32(Session["userid"])) > 0) { string deleted = String.Format("parent.ReloadParent_ByButtonID();alert('PO deleted successfully .');"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "deletedPO", deleted, true); } }
public void BindDataItems() { int?ShowAllUser = (chkShowAll.Checked) ? UDFLib.ConvertIntegerToNull(0) : Convert.ToInt32(Session["userid"]); int?ShowActive = (chkShowActive.Checked) ? 1 : 0; int is_Fetch_Count = ucCustomPagerPO.isCountRecord; gvOrderList.DataSource = BLL_PURC_LOG.Get_Log_LogisticPO_List((DataTable)DDLFleet.SelectedValues, (DataTable)DDLVessel.SelectedValues, UDFLib.ConvertStringToNull(uc_SupplierList1.SelectedValue), UDFLib.ConvertStringToNull(txtPoNumber.Text), ShowAllUser, null, UDFLib.ConvertStringToNull(ViewState["LOG_STATUS"]), ucCustomPagerPO.CurrentPageIndex, ucCustomPagerPO.PageSize, ref is_Fetch_Count); gvOrderList.DataBind(); ucCustomPagerPO.CountTotalRec = is_Fetch_Count.ToString(); ucCustomPagerPO.BuildPager(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { lblheader.Text = "Raise PO for Logistic ID : " + Request.QueryString["LOG_ID"]; DataTable dtPoList = BLL_PURC_LOG.Get_Log_POList_Raise(Convert.ToInt32(Request.QueryString["LOG_ID"])); gvLPOList.DataSource = dtPoList; gvLPOList.DataBind(); btnSendOrder.Visible = true; dvRaiselPo.Visible = false; BLL_PURC_Purchase objport = new BLL_PURC_Purchase(); DDLPort.DataSource = objport.getDeliveryPort(); DDLPort.DataBind(); BLL_Crew_CrewDetails objCrew = new BLL_Crew_CrewDetails(); //DataSource = objCrew.Get_PortCall_List(Convert.ToInt32(Request.QueryString["Vessel_Code"].ToString())); //gvPortCalls.DataBind(); DataTable dt = objport.SelectSupplier(); dt.DefaultView.RowFilter = "SUPPLIER_CATEGORY='A'"; ddlSentFrom.DataTextField = "SUPPLIER_NAME"; ddlSentFrom.DataValueField = "SUPPLIER"; ddlSentFrom.DataSource = dt.DefaultView.ToTable(); ddlSentFrom.DataBind(); ddlSentFrom.Items.Insert(0, new ListItem("SELECT", "0")); ListItem liDDl = new ListItem(); liDDl = DDLPort.Items.FindByValue(dtPoList.Rows[0]["port"].ToString()); if (liDDl != null) { liDDl.Selected = true; } liDDl = ddlSentFrom.Items.FindByValue(dtPoList.Rows[0]["Agent"].ToString()); if (liDDl != null) { liDDl.Selected = true; if (Convert.ToString(dtPoList.Rows[0]["Agent"]) != "0") { DataTable dtAgentsDtls = BLL_PURC_Common.Get_SupplierDetails_ByCode(dtPoList.Rows[0]["Agent"].ToString()); if (dtAgentsDtls.Rows.Count > 0) { txtagent.Text = dtAgentsDtls.Rows[0]["fullname"].ToString(); txtagent.Text += "\r\n" + dtAgentsDtls.Rows[0]["address"].ToString(); txtagent.Text += "\r\n" + dtAgentsDtls.Rows[0]["phone"].ToString(); txtagent.Text += "\r\n" + dtAgentsDtls.Rows[0]["email"].ToString(); } } } } }
public void LoadFiles(object s, EventArgs e) { try { DataTable dtAttachedFile = BLL_PURC_LOG.Get_Log_Attachment(Request.QueryString["LOG_ID"]); gvAttachment.DataSource = dtAttachedFile; gvAttachment.DataBind(); ASP.global_asax.AttachedFile = ""; Session["PURCATTACHEDFILES"] = ""; } catch { } }
protected int SaveLPODetails() { DataTable dtGridItems = new DataTable(); dtGridItems.Columns.Add("PID"); dtGridItems.Columns.Add("Item_ID"); dtGridItems.Columns.Add("item"); dtGridItems.Columns.Add("amount"); dtGridItems.Columns.Add("remark"); dtGridItems.Columns.Add("vessel_id"); dtGridItems.PrimaryKey = new DataColumn[] { dtGridItems.Columns["PID"] }; DataRow dr = null; int RowID = 1; foreach (GridViewRow grItem in gvItemList.Rows) { dr = dtGridItems.NewRow(); dr["PID"] = RowID++; dr["Item_ID"] = ((HiddenField)grItem.FindControl("hdfID")).Value; dr["item"] = ((TextBox)grItem.FindControl("txtItem")).Text; dr["amount"] = UDFLib.ConvertToDecimal(((TextBox)grItem.FindControl("txtAmount")).Text); dr["remark"] = ((TextBox)grItem.FindControl("txtRemark")).Text; dr["vessel_id"] = (grItem.FindControl("ddlpovessels") as DropDownList).SelectedValue; //if (dtGridItems.Rows.Contains(dr["vessel_id"].ToString()) || dr["vessel_id"].ToString() == "0") //{ // lblMessage.Visible = true; // lblMessage.Text = "Same vessel can not be selected more than one time . Please select different vessel for each row."; // return 0; //} if (dr["item"].ToString().Trim() == "") { lblMessage.Visible = true; lblMessage.Text = "Please enter item details ."; return(0); } if (Convert.ToDecimal(dr["amount"].ToString()) < 1) { lblMessage.Visible = true; lblMessage.Text = "Amount should be greater than zero !"; return(0); } dtGridItems.Rows.Add(dr); } return(BLL_PURC_LOG.Ins_Log_LogisticPO_Details(UDFLib.ConvertToInteger(Request.QueryString["LOG_ID"]), DDLCurrency.SelectedItem.Text, rbtnlistPOType.SelectedValue, rbtnlistCostType.SelectedValue, ddlHub.SelectedValue, ddlAgentFord.SelectedValue, UDFLib.ConvertToInteger(ctlPortList1.SelectedValue), "", dtGridItems, Convert.ToInt32(Session["USERID"].ToString()), uc_SupplierList1.SelectedValue)); }
protected void imgbtnDelete_Click(object s, EventArgs e) { if (BLL_PURC_LOG.Upd_Log_Delete_Logistic_ReqsnPO(Convert.ToInt32((s as ImageButton).CommandArgument), Convert.ToInt32(Session["userid"])) > 0) { DataSet dsLog = BLL_PURC_LOG.Get_Log_Logistic_PO_Details(UDFLib.ConvertToInteger(Request.QueryString["LOG_ID"])); dlReqsnPOs.DataSource = dsLog.Tables[1]; dlReqsnPOs.DataBind(); gvItemList.DataSource = dsLog.Tables[2]; gvItemList.DataBind(); upditemlist.Update(); } }
protected void imgbtnDeleteitem_Click(object sender, EventArgs e) { if (gvItemList.Rows.Count > 1) { GridViewRow dritem = (GridViewRow)(sender as ImageButton).Parent.Parent; DataTable dtGridItems = new DataTable(); dtGridItems.Columns.Add("Item_ID"); dtGridItems.Columns.Add("item"); dtGridItems.Columns.Add("amount"); dtGridItems.Columns.Add("remark"); dtGridItems.Columns.Add("vessel_id"); dtGridItems.Columns.Add("Item_PO"); int RowID = 0; DataRow dr = null; foreach (GridViewRow grItem in gvItemList.Rows) { if (dritem.RowIndex != RowID) { dr = dtGridItems.NewRow(); dr["Item_ID"] = ((HiddenField)grItem.FindControl("hdfID")).Value; dr["item"] = ((TextBox)grItem.FindControl("txtItem")).Text; dr["amount"] = UDFLib.ConvertToDecimal(((TextBox)grItem.FindControl("txtAmount")).Text); dr["remark"] = ((TextBox)grItem.FindControl("txtRemark")).Text; dr["vessel_id"] = (grItem.FindControl("ddlpovessels") as DropDownList).SelectedValue; dtGridItems.Rows.Add(dr); } RowID++; } //delete from database if (!Convert.ToBoolean(ViewState["IsCreatingNewPO"])) { BLL_PURC_LOG.Upd_Log_LogisticPO_Item(Convert.ToInt32((dritem.FindControl("hdfID") as HiddenField).Value), Convert.ToInt32(Session["USERID"])); } gvItemList.DataSource = dtGridItems; gvItemList.DataBind(); ViewState["vsItemList"] = dtGridItems; } string CalculateTotal = String.Format("CalculateTotal();"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "CalculateTotal", CalculateTotal, true); }
protected void FillDDLs() { BLL_Infra_Currency objCurr = new BLL_Infra_Currency(); DDLCurrency.DataTextField = "Currency_Code"; DDLCurrency.DataValueField = "Currency_ID"; DDLCurrency.DataSource = objCurr.Get_CurrencyList(); DDLCurrency.DataBind(); ListItem lis = new ListItem("Select", "0"); DDLCurrency.Items.Insert(0, lis); DDLCurrency.SelectedIndex = 0; ddlHub.DataTextField = "Description"; ddlHub.DataValueField = "code"; ddlHub.DataSource = BLL_PURC_LOG.Get_Log_Hub_List(); ddlHub.DataBind(); ListItem lisHub = new ListItem("Select", "0"); ddlHub.Items.Insert(0, lisHub); ddlHub.SelectedIndex = 0; BLL_PURC_Purchase objport = new BLL_PURC_Purchase(); DataTable dt = objport.SelectSupplier(); dt.DefaultView.RowFilter = " SUPPLIER_CATEGORY in ('A','S') and ASL_Status in ('Approve','Conditional') "; ddlAgentFord.DataTextField = "SUPPLIER_NAME"; ddlAgentFord.DataValueField = "SUPPLIER"; ddlAgentFord.DataSource = dt.DefaultView.ToTable(); ddlAgentFord.DataBind(); ddlAgentFord.Items.Insert(0, new ListItem("SELECT", "0")); ddlAgentFord.SelectedIndex = 0; //BLL_Infra_Port objBLLPort = new BLL_Infra_Port(); //ctlPortList1.DataTextField = "Port_Name"; //ctlPortList1.DataValueField = "Port_ID"; //ctlPortList1.DataSource = objBLLPort.Get_PortList_Mini(); //ctlPortList1.DataBind(); //ctlPortList1.Items.Insert(0, new ListItem("SELECT", "0")); //ctlPortList1.SelectedIndex = 0; }
protected void btnCreateCPO_Click(object sender, EventArgs e) { DataTable dtPO = new DataTable(); dtPO.Columns.Add("PID"); dtPO.Columns.Add("Value"); DataRow dr = null; Dictionary <string, string> DicPO = new Dictionary <string, string>(); DicPO = (Dictionary <string, string>)ViewState["vsDicPO"]; int PID = 1; foreach (string PO in DicPO.Values) { dr = dtPO.NewRow(); dr["PID"] = PID++; dr["Value"] = PO; dtPO.Rows.Add(dr); } int PO_ID = 0; if (dtPO.Rows.Count > 0) { PO_ID = BLL_PURC_LOG.Ins_Log_Create_LogisticPO(Convert.ToInt32(DDLVessel.SelectedValue), dtPO, Convert.ToInt32(Session["userid"].ToString())); if (PO_ID > 0) { btnCreateCPO.Enabled = false; DicPO.Clear(); ViewState["vsDicPO"] = DicPO; string URL = String.Format("OpenPopupWindow('POP__Logistic_PO_Details', 'Logistic PO Details', 'LOG_Logistic_PO_Details.aspx?LOG_ID=" + PO_ID + " ','popup',800,1020,null,null,false,false,true,redirecttoindexpage);"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "k" + PO_ID.ToString(), URL, true); } } else { string URL = String.Format("alert('Please select PO !')"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "k" + PO_ID.ToString(), URL, true); btnCreateCPO.Enabled = true; } }
protected void btnReworkToPurchaser_Click(object s, EventArgs e) { try { BLL_PURC_LOG.Ins_Log_Remark(Convert.ToInt32(Request.QueryString["LOG_ID"].ToString()), txtApproverRemark.Text, Convert.ToInt32(Session["USERID"]), 6); int sts = BLL_PURC_LOG.Upd_Log_ReworkToPurchaser(Convert.ToInt32(Request.QueryString["LOG_ID"].ToString()), Convert.ToInt32(Session["USERID"])); if (sts > 0) { string msgmodal = String.Format("parent.ReloadParent_ByButtonID();"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "rework", msgmodal, true); } } catch (Exception ex) { string msgmodal = String.Format("alert('" + ex.Message + "'); parent.ReloadParent_ByButtonID();"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "rework", msgmodal, true); } }
protected void btnCnacelLPO_Click(object s, EventArgs e) { try { BLL_PURC_LOG.Ins_Log_Remark(Convert.ToInt32(Request.QueryString["LOG_ID"].ToString()), txtCancelLPORemark.Text, Convert.ToInt32(Session["USERID"]), 7); int sts = BLL_PURC_LOG.Upd_Log_Cancel_LPO(Convert.ToInt32(Request.QueryString["LOG_ID"].ToString()), Convert.ToInt32(Session["USERID"])); if (sts > 0) { string msgmodal = String.Format("parent.ReloadParent_ByButtonID();"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "cancellpo", msgmodal, true); } else if (sts == -1001) { string msgmodal = String.Format("alert('Invoice has been uploaded !')"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "cancellpoinvoce", msgmodal, true); } } catch (Exception ex) { string msgmodal = String.Format("alert('" + ex.Message + "'); parent.ReloadParent_ByButtonID();"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "cancellpo", msgmodal, true); } }
protected void btnSendForApproval_Click(object sender, EventArgs e) { BLL_PURC_LOG.Ins_Log_Remark(Convert.ToInt32(Request.QueryString["LOG_ID"].ToString()), txtRemark.Text, Convert.ToInt32(Session["USERID"]), 3); if (SaveLPODetails() > 0) { if (UDFLib.ConvertToInteger(ViewState["islimit<Total"]) == 1)//save the approval { BLL_PURC_LOG.Ins_Log_Logistic_Approval_Entry(Convert.ToInt32(Session["USERID"].ToString()), Convert.ToInt32(Session["USERID"].ToString()), UDFLib.ConvertToDecimal(ViewState["TotalAmountToApproved"]), Convert.ToInt32(Request.QueryString["LOG_ID"].ToString()), "", txtApproverRemark.Text); } // send for appr BLL_PURC_LOG.Ins_Log_Logistic_Approval_Entry(Convert.ToInt32(Session["USERID"].ToString()), Int32.Parse(lstUserList.SelectedValue), 0, Convert.ToInt32(Request.QueryString["LOG_ID"].ToString()), txtRemark.Text, ""); string msgmodal = String.Format("alert('Sent successfully');parent.ReloadParent_ByButtonID();"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "Apprmodal", msgmodal, true); } }
protected void Page_Load(object sender, EventArgs e) { DataTable Dt = BLL_PURC_LOG.Get_Log_Raise_PO(Request.QueryString["ORDER_CODE"], Request.QueryString["LOG_ID"]); GeneratePOAsPDF(Dt, "", Request.QueryString["ORDER_CODE"].ToString() + ".pdf"); }
public string Ins_Log_Remark(string Remark_Type, string Remark, string User_ID, string Log_ID) { return(BLL_PURC_LOG.Ins_Log_Remark(Convert.ToInt32(Log_ID), Remark, Convert.ToInt32(User_ID), Convert.ToInt32(Remark_Type)).ToString()); }
protected void SendPurchaseOrder() { // string[] Attchment = new string[10]; lblError.Text = ""; string strPath = Server.MapPath(".") + "\\SendPO\\"; DataTable DsPO = new DataTable(); DataSet dsSendMailInfo = new DataSet(); BLL_Infra_UserCredentials objUser = new BLL_Infra_UserCredentials(); DataTable dtUser = objUser.Get_UserDetails(Convert.ToInt32(Session["USERID"])); string emailIDcc = dtUser.Rows[0]["MailID"].ToString(); bool IsPO = false; int i = 0; string sDlvIns = txtdlvins.Text != "" ? txtdlvins.Text : DBNull.Value.ToString(); string strDeliveryPort = DDLPort.SelectedItem.ToString() != "--Select--" ? DDLPort.SelectedValue.ToString() : DBNull.Value.ToString(); string sEta = txteta.Text != "" ? txteta.Text + " " + txtETAAPPM.Text.ToString().Trim() + ":00" : Convert.ToString("01/01/1900"); string sRemark = txtremark.Text != "" ? txtremark.Text : DBNull.Value.ToString(); string sAgent = txtagent.Text != "" ? txtagent.Text : DBNull.Value.ToString(); string sEtd = txtetd.Text != "" ? txtetd.Text + " " + txtETDAMPM.Text.ToString().Trim() + ":00" : Convert.ToString("01/01/1900"); foreach (GridViewRow gvRow in gvLPOList.Rows) { CheckBox chk = (CheckBox)(gvRow.FindControl("chkSelectLPO") as CheckBox); string order_code = gvLPOList.DataKeys[gvRow.RowIndex].Value.ToString(); if ((chk.Checked)) { string OrderCode = gvLPOList.DataKeys[gvRow.RowIndex].Value.ToString(); int sts = BLL_PURC_LOG.Upd_Log_Order_Details(sDlvIns, strDeliveryPort, DateTime.Parse(sEta), sRemark, DateTime.Parse(sEtd), sAgent, Request.QueryString["LOG_ID"], order_code, Convert.ToInt32(Session["USERID"])); DsPO = BLL_PURC_LOG.Get_Log_Raise_PO(order_code, Request.QueryString["LOG_ID"]); dsSendMailInfo = BLL_PURC_LOG.Get_RaisePO_EmailInfo(order_code, Request.QueryString["LOG_ID"], Convert.ToInt32(Session["USERID"])); string FileName = "PO_" + OrderCode + "_" + ReplaceSpecialCharacterinFileName(DsPO.Rows[0]["SHORT_NAME"].ToString()) + DateTime.Now.ToString("yyMMddss") + ".pdf"; string sToEmailAddress = "", strSubject = "", strEmailBody = ""; //Generate the PDF file and check the include amount status DataTable dtPO = DsPO; if (rbtnIncludeAmount.Checked == false) { int ipo = 0; foreach (DataRow dr in dtPO.Rows) { dtPO.Rows[ipo]["currency"] = ""; dtPO.Rows[ipo]["exchange_rate"] = 0; dtPO.Rows[ipo]["quoted_rate"] = 0; dtPO.AcceptChanges(); ipo++; } } GeneratePOAsPDF(dtPO, strPath, FileName); FormateEmail(dsSendMailInfo, out sToEmailAddress, out strSubject, out strEmailBody, false, OrderCode); BLL_Crew_CrewDetails objMail = new BLL_Crew_CrewDetails(); int MailID = 0; MailID = objMail.Send_CrewNotification(0, 0, 0, 0, sToEmailAddress, emailIDcc, "", strSubject, strEmailBody, "", "MAIL", "", UDFLib.ConvertToInteger(Session["USERID"].ToString()), "DRAFT"); string UploadFilePath = ConfigurationManager.AppSettings["PURC_UPLOAD_PATH"]; //string uploadpath = @"\\server01\uploads\Purchase"; string uploadpath = @"uploads\Purchase"; BLL_Infra_Common.Insert_EmailAttachedFile(MailID, FileName, uploadpath + @"\" + FileName); string URL = String.Format("window.open('../crew/EmailEditor.aspx?ID=+" + MailID.ToString() + @"&FILEPATH=" + UploadFilePath + "');"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "k" + MailID.ToString(), URL, true); // ResponseHelper.Redirect("../crew/EmailEditor.aspx?ID=" + MailID.ToString(), "blank", ""); } } String msg1 = String.Format("window.open('','_self') ;window.close() ;"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", msg1, true); dvRaiselPo.Visible = false; btnSendOrder.Enabled = true; }
protected void Page_Load(object sender, EventArgs e) { if (AjaxFileUpload1.IsInFileUploadPostBack) { } else { UserAccessValidation(); // lblLogisticId.Attributes.Add("style", "visibility:hidden"); lblMessage.Visible = false; ViewState["deleted"] = "false"; uc_SupplierList1.Web_Method_URL = "/" + System.Configuration.ConfigurationManager.AppSettings["APP_NAME"].ToString() + "/JibeWebService.asmx/asyncGet_Supplier_List"; ctlPortList1.Web_Method_URL = "/" + System.Configuration.ConfigurationManager.AppSettings["APP_NAME"].ToString() + "/JibeWebService.asmx/asyncGet_Port_List"; btnLoadFiles.Attributes.Add("style", "visibility:hidden"); if (!IsPostBack) { FillDDLs(); imgbtnPurchaserRemark.Attributes.Add("onmouseover", "ASync_Get_Log_Remark(" + Request.QueryString["LOG_ID"] + ",event,this,0,3)"); DataSet dsLog = BLL_PURC_LOG.Get_Log_Logistic_PO_Details(UDFLib.ConvertToInteger(Request.QueryString["LOG_ID"])); ViewState["Dept_Code"] = dsLog.Tables[1].Rows[0]["DEPARTMENT"].ToString(); ViewState["deleted"] = Convert.ToString(dsLog.Tables[0].Rows[0]["active_status"]) == "0" ? true : false; // lblVesselName.Text = dsLog.Tables[0].Rows[0]["Vessel_Name"].ToString(); lblLpoCode.Text = Request.QueryString["LOG_ID"]; string wh = "LOG_ID=" + Request.QueryString["LOG_ID"]; string msgmodal = String.Format(" Get_Record_Information_Details('PURC_LIB_LOG_PO','" + wh + "');"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "Get_Record", msgmodal, true); Session["LOG_ID"] = Request.QueryString["LOG_ID"].ToString(); // ScriptManager.RegisterStartupScript(Page, Page.GetType(), "Get_records", "Get_records();", true); try { DDLCurrency.ClearSelection(); if (DDLCurrency.Items.FindByText(dsLog.Tables[0].Rows[0]["Currency"].ToString()) != null) { DDLCurrency.Items.FindByText(dsLog.Tables[0].Rows[0]["Currency"].ToString()).Selected = true; if (dsLog.Tables[3].Rows.Count > 0) { hdfExchrate.Value = dsLog.Tables[3].Rows[0]["ExchRate"].ToString(); } } ddlHub.ClearSelection(); if (ddlHub.Items.FindByValue(dsLog.Tables[0].Rows[0]["Hub"].ToString()) != null) { ddlHub.Items.FindByValue(dsLog.Tables[0].Rows[0]["Hub"].ToString()).Selected = true; } ddlAgentFord.ClearSelection(); if (ddlAgentFord.Items.FindByValue(dsLog.Tables[0].Rows[0]["Supplier_Code"].ToString()) != null) { ddlAgentFord.Items.FindByValue(dsLog.Tables[0].Rows[0]["Supplier_Code"].ToString()).Selected = true; } rbtnlistPOType.ClearSelection(); if (rbtnlistPOType.Items.FindByValue(dsLog.Tables[0].Rows[0]["PO_Type"].ToString()) != null) { rbtnlistPOType.Items.FindByValue(dsLog.Tables[0].Rows[0]["PO_Type"].ToString()).Selected = true; } rbtnlistCostType.ClearSelection(); if (rbtnlistCostType.Items.FindByValue(dsLog.Tables[0].Rows[0]["Cost_Type"].ToString()) != null) { rbtnlistCostType.Items.FindByValue(dsLog.Tables[0].Rows[0]["Cost_Type"].ToString()).Selected = true; } uc_SupplierList1.SelectedValue = dsLog.Tables[0].Rows[0]["PO_Supplier"].ToString(); ctlPortList1.SelectedValue = Convert.ToString(dsLog.Tables[0].Rows[0]["Port"]); //ctlPortList1.SelectedValue = dsLog.Tables[0].Rows[0]["Port"].ToString(); gvAttachment.DataSource = BLL_PURC_LOG.Get_Log_Attachment(Request.QueryString["LOG_ID"]); gvAttachment.DataBind(); } catch { } dlReqsnPOs.DataSource = dsLog.Tables[1]; dlReqsnPOs.DataBind(); if (dsLog.Tables[2].Rows.Count == 0) // creating new PO { ViewState["IsCreatingNewPO"] = true; // create rows based on vessels selected for logistic po DataRow dr; DataTable dtVesselsInLPO = BLL_PURC_LOG.Get_VesselInLogisticPO(UDFLib.ConvertToInteger(Request.QueryString["LOG_ID"])); if (dtVesselsInLPO.Rows.Count == 1) { dr = dsLog.Tables[2].NewRow(); dr["item_id"] = 0; dr["vessel_id"] = 0; dsLog.Tables[2].Rows.Add(dr); } else { foreach (DataRow drvsl in dtVesselsInLPO.Rows) { dr = dsLog.Tables[2].NewRow(); dr["item_id"] = 0; dr["vessel_id"] = drvsl["vessel_id"]; dsLog.Tables[2].Rows.Add(dr); } } gvItemList.DataSource = dsLog.Tables[2]; gvItemList.DataBind(); if (dsLog.Tables[1].Rows.Count == 1)// select single po option { rbtnlistPOType.Items.FindByValue("SPO").Selected = true; } else { rbtnlistPOType.Items.FindByValue("CPO").Selected = true; } } else { ViewState["IsCreatingNewPO"] = false; gvItemList.DataSource = dsLog.Tables[2]; gvItemList.DataBind(); string CalculateTotal = String.Format("CalculateTotal();"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "CalculateTotal", CalculateTotal, true); } ViewState["dtGridItems"] = dsLog.Tables[2]; lstUserList.DataSource = BLL_PURC_LOG.Get_Log_Logistic_Approver(); lstUserList.DataBind(); lstUserList.Items.Insert(0, new ListItem("SELECT", "0")); lstUserList.SelectedIndex = 0; ListItem itemrmv = lstUserList.Items.FindByValue(Session["userid"].ToString()); lstUserList.Items.Remove(itemrmv); //ucPurcAttachment1.ReqsnNumber = Request.QueryString["LOG_ID"].ToString(); //ucPurcAttachment1.UserID = Session["USERID"].ToString(); //ucPurcAttachment1.FileUploadPath = Server.MapPath("../Uploads/Purchase"); //ucPurcAttachment1.VesselID = "0"; ASP.global_asax.AttachedFile = ""; Session["PURCATTACHEDFILES"] = ""; DataTable dtDeletedPOs = BLL_PURC_LOG.Get_Log_Deleted_LPO(Request.QueryString["LOG_ID"]); if (dtDeletedPOs.Rows.Count > 0) { gvDeletedPOs.DataSource = dtDeletedPOs; gvDeletedPOs.DataBind(); } else { lbllblexpand.Visible = false; pnldeletedpo.Visible = false; } } if (IsPostBack) { // ucPurcAttachment1.Register_JS_Attach(); Session["PURCATTACHEDFILES"] = ASP.global_asax.AttachedFile; } btnShowCnacelLPO.Visible = false; if (UDFLib.ConvertToInteger(Request.QueryString["IsApproving"]) == 0) { pnlApprove.Visible = false; } else { btnSavePODetails.Visible = false; btnDeleteLO.Enabled = false; btnSendForApproval.Visible = false; foreach (DataListItem item in dlReqsnPOs.Items) { (item.FindControl("imgbtnDelete") as ImageButton).Visible = false; } foreach (GridViewRow gr in gvItemList.Rows) { (gr.FindControl("imgbtnDeleteitem") as ImageButton).Visible = false; } (gvItemList.FooterRow.FindControl("btnAddNewItem") as Button).Visible = false; } if (UDFLib.ConvertToInteger(Request.QueryString["IsApproved"]) == 1) { pnlApprove.Visible = false; btnSavePODetails.Visible = false; btnDeleteLO.Enabled = false; btnSendForApproval.Visible = false; foreach (DataListItem item in dlReqsnPOs.Items) { (item.FindControl("imgbtnDelete") as ImageButton).Visible = false; } foreach (GridViewRow gr in gvItemList.Rows) { (gr.FindControl("imgbtnDeleteitem") as ImageButton).Visible = false; (gr.FindControl("ddlpovessels") as DropDownList).Enabled = false; } (gvItemList.FooterRow.FindControl("btnAddNewItem") as Button).Visible = false; btnShowCnacelLPO.Visible = true; } DisableOnDeleted(); } }
public DataTable get_LogisticPOList_OutLook(int Vessel_ID, string Supplier_Code, string SearchText) { return(BLL_PURC_LOG.Get_LogisticPOList_OutLook(Vessel_ID, Supplier_Code, SearchText)); }
public string Get_Log_Remark(string Log_ID, string Remark_Type) { return(UDFLib.CreateHtmlTableFromDataTable(BLL_PURC_LOG.Get_Log_Remark(Convert.ToInt32(Log_ID), UDFLib.ConvertIntegerToNull(Remark_Type)), new string[] { "User", "Date", "Stage", "Remark" }, new string[] { "First_Name", "RDate", "RemarkType", "remark" }, "")); }
public DataTable get_LogisticPO_Supplier_OutLook() { return(BLL_PURC_LOG.Get_LogisticPO_Supplier()); }
public string Purc_Get_Approval_History(string Log_ID) { return(UDFLib.CreateHtmlTableFromDataTable(BLL_PURC_LOG.Get_Log_Logistic_Approvals(Convert.ToInt32(Log_ID)), new string[] { "Name", "Amount", "Date", "Remark" }, new string[] { "First_Name", "AMOUNT", "APPDATE", "Approver_Remark" }, new string[] { "left", "right", "left", "left" }, "Approvals:")); }