protected void onPOConfirm(object source, CommandEventArgs e) { DataTable dtQuotationList = new DataTable(); dtQuotationList.Columns.Add("Qtncode"); dtQuotationList.Columns.Add("amount"); string[] strIds = e.CommandArgument.ToString().Split(','); int intNewQuot = 0; string reqCode = strIds[0].ToString(); string DocumentCode = strIds[1].ToString(); string vesselCode = strIds[2].ToString(); string QuotCode = strIds[3].ToString(); string QuotStatus = strIds[4].ToString(); string DeptCode = strIds[5].ToString(); string strFormatSubject = "", strFormatBody = "", sToEmailAddress = ""; string[] Attchment = new string[10]; DataSet dsEmailInfor = new DataSet(); clsQuotationBLL objQuoBLL = new clsQuotationBLL(); DataRow dtrow = dtQuotationList.NewRow(); dtrow[0] = QuotCode; dtrow[1] = "0"; dtQuotationList.Rows.Add(dtrow); int intRet = objQuoBLL.UpdatePOConfirm(reqCode, vesselCode, DocumentCode, QuotCode, Session["SuppCode"].ToString().Trim()); SMS.Business.PURC.BLL_PURC_Purchase objsts = new SMS.Business.PURC.BLL_PURC_Purchase(); objsts.InsertRequisitionStageStatus(reqCode, vesselCode, DocumentCode, "UPD", " ", 1, dtQuotationList); BindGrid(out intNewQuot); }
public bool CheckCredential(string UserId, string strPassword) { try { clsQuotationBLL objBLLQuot = new clsQuotationBLL(); return(objBLLQuot.IsValidSupplier(UserId, strPassword)); } catch //(Exception ex) { return(false); } }
public DataTable GetSupplierName(string suppcode) { clsQuotationBLL objBLLQuot = new clsQuotationBLL(); DataTable dtSupp = new DataTable(); dtSupp = objBLLQuot.GetSupplierName(suppcode); //Assign Mandatory Info into the session Session["SuppName"] = dtSupp.Rows[0]["SHORT_NAME"].ToString(); Session["PassString"] = dtSupp.Rows[0]["PassString"].ToString(); return(dtSupp); }
protected void BindVessel() { clsQuotationBLL objQuoBLL = new clsQuotationBLL(); DataTable dt = new DataTable(); dt = objQuoBLL.GetVessel(); DDLVessel.DataSource = dt; DDLVessel.DataTextField = "Vessels"; DDLVessel.DataValueField = "Vessel_Code"; DDLVessel.DataBind(); }
public DataTable GetSupplierInfo(string UserId, string strPassword) { clsQuotationBLL objBLLQuot = new clsQuotationBLL(); DataTable dtSuppInfo = new DataTable(); dtSuppInfo = objBLLQuot.GetSupplierInfo(UserId, strPassword); //Assign Mandatory Info into the session Session["SuppCode"] = dtSuppInfo.Rows[0]["SUPPLIER"].ToString().Trim(); Session["pwd"] = Login1.Password; Session["userid"] = dtSuppInfo.Rows[0]["ID"].ToString().Trim(); return(dtSuppInfo); }
protected void ChangePasswordPushButton_Click(object sender, EventArgs e) { clsQuotationBLL objqt = new clsQuotationBLL(); int sts = objqt.UpdChangePassword(Session["SuppCode"].ToString(), Changepwd.CurrentPassword, Changepwd.NewPassword); if (sts == 1) { Session["pwd"] = Changepwd.NewPassword.ToString(); lblmsg.Text = "Password changed."; Response.Redirect("WebQuotationDetails.aspx"); } else { lblmsg.Text = "Old password is not matching "; } }
/// <summary> /// This Method is used to bind additional details RFQ RECIEVE /// </summary> /// <param name="Quotation_Code"></param> public void BindAdditionalDetails(string Quotation_Code) { try { TechnicalBAL objtechBAL = new TechnicalBAL(); clsQuotationBLL objQuoBLL = new clsQuotationBLL(); DataSet dsReqSumm = new DataSet(); dsReqSumm = objtechBAL.GetRequQuotationSummary(Request.QueryString["REQUISITION_CODE"].ToString(), Request.QueryString["document_code"].ToString(), Request.QueryString["Vessel_Code"].ToString(), Quotation_Code.ToString()); if (dsReqSumm.Tables[5].Rows.Count > 0) { lblMaker.Text = Convert.ToString(dsReqSumm.Tables[5].Rows[0]["Maker"]); lblSystemParticulars.Text = Convert.ToString(dsReqSumm.Tables[5].Rows[0]["Particulars"]); lblModel.Text = Convert.ToString(dsReqSumm.Tables[5].Rows[0]["Model"]); lblSerialNumber.Text = Convert.ToString(dsReqSumm.Tables[5].Rows[0]["System_Serial_Number"]); lblBargeWorkboatCost.Text = Convert.ToString(dsReqSumm.Tables[5].Rows[0]["Barge_Workboat_Cost"]); lblTruckCost.Text = Convert.ToString(dsReqSumm.Tables[5].Rows[0]["Truck_Cost"]); lblOtherCost.Text = Convert.ToString(dsReqSumm.Tables[5].Rows[0]["Other_Charges"]); lblROC.Text = Convert.ToString(dsReqSumm.Tables[5].Rows[0]["Other_Charges_Reason"]); lblTruckingFreightCost.Text = Convert.ToString(dsReqSumm.Tables[5].Rows[0]["Freight_Cost"]); lblPKGHandlingCost.Text = Convert.ToString(dsReqSumm.Tables[5].Rows[0]["Packing_Handling_Charges"]); lblTotalDiscount.Text = Convert.ToString(dsReqSumm.Tables[5].Rows[0]["DISCOUNT"]); lblSQR.Text = Convert.ToString(dsReqSumm.Tables[5].Rows[0]["Supplier_Quotation_Reference"]); lblSRemark.Text = Convert.ToString(dsReqSumm.Tables[5].Rows[0]["QUOTATION_REMARKS"]); lblReasonPHC.Text = Convert.ToString(dsReqSumm.Tables[5].Rows[0]["REASON_TRANS_PKG"]); lblAccountCode.Text = Convert.ToString(dsReqSumm.Tables[5].Rows[0]["ACCOUNT_CODE"]); } if (dsReqSumm.Tables[6].Rows.Count > 0) { lblVATGST.Text = Convert.ToString(dsReqSumm.Tables[6].Rows[0]["Vat"]); } if (dsReqSumm.Tables[7].Rows.Count > 0) { lblTotalPrice.Text = Math.Round(Convert.ToDecimal(dsReqSumm.Tables[7].Rows[0]["TotalPrice"]), 2).ToString(); } CalculateDiscount(); } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }
private string GetRequistionQuotationStatus(string ReqsnCode, string QuotationCode) { clsQuotationBLL objQuoBLL = new clsQuotationBLL(); string RequisitionStatus = string.Empty; try { DataTable dtStatus = objQuoBLL.GetRequistion_Quotation_Status(ReqsnCode, QuotationCode); if (dtStatus.Rows.Count > 0) { RequisitionStatus = Convert.ToString(dtStatus.Rows[0]["REQSTATUS"]); } } catch { } return(RequisitionStatus); }
public string asyncGetSupplRemarks(string Quotation_Code, string Item_Ref_Code) { clsQuotationBLL objQtn = new clsQuotationBLL(); return(objQtn.GetSupplRemarks(Quotation_Code, Item_Ref_Code)); }
public string asyncUpdateSupplRemarks(string Quotation_Code, string Item_Ref_Code, string Remark) { clsQuotationBLL objQtn = new clsQuotationBLL(); return(objQtn.UpdateSupplRemarks("", Quotation_Code, "", "", Item_Ref_Code, "", Remark).Tables[0].Rows[0][0].ToString()); }
protected void BindGriddataitem() { ReqsnStatus = hdfSelectedStageValue.Value; clsQuotationBLL objQuoBLL = new clsQuotationBLL(); DataTable dt = new DataTable(); string strVesselCode = "", strStatus = "0", FromDT = "1900/01/01", ToDT = "2099/01/01"; string Req_code = "0"; if (txtReqNo.Text.Trim() != "") { Req_code = txtReqNo.Text; } if (DDLVessel.SelectedValue.ToString() == "0") { strVesselCode = "0"; } else { strVesselCode = DDLVessel.SelectedValue.ToString(); } if (ReqsnStatus.Length > 2) { string[] sts = ReqsnStatus.Split(new char[] { '-' }); strStatus = sts[0] + sts[1]; } else if (ReqsnStatus != "") { strStatus = ReqsnStatus; } else { strStatus = ReqsnStatus; } if (txtfrom.Text.Trim() != "") { FromDT = txtfrom.Text.Trim(); } if (txtto.Text.Trim() != "") { ToDT = txtto.Text.Trim(); } int isCount = ucCustomPager1.isCountRecord; dt = objQuoBLL.GetWebQuotation(Session["SuppCode"].ToString(), strVesselCode, strStatus, FromDT, ToDT, Req_code, ucCustomPager1.CurrentPageIndex, ucCustomPager1.PageSize, ref isCount); ucCustomPager1.CountTotalRec = isCount.ToString(); ucCustomPager1.BuildPager(); rgdWebQuoDetails.DataSource = dt; rgdWebQuoDetails.DataBind(); //Changes the Attache Image on the basis of whethere file is Attached or not with Requisiton. OperationRightsOnSupplier(); }