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