protected void lbtnEdit_Click(object s, CommandEventArgs e) { string[] arg = e.CommandArgument.ToString().Split(','); int? RemarksID = UDFLib.ConvertIntegerToNull(arg[0]); txtRemarksID.Text = UDFLib.ConvertStringToNull(arg[0]); DataTable dt = new DataTable(); int Type = 1; String Remarks_Type = Request.QueryString["Type"].ToString(); dt = BLL_POLOG_Register.POLOG_Get_Remarks(UDFLib.ConvertIntegerToNull(txtRemarksID.Text), UDFLib.ConvertIntegerToNull(txtPOCode.Text.ToString()), Type, Remarks_Type); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; txtAddRemarks.Text = dr["Remarks"].ToString(); btnAddRemarks.Text = "Edit Remarks"; } }
protected void Update_Final_Invoice(string InvStatus, string Status) { DataTable dt = new DataTable(); dt.Columns.Add("PKID"); dt.Columns.Add("ChkValue"); dt.Columns.Add("Invoice_ID"); int i = 0; DataRow dr = dt.NewRow(); dr["PKID"] = i + 1; dr["ChkValue"] = 1; dr["Invoice_ID"] = txtInvoiceCode.Text.ToString(); dt.Rows.Add(dr); int Ret = BLL_POLOG_Register.POLog_Update_Invoice(dt, InvStatus, Status, UDFLib.ConvertToInteger(GetSessionUserID())); //int retval = BLL_POLOG_Register.POLog_Update_Invoice(dt, InvStatus, Status, UDFLib.ConvertToInteger(GetSessionUserID())); }
public void BindAcct() { DataSet ds1 = BLL_POLOG_Register.POLOG_Get_AccountClassification(UDFLib.ConvertIntegerToNull(GetSessionUserID()), ddlPOType.SelectedValue); ddlAccClassifictaion.DataSource = ds1.Tables[0]; ddlAccClassifictaion.DataTextField = "VARIABLE_NAME"; ddlAccClassifictaion.DataValueField = "VARIABLE_CODE"; ddlAccClassifictaion.DataBind(); ddlAccClassifictaion.Items.Insert(0, new ListItem("-All-", "0")); //DataSet ds2 = BLL_POLOG_Register.POLOG_Get_AccountClassification(UDFLib.ConvertIntegerToNull(GetSessionUserID()), ddlPOType.SelectedValue); ddlGroupName.DataSource = ds1.Tables[1]; ddlGroupName.DataTextField = "Approval_Group_Name"; ddlGroupName.DataValueField = "Approval_Group_Code"; ddlGroupName.DataBind(); ddlGroupName.Items.Insert(0, new ListItem("-All-", "0")); }
protected void BindDropDownList() { DataSet ds = BLL_POLOG_Register.POLOG_Get_Type(UDFLib.ConvertToInteger(GetSessionUserID()), "ALL_SUPPLIER"); ddlSupplier.DataSource = ds.Tables[0]; ddlSupplier.DataTextField = "Supplier_Name"; ddlSupplier.DataValueField = "Supplier_Code"; ddlSupplier.DataBind(); ddlSupplier.Items.Insert(0, new ListItem("-All Suppliers-", "0")); DataSet dsOwner = BLL_POLOG_Register.POLOG_Get_Type(UDFLib.ConvertToInteger(GetSessionUserID()), "OWNER"); ddlOwner.DataSource = dsOwner.Tables[0]; ddlOwner.DataTextField = "Supplier_Name"; ddlOwner.DataValueField = "Supplier_Code"; ddlOwner.DataBind(); ddlOwner.Items.Insert(0, new ListItem("-All Owners-", "0")); }
protected void BindWithholdInvoice() { try { int rowcount = ucCustomPager3.isCountRecord; string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString()); int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null) { sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString()); } string InvoiceStatus = (ViewState["InvoiceStatus"] == null) ? null : (ViewState["InvoiceStatus"].ToString()); DataSet ds = BLL_POLOG_Register.POLOG_Get_Withhold_Invoice_Search(UDFLib.ConvertStringToNull(ddlSupplier.SelectedValue), UDFLib.ConvertIntegerToNull(ddlVessel.SelectedValue), UDFLib.ConvertStringToNull(ddlOwner.SelectedValue), chkUrgent.Checked ? 1 : 0, InvoiceStatus, UDFLib.ConvertIntegerToNull(GetSessionUserID()), sortbycoloumn, sortdirection , ucCustomPager3.CurrentPageIndex, ucCustomPager3.PageSize, ref rowcount); if (ucCustomPager3.isCountRecord == 1) { ucCustomPager3.CountTotalRec = rowcount.ToString(); ucCustomPager3.BuildPager(); } if (ds.Tables[0].Rows.Count > 0) { dvWithhold.Visible = true; gvPOWithhold.DataSource = ds.Tables[0]; gvPOWithhold.DataBind(); txtPOCode.Text = ds.Tables[0].Rows[0]["SUPPLY_ID"].ToString(); BindInvoice(ds.Tables[0].Rows[0]["SUPPLY_ID"].ToString()); gvPOWithhold.Rows[0].BackColor = System.Drawing.Color.Yellow; } else { dvWithhold.Visible = false; gvPOWithhold.DataSource = ds.Tables[0]; gvPOWithhold.DataBind(); } } catch { } { } }
protected void BindGrid() { DataTable dt = BLL_POLOG_Register.POLOG_Get_Invoice(UDFLib.ConvertIntegerToNull(txtPOCode.Text.ToString())); if (dt.Rows.Count > 0) { divPendingPO.Visible = true; gvInvoice.DataSource = dt; gvInvoice.DataBind(); BindAttachment(UDFLib.ConvertStringToNull(dt.Rows[0]["Invoice_ID"].ToString())); BindPoPreview(UDFLib.ConvertStringToNull(dt.Rows[0]["Supply_ID"].ToString())); } else { divPendingPO.Visible = false; gvInvoice.DataSource = dt; gvInvoice.DataBind(); } }
public void BindDropDownList() { DataTable dt = objBLL.Get_VesselList(0, 0, 0, "", Convert.ToInt32(GetCompanyID())); ddlVessel.DataSource = dt; ddlVessel.DataTextField = "VESSEL_NAME"; ddlVessel.DataValueField = "VESSEL_ID"; ddlVessel.DataBind(); ddlVessel.Items.Insert(0, new ListItem("-All Vessels-", "0")); DataSet ds = BLL_POLOG_Register.POLOG_Get_Type(UDFLib.ConvertToInteger(GetSessionUserID()), "ALL_SUPPLIER"); ddlSupplier.DataSource = ds.Tables[0]; ddlSupplier.DataTextField = "Supplier_Name"; ddlSupplier.DataValueField = "Supplier_Code"; ddlSupplier.DataBind(); ddlSupplier.Items.Insert(0, new ListItem("-All Suppliers-", "0")); }
protected void btnUrgent_Click(object sender, EventArgs e) { string Status = null; string InvStatus = null; if (btnUrgent.Text == "Urgent") { Status = "Urgent"; InvStatus = "Urgent"; int RetAuditVal = BLL_POLOG_Register.POLOG_Insert_Transactionlog(UDFLib.ConvertStringToNull(lblInvoiceID.Text), "NON Urgent Invoice", "UNUrgentInvoice", UDFLib.ConvertToInteger(GetSessionUserID())); } else { Status = "UNUrgent"; InvStatus = "UNUrgent"; int RetAuditVal = BLL_POLOG_Register.POLOG_Insert_Transactionlog(UDFLib.ConvertStringToNull(lblInvoiceID.Text), "Urgent Invoice", "UrgentInvoice", UDFLib.ConvertToInteger(GetSessionUserID())); } Update_Invoice(Status, InvStatus); }
public void Load_dropdownlist() { string SearchType = "PAYMENT"; DataSet ds = BLL_POLOG_Register.POLOG_Get_Supplier_InvoiceWise(UDFLib.ConvertIntegerToNull(GetSessionUserID()), SearchType); if (ds.Tables[0].Rows.Count > 0) { ddlSupplier.DataSource = ds.Tables[0]; ddlSupplier.DataTextField = "Supplier_Name"; ddlSupplier.DataValueField = "Supplier_Code"; ddlSupplier.DataBind(); ddlSupplier.Items.Insert(0, new ListItem("-All-", "0")); } else { ddlSupplier.Items.Insert(0, new ListItem("-All-", "0")); } if (ds.Tables[1].Rows.Count > 0) { ddlVessel.DataSource = ds.Tables[1]; ddlVessel.DataTextField = "Vessel_Name"; ddlVessel.DataValueField = "Vessel_ID"; ddlVessel.DataBind(); ddlVessel.Items.Insert(0, new ListItem("-All-", "0")); } else { ddlVessel.Items.Insert(0, new ListItem("-All-", "0")); } if (ds.Tables[2].Rows.Count > 0) { ddlOwner.DataSource = ds.Tables[2]; ddlOwner.DataTextField = "Owner_Name"; ddlOwner.DataValueField = "Owner_Code"; ddlOwner.DataBind(); ddlOwner.Items.Insert(0, new ListItem("-All-", "0")); } else { ddlOwner.Items.Insert(0, new ListItem("-All-", "0")); } }
protected void btnUpload_Click(object sender, EventArgs e) { try { string DocType = "Invoice"; //string savePath = Server.MapPath("\\" + System.Configuration.ConfigurationManager.AppSettings["APP_NAME"].ToString() + "\\Uploads\\Files_Uploaded"); Guid GUID = Guid.NewGuid(); string Flag_Attach = GUID.ToString() + Path.GetExtension(FileUpload1.FileName); string OCA_URL = null; if (!Request.Url.AbsoluteUri.Contains(ConfigurationManager.AppSettings["OCA_APP_URL"])) { OCA_URL = ConfigurationManager.AppSettings["OCA_APP_URL"]; } string OCA_URL1 = OCA_URL + @"\Files_Uploaded"; string savePath = (OCA_URL1); string FileID = BLL_POLOG_Register.POLOG_Insert_AttachedFile(UDFLib.ConvertStringToNull(lblInvoiceID.Text), Path.GetExtension(FileUpload1.FileName), UDFLib.Remove_Special_Characters(Path.GetFileName(FileUpload1.FileName)), Flag_Attach, DocType, 2714); FileID = FileID.PadLeft(8, '0'); string F1 = Mid(FileID, 0, 2); string F2 = Mid(FileID, 2, 2); string F3 = Mid(FileID, 4, 2); if (!Directory.Exists(savePath + "\\" + F1 + "\\" + F2 + "\\" + F3)) { Directory.CreateDirectory(savePath + "\\" + F1 + "\\" + F2 + "\\" + F3); } string filePath = savePath + "\\" + F1 + "\\" + F2 + "\\" + F3 + "\\" + FileID + "" + Path.GetExtension(FileUpload1.FileName); FileUpload1.SaveAs(filePath); // int RetAuditVal = BLL_POLOG_Register.POLOG_Insert_Transactionlog(UDFLib.ConvertStringToNull(lblInvoiceID.Text), "Uploaded Invoice", "UploadedInvoice", 2714); BindReqsnAttchment(); } catch (Exception ex) { } }
protected void PaymentDet() { DataSet ds = BLL_POLOG_Register.POLOG_Get_Payment_Details(txtPaymodeID.Text.ToString(), txtSupplierCode.Text.ToString(), UDFLib.ConvertIntegerToNull(txtPayment_Year.Text), GetSessionUserID()); if (ds.Tables[0].Rows.Count > 0) { txtPaymentAmount.Text = ds.Tables[0].Rows[0]["PAYMENT_AMOUNT"].ToString(); txtBankRef.Text = ds.Tables[0].Rows[0]["BANK_REFERENCE"].ToString(); txtPayDate.Text = ds.Tables[0].Rows[0]["PAYMENT_DATE"].ToString(); ddlPayMode.SelectedValue = ds.Tables[0].Rows[0]["PAYMENT_MODE"].ToString(); rdbPaymode.SelectedValue = ds.Tables[0].Rows[0]["Payment_Status"].ToString(); ddlAccount.Text = ds.Tables[0].Rows[0]["Bank_Account_ID"].ToString(); txtBankAmt.Text = ds.Tables[0].Rows[0]["Bank_Amount"].ToString(); txtBankCharge.Text = ds.Tables[0].Rows[0]["Bank_Charges"].ToString(); txtRemarks.Text = ds.Tables[0].Rows[0]["PAYMENT_REMARKS"].ToString(); txtJournal.Text = ds.Tables[0].Rows[0]["Journal_ID"].ToString(); txtPaymodeID.Text = ds.Tables[0].Rows[0]["PAYMENT_ID"].ToString(); txtPayment_Year.Text = ds.Tables[0].Rows[0]["PAYMENT_YEAR"].ToString(); } }
void BindGroupDeatils(string GroupID) { try { //Change And Enter One Type int Type = 1; //DataSet ds = BLL_POLOG_Lib.Get_Approval_Group(GroupID, Type); DataSet ds = BLL_POLOG_Register.POLOG_Get_AccountClassification(UDFLib.ConvertIntegerToNull(GetSessionUserID()), null); if (ds.Tables[1].Rows.Count > 0) { txtApprovalGroup.Text = ds.Tables[0].Rows[0]["Approval_Group_Name"].ToString(); txtGroupID.Text = ds.Tables[0].Rows[0]["Approval_Group_Code"].ToString(); ddlPOType.SelectedValue = ds.Tables[0].Rows[0]["Req_type"].ToString(); } BindDepartmentList(txtGroupID.Text, ddlPOType.SelectedValue); } catch { } { } }
public void BindReqsnAttchment() { string DocType = "Invoice"; DataTable dtAttachment = BLL_POLOG_Register.POLOG_Get_Attachments(UDFLib.ConvertStringToNull(lblInvoiceID.Text), DocType); if (dtAttachment.Rows.Count > 0) { string FilePath = dtAttachment.Rows[0]["File_Path"].ToString(); divAttachment.Visible = true; gvReqsnAttachment.DataSource = dtAttachment; gvReqsnAttachment.DataBind(); BindAttchement(hdnFilePath.Value); } else { divAttachment.Visible = false; gvReqsnAttachment.DataSource = dtAttachment; gvReqsnAttachment.DataBind(); } }
protected void Update_Invoice(string InvStatus, string Status) { DataTable dt = new DataTable(); dt.Columns.Add("PKID"); dt.Columns.Add("ChkValue"); dt.Columns.Add("Invoice_ID"); int i = 0; if (InvStatus == "Approved") { foreach (GridViewRow row in gvPendingInvoice.Rows) { bool result = ((CheckBox)row.FindControl("chkInvoice")).Checked; if (result) { DataRow dr = dt.NewRow(); dr["PKID"] = i + 1; dr["ChkValue"] = 1; dr["Invoice_ID"] = gvPendingInvoice.DataKeys[row.RowIndex].Value.ToString(); dt.Rows.Add(dr); } } } else { foreach (GridViewRow row in gvApprovedInvoice.Rows) { bool result = ((CheckBox)row.FindControl("chkInvoice")).Checked; if (result) { DataRow dr = dt.NewRow(); dr["PKID"] = i + 1; dr["ChkValue"] = 1; dr["Invoice_ID"] = gvApprovedInvoice.DataKeys[row.RowIndex].Value.ToString(); dt.Rows.Add(dr); } } } int retval = BLL_POLOG_Register.POLog_Update_Invoice(dt, InvStatus, Status, UDFLib.ConvertToInteger(GetSessionUserID())); }
protected void BindPODetails() { try { DataSet ds = BLL_POLOG_Register.POLOG_Get_PO_Deatils(UDFLib.ConvertIntegerToNull(Parent_Supply_id.Value), null, UDFLib.ConvertIntegerToNull(GetSessionUserID())); if (ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; if (ddlVessel.Items.FindByValue(dr["Vessel_ID"].ToString()) != null) { ddlVessel.SelectedValue = dr["Vessel_ID"].ToString(); } } } catch { } { } }
protected void Save(string Status) { try { string responseid = BLL_POLOG_Register.POLOG_INS_Batch_Payment(UDFLib.ConvertStringToNull(txtPaymentID.Text), ddlSupplierName.SelectedValue, ddlPaymentType.SelectedValue, ddlPaymentCurrency.SelectedValue, txtBankName.Text, ddlCountry.SelectedValue, ddlState.SelectedValue, txtSwiftCode.Text.Trim(), txtABANumber.Text.Trim(), txtBankCode.Text.Trim(), txtBranchCode.Text.Trim(), txtAccountNumber.Text.Trim(), txtBeneficiary.Text.Trim(), ddlPaymentAccount.SelectedValue, ddlPayMode.SelectedValue, UDFLib.ConvertIntegerToNull(Session["USERID"]), "DRAFT"); txtPaymentID.Text = Convert.ToString(responseid); if (responseid != "0") { string msgDraft = String.Format("parent.ReloadParent_ByButtonID();"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msgDraft", msgDraft, true); } else { } } catch { } { } }
protected void BindSupplier() { DataTable dt = BLL_POLOG_Register.POLOG_Get_Supplier(ddlSupplierType.SelectedValue); if (dt.Rows.Count > 0) { ddlSupplier.DataSource = dt; ddlSupplier.DataTextField = "Supplier_Name"; ddlSupplier.DataValueField = "Supplier_Code"; ddlSupplier.DataBind(); ddlSupplier.Items.Insert(0, new ListItem("-All-", "0")); } else { ddlSupplier.DataSource = dt; ddlSupplier.DataTextField = "Supplier_Name"; ddlSupplier.DataValueField = "Supplier_Code"; ddlSupplier.DataBind(); ddlSupplier.Items.Insert(0, new ListItem("-All-", "0")); } }
protected void BindType() { try { DataSet ds = BLL_POLOG_Register.POLOG_Get_Type(UDFLib.ConvertToInteger(Session["UserID"].ToString()), "PO_TYPE"); chkType.DataSource = ds.Tables[0]; chkType.DataTextField = "VARIABLE_NAME"; chkType.DataValueField = "VARIABLE_CODE"; chkType.DataBind(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { chkType.Items[i].Selected = true; string color = ds.Tables[0].Rows[i]["COLOR_CODE"].ToString(); chkType.Items[i].Attributes.Add("style", "background-color: " + color + ";"); //chkType.Attributes.Add("style", "background-color: " + color + ";"); } } catch { } { } }
protected void BindPendingPOGrid() { try { DataTable dt = BLL_POLOG_Register.POLOG_Get_Pending_Approval(UDFLib.ConvertToInteger(Session["UserID"].ToString())); if (dt.Rows.Count > 0) { divPendingPO.Visible = true; gvPendingPO.DataSource = dt; gvPendingPO.DataBind(); } else { divPendingPO.Visible = false; gvPendingPO.DataSource = dt; gvPendingPO.DataBind(); } } catch { } { } }
protected void BindSupplierInvoice(string Supplier_Code) { string PayMode = null; DataSet ds = BLL_POLOG_Register.POLOG_Get_Payment_Supplier_Invoice(Supplier_Code, PayMode, GetSessionUserID()); if (ds.Tables[0].Rows.Count > 0) { gvPaymentDetails.DataSource = ds; gvPaymentDetails.DataBind(); gvApprovedInvoice.DataSource = ds; gvApprovedInvoice.DataBind(); } if (ds.Tables[1].Rows.Count > 0) { txtSupplierName.Text = ds.Tables[1].Rows[0]["Supplier_Name"].ToString(); txtPaymentTerms.Text = ds.Tables[1].Rows[0]["Payment_Terms"].ToString(); txtAddress.Text = ds.Tables[1].Rows[0]["Address"].ToString(); txtPayment.Text = ds.Tables[1].Rows[0]["Payment_Instructions"].ToString(); txtCity.Text = ds.Tables[1].Rows[0]["City"].ToString(); txtpaymentnotification.Text = ds.Tables[1].Rows[0]["Payment_Notifications"].ToString(); txtEmail.Text = ds.Tables[1].Rows[0]["Email"].ToString(); txtPhone.Text = ds.Tables[1].Rows[0]["Phone"].ToString(); txtFax.Text = ds.Tables[1].Rows[0]["Fax"].ToString(); } if (ds.Tables[2].Rows.Count > 0) { gvNewPayment.DataSource = ds.Tables[2]; gvNewPayment.DataBind(); if (ds.Tables[2].Rows[0]["PAYMENT_STATUS"].ToString() == "OPEN") { gvNewPayment.Rows[0].BackColor = System.Drawing.Color.Yellow; txtPaymodeID.Text = ds.Tables[2].Rows[0]["PAYMENT_ID"].ToString(); txtPayment_Year.Text = ds.Tables[2].Rows[0]["PAYMENT_YEAR"].ToString(); GetPaymentDetails(txtPaymodeID.Text, txtPayment_Year.Text); btnUpdate.Enabled = true; btnlink.Enabled = true; } } }
protected void btnVerified_Click(object sender, EventArgs e) { i = Checkvalue(Convert.ToDecimal(txtInvoiceValue.Text), Convert.ToDecimal(txtGST.Text), ddlType.SelectedValue); if (i == 0) { string Status = "Verified"; string InvStatus = "Verified"; string retval = BLL_POLOG_Invoice.POLog_Insert_Invoice(UDFLib.ConvertStringToNull(txtInvoiceID.Text), UDFLib.ConvertIntegerToNull(GetSupplyID()), UDFLib.ConvertStringToNull(ddlType.SelectedValue), UDFLib.ConvertDateToNull(txtInvoiceDate.Text.Trim()), txtReferance.Text.Trim(), UDFLib.ConvertDateToNull(txtReceivedDate.Text.Trim()), UDFLib.ConvertDecimalToNull(txtInvoiceValue.Text.Trim()), ddlCurrency.SelectedValue, UDFLib.ConvertDecimalToNull(txtGST.Text.Trim()), UDFLib.ConvertDateToNull(txtDueDate.Text.Trim()), InvStatus, UDFLib.ConvertDateToNull(txtPaymentDate.Text.Trim()), txtRemarks.Text.Trim(), Status, UDFLib.ConvertToInteger(GetSessionUserID())); //string msgDraft = String.Format("parent.ReloadParent_ByButtonID();"); //ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msgDraft", msgDraft, true); if (retval != "0") { txtInvoiceID.Text = Convert.ToString(retval); BindInvoice(); int RetAuditVal = BLL_POLOG_Register.POLOG_Insert_Transactionlog(UDFLib.ConvertStringToNull(lblInvoiceID.Text), "Verified Invoice", "VerifiedInvoice", UDFLib.ConvertToInteger(GetSessionUserID())); string message = "alert('Invoice Verified.')"; ScriptManager.RegisterClientScriptBlock((sender as Control), this.GetType(), "alert", message, true); } else { string message = "alert('Invoice Cant be verified before uploading attachment.')"; ScriptManager.RegisterClientScriptBlock((sender as Control), this.GetType(), "alert", message, true); } } else if (i == 1) { string message = "alert('Invoice and GST value should be negative for credit note Invoice Type.')"; ScriptManager.RegisterClientScriptBlock((sender as Control), this.GetType(), "alert", message, true); } else if (i == 2) { string message = "alert('Invoice and GST value should be positive.')"; ScriptManager.RegisterClientScriptBlock((sender as Control), this.GetType(), "alert", message, true); } }
public void imgbtnDelete_Click(object s, EventArgs e) { try { string[] arg = (((ImageButton)s).CommandArgument.Split(new char[] { ',' })); int res = BLL_POLOG_Register.POLOG_Delete_Attachments(arg[0].ToString(), arg[1].ToString(), Convert.ToInt16(GetSessionUserID())); //string SavePath = Server.MapPath("\\" + System.Configuration.ConfigurationManager.AppSettings["APP_NAME"].ToString() + "\\Uploads\\Files_Uploaded"); //string SavePath = ("../Uploads/Files_Uploaded"); //string File_ID = arg[0]; //File_ID = File_ID.PadLeft(8, '0'); //string F1 = Mid(File_ID, 0, 2); //string F2 = Mid(File_ID, 2, 2); //string F3 = Mid(File_ID, 4, 2); //string filePath = SavePath + "\\" + F1 + "\\" + F2 + "\\" + F3 + "\\" + arg[2]; //if (File.Exists(filePath)) //{ // File.Delete(filePath); //} } catch { } }
protected void AjaxFileUpload1_OnUploadComplete(object sender, AjaxFileUploadEventArgs file) { try { BLL_PURC_Purchase objTechService = new BLL_PURC_Purchase(); Byte[] fileBytes = file.GetContents(); string SavePath = Server.MapPath("\\" + System.Configuration.ConfigurationManager.AppSettings["APP_NAME"].ToString() + "\\Uploads\\Files_Uploaded"); Guid GUID = Guid.NewGuid(); string Flag_Attach = GUID.ToString() + Path.GetExtension(file.FileName); string FileID = BLL_POLOG_Register.POLOG_Insert_AttachedFile(UDFLib.ConvertStringToNull(Request.QueryString["ID"].ToString()), Path.GetExtension(file.FileName), UDFLib.Remove_Special_Characters(Path.GetFileName(file.FileName)), Flag_Attach, Request.QueryString["DocType"].ToString(), Convert.ToInt16(GetSessionUserID())); FileID = FileID.PadLeft(8, '0'); string F1 = Mid(FileID, 0, 2); string F2 = Mid(FileID, 2, 2); string F3 = Mid(FileID, 4, 2); if (!Directory.Exists(SavePath + F1 + "\\" + F2 + "\\" + F3)) { Directory.CreateDirectory(SavePath + F1 + "\\" + F2 + "\\" + F3); } string FullFilename = Path.Combine(SavePath + "\\" + F1 + "\\" + F2 + "\\" + F3, FileID.ToString() + Path.GetExtension(file.FileName)); //string FullFilename = Path.Combine(sPath, GUID.ToString() + Path.GetExtension(file.FileName)); FileStream fileStream = new FileStream(FullFilename, FileMode.Create, FileAccess.ReadWrite); fileStream.Write(fileBytes, 0, fileBytes.Length); fileStream.Close(); ScriptManager.RegisterStartupScript(this, typeof(Page), "refresh", "fn_OnClose(a,b)", true); } catch (Exception ex) { } }
protected void BindType() { DataSet ds = BLL_POLOG_Register.POLOG_Get_Type(UDFLib.ConvertToInteger(GetSessionUserID()), "Payment_Mode"); ddlPayMode.DataSource = ds.Tables[11]; ddlPayMode.DataTextField = "VARIABLE_NAME"; ddlPayMode.DataValueField = "VARIABLE_CODE"; ddlPayMode.DataBind(); ddlPayMode.Items.Insert(0, new ListItem("-Select-", "0")); rdbPaymode.DataSource = ds.Tables[12]; rdbPaymode.DataTextField = "VARIABLE_NAME"; rdbPaymode.DataValueField = "VARIABLE_CODE"; rdbPaymode.DataBind(); rdbPaymode.Items.Insert(0, new ListItem("CANCEL", "CANCEL")); ddlAccount.DataSource = ds.Tables[13]; ddlAccount.DataTextField = "Account_Name"; ddlAccount.DataValueField = "Account_ID"; ddlAccount.DataBind(); ddlAccount.Items.Insert(0, new ListItem("-Select-", "0")); }
protected void ImgExpExcel_Click(object sender, EventArgs e) { int rowcount = ucCustomPagerItems.isCountRecord; string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString()); int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null) { sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString()); } ChkStatus(); if (Session["sVesselCode"] == "0") { Session["sVesselCode"] = ddlVessel.SelectedValues; } if (Session["sAccountType"] == "0") { Session["sAccountType"] = ddlAccountType.SelectedValues; } if (Session["sAccClassification"] == "0") { Session["sAccClassification"] = ddlAccClassification.SelectedValues; } DataSet ds = BLL_POLOG_Register.POLOG_Get_Purchase_Report(UDFLib.ConvertStringToNull(ddlSupplier.SelectedValue), (DataTable)Session["sVesselCode"], (DataTable)Session["sAccountType"], (DataTable)Session["sAccClassification"], CurrStatus, txtFromDate.Text != "" ? Convert.ToDateTime(txtFromDate.Text) : Convert.ToDateTime("01/01/1900"), txtToDate.Text != "" ? Convert.ToDateTime(txtToDate.Text) : Convert.ToDateTime("01/01/1900"), UDFLib.ConvertIntegerToNull(GetSessionUserID()), sortbycoloumn, sortdirection , null, null, ref rowcount); string[] HeaderCaptions = { "PO Status", "PO Date", "PO Code", "ship Ref Code", "Acct", "Amount", "Cur", "PO USD Value", "Invoice USD Amount", "Paid USD Amount", "Outstanding PO Amount", "Supplier Name" }; string[] DataColumnsName = { "Line_Status", "Line_Date", "Office_Ref_Code", "ship_Ref_Code", "Account_Classification", "Line_Amount", "Line_Currency", "PO_USD_Value", "Invoice_USD_Amount", "Paid_USD_Amount", "OutStanding_USD_Amount", "Supplier_Name" }; GridViewExportUtil.ShowExcel(ds.Tables[0], HeaderCaptions, DataColumnsName, "Purchasing_Report", "Purchasing Report", ""); }
public void BindReqsnAttchment() { //Parent_invoice_id.Value = "0000"; string DocType = "Invoice"; DataTable dtAttachment = BLL_POLOG_Register.POLOG_Get_Attachments(UDFLib.ConvertStringToNull(hiddenTransfer.Value), DocType); if (dtAttachment.Rows.Count > 0) { string FilePath = dtAttachment.Rows[0]["File_Path"].ToString(); gvReqsnAttachment.DataSource = dtAttachment; gvReqsnAttachment.DataBind(); gvReqsnAttachment.Visible = true; divAttachment.Visible = true; } else { gvReqsnAttachment.DataSource = dtAttachment; gvReqsnAttachment.DataBind(); divAttachment.Visible = false; } }
protected void btnApprove_Click(object sender, CommandEventArgs e) { string msg2 = null; string[] arg = e.CommandArgument.ToString().Split(','); string Invoice_ID = UDFLib.ConvertStringToNull(arg[0]); string Status = "Approved"; string InvStatus = "Approved"; int Retval = Update_Invoice(Invoice_ID, Status, InvStatus); if (Retval == 1) { int RetAuditVal = BLL_POLOG_Register.POLOG_Insert_Transactionlog(UDFLib.ConvertStringToNull(Invoice_ID), "Approved Invoice", "ApprovedInvoice", UDFLib.ConvertToInteger(GetSessionUserID())); msg2 = String.Format("alert('Invoice Approved.')"); BindGrid(); } else { msg2 = String.Format("alert('Disputed Invoice Cant be approved.')"); } ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", msg2, true); }
protected void BindPOType() { try { DataSet ds = BLL_POLOG_Register.POLOG_Get_Type(UDFLib.ConvertToInteger(Session["UserID"].ToString()), "PO_TYPE"); if (ds.Tables[1].Rows.Count > 0) { ddlPOType.DataSource = ds.Tables[1]; ddlPOType.DataTextField = "VARIABLE_NAME"; ddlPOType.DataValueField = "VARIABLE_CODE"; ddlPOType.DataBind(); ddlPOType.Items.Insert(0, new ListItem("-Select-", "0")); } else { ddlPOType.Items.Insert(0, new ListItem("-Select-", "0")); } // } catch { } { } }
protected void ImgExpExcel_Click(object sender, EventArgs e) { int rowcount = ucCustomPagerItems.isCountRecord; string InvoiceStatus = null; DataTable dtType = ChkType(); string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString()); int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null) { sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString()); } string str; if (chkClosePO.Checked == true) { str = "yes"; } else { str = "No"; } DataTable dt = BLL_POLOG_Register.POLOG_Get_PO_Search(txtfilter.Text.Trim() != "" ? txtfilter.Text.Trim() : null, UDFLib.ConvertStringToNull(ddlSupplier.SelectedValue), UDFLib.ConvertIntegerToNull(ddlVessel.SelectedValue), UDFLib.ConvertStringToNull(ddlAccClassification.SelectedValue), UDFLib.ConvertStringToNull(ddlAccountType.SelectedValue), UDFLib.ConvertStringToNull(InvoiceStatus), dtType, str, sortbycoloumn, sortdirection , ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount); string[] HeaderCaptions = { "Created Date", "Office Ref. Code", "Supplier Name", "Line Currency", "Total Amount", "Invoice Amount", "Invoice Count" }; string[] DataColumnsName = { "Created_Date", "Office_Ref_Code", "Supplier Name", "Line Currency", "TotalAmount", "Invoice_Amount", "Invoice_Count" }; GridViewExportUtil.ShowExcel(dt, HeaderCaptions, DataColumnsName, "PO LOG", "PO LOG", ""); }
protected void BindDuplicateInvoice(string InvoiceID) { try { DataTable dt = BLL_POLOG_Register.POLOG_Get_DuplicateInvoice(InvoiceID); if (dt.Rows.Count > 0) { lblDuplicateInvoice.Text = "Duplicated invoice Reference Found"; divDuplicateInvoice.Visible = true; gvDuplieCateinvoice.DataSource = dt; gvDuplieCateinvoice.DataBind(); } else { divDuplicateInvoice.Visible = false; gvDuplieCateinvoice.DataSource = dt; gvDuplieCateinvoice.DataBind(); } } catch { } { } }