protected void BindOutstandingGrid()
{
int rowcount = ucCustomPager1.isCountRecord;
string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString());
int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null)
{
sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString());
}
string SupplierID = GetSuppID();
DataSet ds = BLL_ASL_Supplier.Get_Supplier_PO_OutStanding(SupplierID, ucCustomPagerItems.CurrentPageIndex, ucCustomPager1.PageSize, ref rowcount);
if (ucCustomPager1.isCountRecord == 1)
{
ucCustomPager1.CountTotalRec = ds.Tables[3].Rows[0]["RowCount"].ToString();
//ucCustomPager1.CountTotalRec = rowcount.ToString();
ucCustomPager1.BuildPager();
}
if (ds.Tables[0].Rows.Count > 0)
{
gvOutstanding.DataSource = ds.Tables[2];
gvOutstanding.DataBind();
}
else
{
gvOutstanding.DataSource = ds.Tables[2];
gvOutstanding.DataBind();
}
}
protected void SearchBindGrid()
{
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());
}
string SupplierID = GetSuppID();
DataSet ds = BLL_ASL_Supplier.Get_Supplier_POInvoiceHistory(SupplierID, UDFLib.ConvertIntegerToNull(ddlVessel.SelectedValue), UDFLib.ConvertStringToNull(ddlVessel.SelectedItem), ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount);
if (ucCustomPagerItems.isCountRecord == 1)
{
//ucCustomPagerItems.CountTotalRec = ds.Tables[1].Rows[0]["RowCount"].ToString();
ucCustomPagerItems.CountTotalRec = rowcount.ToString();
ucCustomPagerItems.BuildPager();
}
if (ds.Tables[0].Rows.Count > 0)
{
gvPOInvoice.DataSource = ds;
gvPOInvoice.DataBind();
}
else
{
gvPOInvoice.DataSource = ds;
gvPOInvoice.DataBind();
}
}
protected void BindChangeRequestGrid()
{
try
{
DataTable dtType = ChkType();
ChkStatus();
//DataSet ds = BLL_ASL_Supplier.Get_ChangeRequest_Search(UDFLib.ConvertToInteger(GetSessionUserID()), UDFLib.ConvertStringToNull(txtfilter.Text));
DataSet ds = BLL_ASL_Supplier.Get_Pending_CR_List(UDFLib.ConvertToInteger(GetSessionUserID()), txtfilter.Text != "" ? txtfilter.Text : null
, UDFLib.ConvertIntegerToNull(ddlSupplyPort.SelectedValue), UDFLib.ConvertStringToNull(ddlSupplyType.SelectedValue),
UDFLib.ConvertStringToNull(ddlEvaluationStatus.SelectedValue), dtType, CurrStatus, chkCredit.Checked ? 1 : 0, txtSupplierDesc.Text.Trim());
if (ds.Tables[0].Rows.Count > 0)
{
divChnageRequest.Visible = true;
divCR.Visible = true;
gvChangeRequest.DataSource = ds.Tables[0];
gvChangeRequest.DataBind();
}
else
{
divChnageRequest.Visible = false;
divCR.Visible = false;
gvChangeRequest.DataSource = ds.Tables[0];
gvChangeRequest.DataBind();
}
}
catch { }
{
}
}
protected void BindType()
{
DataTable dt = BLL_ASL_Supplier.Get_ASL_System_Parameter(1, "", UDFLib.ConvertToInteger(GetSessionUserID()));
chkType.DataSource = dt;
chkType.DataTextField = "Name";
chkType.DataValueField = "Description";
chkType.DataBind();
//foreach (ListItem chkitem in chkType.Items)
//{
// chkitem.Selected = true;
//}
foreach (ListItem chkitem in chkType.Items)
{
if (chkitem.Value == "AGENT")
{
chkitem.Selected = true;
}
if (chkitem.Value == "SUPPLIER")
{
chkitem.Selected = true;
}
if (chkitem.Value == "BROKER")
{
chkitem.Selected = true;
}
}
}
public void BindGrid()
{
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());
}
int?StatusID = UDFLib.ConvertIntegerToNull(status);
DataTable dt = BLL_ASL_Supplier.Get_Proposed_Supplier_Search(txtfilter.Text != "" ? txtfilter.Text : null, StatusID, sortbycoloumn, sortdirection
, ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount, UDFLib.ConvertToInteger(Session["UserID"].ToString()), Pageset);
if (ucCustomPagerItems.isCountRecord == 1)
{
ucCustomPagerItems.CountTotalRec = rowcount.ToString();
ucCustomPagerItems.BuildPager();
}
if (dt.Rows.Count > 0)
{
gvProposedSupp.DataSource = dt;
gvProposedSupp.DataBind();
}
else
{
gvProposedSupp.DataSource = dt;
gvProposedSupp.DataBind();
}
}
protected void btnFinalApprove_Click(object sender, EventArgs e)
{
try
{
string CR_Status = "EFFECTED";
string Action_On_Data_Form = "EFFECTED";
int RetValue = Submit(CR_Status, Action_On_Data_Form);
//SaveSupplierScope();
//SaveSupplierPort();
if (RetValue == 0)
{
string message = "alert('No Rows Selected For Change.')";
ScriptManager.RegisterClientScriptBlock((sender as Control), this.GetType(), "alert", message, true);
}
else
{
BLL_ASL_Supplier.ASL_Send_CR_mail(CR_Status, UDFLib.ConvertToInteger(GetSessionUserID()), UDFLib.ConvertStringToNull(GetSuppID()), UDFLib.ConvertIntegerToNull(hdnCRID.Value));
string message = "alert('Change request Final Approved and Effected.')";
ScriptManager.RegisterClientScriptBlock((sender as Control), this.GetType(), "alert", message, true);
string msgDraft = String.Format("parent.ReloadParent_ByButtonID();");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msgDraft", msgDraft, true);
}
//Response.Redirect("../ASL/ASL_CR.aspx?Supplier_code=" + UDFLib.ConvertStringToNull(Request.QueryString["Supplier_code"].ToString()) + "");
//BindChangeRequest();
}
catch { }
{
}
}
protected void btnSaveDraft_Click(object sender, EventArgs e)
{
try
{
int RetValue = BLL_ASL_Supplier.Supplier_Data_Insert(UDFLib.ConvertIntegerToNull(ViewState["ReturnSupplierID"].ToString())
, UDFLib.ConvertStringToNull(Request.QueryString["Supp_ID"])
, UDFLib.ConvertStringToNull(txtCompanyResgName.Text.Trim()), UDFLib.ConvertStringToNull(txtSuppAddress.Text.Trim()), UDFLib.ConvertStringToNull(txtState.Text.Trim()), UDFLib.ConvertStringToNull(ddlCountry.SelectedItem.Text), UDFLib.ConvertIntegerToNull(ddlCountry.SelectedValue), UDFLib.ConvertStringToNull(txtPostalCode.Text),
UDFLib.ConvertStringToNull(txtTelephone1.Text.Trim()), UDFLib.ConvertStringToNull(txtTelephone2.Text.Trim()), UDFLib.ConvertStringToNull(txtAOHNumber1.Text.Trim()), UDFLib.ConvertStringToNull(txtAOHNumber2.Text.Trim()), UDFLib.ConvertStringToNull(txtFaxNumber1.Text.Trim()), UDFLib.ConvertStringToNull(txtFaxNumber2.Text.Trim()), UDFLib.ConvertStringToNull(txtCompanyEmail1.Text.Trim()), UDFLib.ConvertStringToNull(txtCompanyEmail2.Text.Trim())
, UDFLib.ConvertStringToNull(txtCompanyWebSite.Text.Trim()), UDFLib.ConvertStringToNull(txtCompanyRegNo.Text.Trim()), UDFLib.ConvertStringToNull(txtGstTaxRegNo.Text.Trim()), UDFLib.ConvertStringToNull(txtISOCertification.Text.Trim()), UDFLib.ConvertStringToNull(ddlBillingCurrency.SelectedItem.Text), UDFLib.ConvertIntegerToNull(ddlBillingCurrency.SelectedValue)
, ddlTitle1.SelectedValue, ddlTitle2.SelectedValue, UDFLib.ConvertStringToNull(txtNamePIC1.Text.Trim()), UDFLib.ConvertStringToNull(txtNamePIC2.Text.Trim()), UDFLib.ConvertStringToNull(txtDesignation1.Text.Trim()), UDFLib.ConvertStringToNull(txtDesignation2.Text.Trim())
, UDFLib.ConvertStringToNull(txtEmailPIC1.Text.Trim()), UDFLib.ConvertStringToNull(txtEmailPIC2.Text.Trim()), UDFLib.ConvertStringToNull(txtPhonePIC1.Text.Trim()), UDFLib.ConvertStringToNull(txtPhonePIC2.Text.Trim()), UDFLib.ConvertStringToNull(txtBankName.Text.Trim()), UDFLib.ConvertStringToNull(txtBankAddress.Text.Trim()), UDFLib.ConvertStringToNull(txtBankCode.Text.Trim())
, UDFLib.ConvertStringToNull(txtBranchCode.Text.Trim()), UDFLib.ConvertStringToNull(txtSwiftCode.Text.Trim()), UDFLib.ConvertStringToNull(txtIBANCode.Text.Trim()), UDFLib.ConvertStringToNull(txtBeneficiaryName.Text.Trim()), UDFLib.ConvertStringToNull(txtBeneficiaryAddress.Text.Trim()), UDFLib.ConvertStringToNull(txtBeneficiaryAccount.Text.Trim())
, UDFLib.ConvertStringToNull(ddlAccountCurrency.SelectedValue), UDFLib.ConvertStringToNull(txtNotifypayment.Text.Trim()), UDFLib.ConvertStringToNull(txtNotificationEmail.Text.Trim()), UDFLib.ConvertStringToNull(txtVerifiedName.Text.Trim())
, UDFLib.ConvertStringToNull(ddlDesignation.SelectedValue), "DRAFT", UDFLib.ConvertToInteger(Session["UserID"].ToString()), UDFLib.ConvertStringToNull(txtSkypeAdd.Text.Trim()), UDFLib.ConvertStringToNull(txtSkypeAdd2.Text.Trim()),
UDFLib.ConvertStringToNull(txtMobileNo.Text.Trim()), UDFLib.ConvertStringToNull(txtMobileNo2.Text.Trim()), UDFLib.ConvertStringToNull(txtScope.Text.Trim()), UDFLib.ConvertStringToNull(txtAddService.Text.Trim()), UDFLib.ConvertStringToNull(txtBankInfo.Text.Trim()), UDFLib.ConvertStringToNull(txtTaxAccNumber.Text));
ViewState["ReturnSupplierID"] = RetValue;
BindSupplierDataList();
string message = "alert('Supplier data saved as a Draft.')";
ScriptManager.RegisterClientScriptBlock((sender as Control), this.GetType(), "alert", message, true);
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
}
protected void SearchBindGrid()
{
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());
}
string SupplierID = GetSuppID();
//int Type = 0;
DataSet ds = BLL_ASL_Supplier.Get_Supplier_POInvoiceWIP(SupplierID, UDFLib.ConvertIntegerToNull(GetSessionUserID()), ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount);
if (ucCustomPagerItems.isCountRecord == 1)
{
//ucCustomPagerItems.CountTotalRec = ds.Tables[1].Rows[0]["RowCount"].ToString();
ucCustomPagerItems.CountTotalRec = rowcount.ToString();
ucCustomPagerItems.BuildPager();
}
if (ds.Tables[0].Rows.Count > 0)
{
gvPOInvoiceWIP.DataSource = ds;
gvPOInvoiceWIP.DataBind();
}
else
{
gvPOInvoiceWIP.DataSource = ds;
gvPOInvoiceWIP.DataBind();
}
if (ds.Tables[1].Rows.Count > 0)
{
txtPasskey.Text = ds.Tables[1].Rows[0]["Passkey"].ToString();
//txtPasskey.Text = "fa574eba-215a-4f3f-be75-9b2b44058b8b";
}
}
protected void btnApprove_Click(object sender, EventArgs e)
{
try
{
string CR_Status = "APPROVED";
string Action_On_Data_Form = "APPROVED";
int RetValue = Submit(CR_Status, Action_On_Data_Form);
if (RetValue == 0)
{
string message = "alert('No Rows Selected For Change.')";
ScriptManager.RegisterClientScriptBlock((sender as Control), this.GetType(), "alert", message, true);
}
else
{
BLL_ASL_Supplier.ASL_Send_CR_mail(CR_Status, UDFLib.ConvertToInteger(GetSessionUserID()), UDFLib.ConvertStringToNull(GetSuppID()), UDFLib.ConvertIntegerToNull(hdnCRID.Value));
string message = "alert('Change Request Approved.')";
ScriptManager.RegisterClientScriptBlock((sender as Control), this.GetType(), "alert", message, true);
string msgDraft = String.Format("parent.ReloadParent_ByButtonID();");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msgDraft", msgDraft, true);
}
}
catch { }
{
}
}
protected void BindRemarksGrid()
{
string SuppID = UDFLib.ConvertStringToNull(txtSupplierCode.Text.ToString());
DataTable dt = BLL_ASL_Supplier.Get_Supplier_Remarks(SuppID);
//gvRemarks.DataSource = dt;
//gvRemarks.DataBind();
}
protected void BindPOOutstandingGrid()
{
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());
}
string SupplierID = GetSuppID();
DataSet ds = BLL_ASL_Supplier.Get_Supplier_PO_OutStanding(SupplierID, ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount);
if (ucCustomPagerItems.isCountRecord == 1)
{
ucCustomPagerItems.CountTotalRec = ds.Tables[1].Rows[0]["RowCount"].ToString();
//ucCustomPagerItems.CountTotalRec = rowcount.ToString();
ucCustomPagerItems.BuildPager();
}
if (ds.Tables[0].Rows.Count > 0)
{
gvPOOutstanding.DataSource = ds.Tables[0];
gvPOOutstanding.DataBind();
}
else
{
gvPOOutstanding.DataSource = ds.Tables[0];
gvPOOutstanding.DataBind();
}
if (gvPOOutstanding.PageIndex == 0)
{
var lastRow = gvPOOutstanding.Rows[gvPOOutstanding.Rows.Count - 1];
lastRow.FindControl("ImgCreditView").Visible = false;
}
}
protected void BindEvaluationGrid()
{
try
{
DataTable dtType = ChkType();
ChkStatus();
DataTable dt = BLL_ASL_Supplier.Get_Supplier_Eval_Search(UDFLib.ConvertToInteger(GetSessionUserID()), txtfilter.Text != "" ? txtfilter.Text : null
, UDFLib.ConvertIntegerToNull(ddlSupplyPort.SelectedValue), UDFLib.ConvertStringToNull(ddlSupplyType.SelectedValue),
UDFLib.ConvertStringToNull(ddlEvaluationStatus.SelectedValue), dtType, CurrStatus, chkCredit.Checked ? 1 : 0, txtSupplierDesc.Text.Trim());
if (dt.Rows.Count > 0)
{
divEvaluation.Visible = true;
//divEval.Visible = true;
gvEvaluation.DataSource = dt;
gvEvaluation.DataBind();
}
else
{
divEvaluation.Visible = false;
//divEval.Visible = false;
gvEvaluation.DataSource = dt;
gvEvaluation.DataBind();
}
}
catch { }
{
}
}
//Approve And Reject Evaluation
protected void Submit()
{
try
{
if (Request.QueryString["url"] != null)
{
String msg2;
string Str = Request.QueryString["url"].ToString().Replace(" ", "+");
string url = DMS.DES_Encrypt_Decrypt.Decrypt(Str);
char[] delimiterChars = { '&', ' ', ',', '.', ':', '\t', '=' };
string[] Arrayurl = url.Split(delimiterChars);
string Evaluation_ID = Arrayurl[1].ToString();
string User_ID = Arrayurl[3].ToString();
string Evaluation_Status = Arrayurl[5].ToString();
string IPAdd = string.Empty;
IPAdd = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
if (string.IsNullOrEmpty(IPAdd))
{
IPAdd = Request.ServerVariables["REMOTE_ADDR"];
}
string Browser_Agent = Request.UserAgent;
int RetValue = BLL_ASL_Supplier.Pending_Evaluation_Approve_Reject(UDFLib.ConvertIntegerToNull(Evaluation_ID.ToString()), null, Evaluation_Status,
UDFLib.ConvertIntegerToNull(User_ID), IPAdd, Browser_Agent);
if (RetValue == 1)
{
msg2 = String.Format("alert('Authentication is incorrect,Please check Authentication.')");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", msg2, true);
}
if (RetValue == 4)
{
msg2 = String.Format("alert('Evaluation Approved Successfully.')");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", msg2, true);
}
if (RetValue == 2)
{
msg2 = String.Format("alert('Evaluation Already Approved.')");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", msg2, true);
}
if (RetValue == 3)
{
msg2 = String.Format("alert('Evaluation Already Rejected.')");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", msg2, true);
}
//string myclosescript = "<script language='javascript' type='text/javascript'>CloseWindow();</script>";
string myclosescript = "<script language='javascript' type='text/javascript'>closeWin();</script>";
Page.ClientScript.RegisterStartupScript(GetType(), "myclosescript", myclosescript);
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void BindGrid()
{
string Supplier_Code = GetSupplierCode();
string Supp_ID = GetSuppID();
//txtFileID.Text = GetFileID();
// int? SuppID = UDFLib.ConvertIntegerToNull(Request.QueryString["Supp_ID"]);
DataSet ds = BLL_ASL_Supplier.Get_Supplier_Upload_Document(UDFLib.ConvertStringToNull(Supplier_Code), UDFLib.ConvertStringToNull(Supp_ID), "CREDIT", UDFLib.ConvertStringToNull(txtFileID.Text.Trim()));
//ViewState["RetFileID"] = FileID;
if (ds.Tables[0].Rows.Count > 0)
{
lblVessel.Text = ds.Tables[0].Rows[0]["Vessel_Name"].ToString();
lblRef.Text = ds.Tables[0].Rows[0]["Office_Ref_Code"].ToString();
lblDated.Text = ds.Tables[0].Rows[0]["LineDate"].ToString();
lblAmount.Text = ds.Tables[0].Rows[0]["Line_Amount"].ToString();
}
if (ds.Tables[1].Rows.Count > 0)
{
lblFileName.Text = ds.Tables[1].Rows[0]["File_Name"].ToString();
txtInvioceRef.Text = ds.Tables[1].Rows[0]["Invoice_Reference"].ToString();
txtInvoiceDate.Text = ds.Tables[1].Rows[0]["Invoice_Date"].ToString();
txtInvoiceAmount.Text = ds.Tables[1].Rows[0]["Invoice_Amount"].ToString();
txtTaxAmount.Text = ds.Tables[1].Rows[0]["Invoice_GST_Amount"].ToString();
txtDueDate.Text = ds.Tables[1].Rows[0]["Invoice_Due_Date"].ToString();
txtRemarks.Text = ds.Tables[1].Rows[0]["Invoice_Remarks"].ToString();
lblInvoiceReferance.Text = ds.Tables[1].Rows[0]["Invoice_Reference"].ToString();
lblDate.Text = ds.Tables[1].Rows[0]["Invoice_Date"].ToString();
lblInvoiceAmount.Text = ds.Tables[1].Rows[0]["Invoice_Amount"].ToString();
//lblFileName.Text = ds.Tables[1].Rows[0]["File_Path"].ToString();
//"../uploads/ASL/"
string FilePath = ds.Tables[1].Rows[0]["File_Path"].ToString();
string FileLocation = HttpContext.Current.Server.MapPath("../Uploads/ASL/Invoice/" + FilePath);
if (FilePath != "")
{
divIframe.Visible = true;
iFrame1.Attributes["src"] = @"../Uploads/ASL/Invoice/" + FilePath;
}
if (ds.Tables[1].Rows[0]["File_Status"].ToString() == "SUBMITTED")
{
DivStep4.Visible = true;
btnSubmit.Enabled = false;
btnUploadInvoice.Enabled = false;
btnRecallInvoice.Enabled = true;
}
}
string Type = GetInvoiceType();
if (Type == "1")
{
DivStep3.Visible = true;
}
else
{
Divstep1.Visible = true;
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
int?SuppID = UDFLib.ConvertIntegerToNull(Request.QueryString["Supp_ID"]);
int RetValue = BLL_ASL_Supplier.Supplier_Remarks_Insert(UDFLib.ConvertToInteger(ViewState["ReturnSupplierID"]), UDFLib.ConvertStringToNull(SuppID), AmendType, GeneralType, GreenType, YellowType, RedType, txtRemarks.Text,
UDFLib.ConvertToInteger(Session["UserID"].ToString()));
BindRemarksGrid();
ClearControl();
}
protected void BindRemarksGrid()
{
string SuppID = UDFLib.ConvertStringToNull(Request.QueryString["Supp_ID"]);
//int? SuppID = 2737;
DataTable dt = BLL_ASL_Supplier.Get_Supplier_Remarks(SuppID);
gvRemarks.DataSource = dt;
gvRemarks.DataBind();
}
protected void lbtnDelete_Click(object s, CommandEventArgs e)
{
string[] arg = e.CommandArgument.ToString().Split(',');
int? RemarksID = UDFLib.ConvertIntegerToNull(arg[0]);
int RetValue = BLL_ASL_Supplier.Delete_Supplier_Remarks(RemarksID, UDFLib.ConvertToInteger(Session["UserID"].ToString()));
BindRemarksGrid();
}
protected int Submit(string CR_Status, string Action_On_Data_Form)
{
DataTable dtcr = new DataTable();
dtcr.Columns.Add("PKID");
dtcr.Columns.Add("Field_Name");
dtcr.Columns.Add("Old_Value");
dtcr.Columns.Add("New_Value");
dtcr.Columns.Add("Reason_For_Change");
dtcr.Columns.Add("Approver");
dtcr.Columns.Add("Final_Approver");
foreach (RepeaterItem item in rpt1.Items)
{
DropDownList ddlApprover = item.FindControl("ddlApprover") as DropDownList;
DropDownList ddlFinalApprover = item.FindControl("ddlFinalApprover") as DropDownList;
Repeater nestedRepeater = item.FindControl("rpt2") as Repeater;
foreach (RepeaterItem nestedItem in nestedRepeater.Items)
{
CheckBox chkIsActive = nestedItem.FindControl("chk") as CheckBox;
Label lblFields_Name = nestedItem.FindControl("lblFieldsName") as Label;
Label lblCurrentValue = nestedItem.FindControl("lblCurrentValue") as Label;
Label lblNew_Value = nestedItem.FindControl("lblNewValue") as Label;
Label lblReason_For_Change = nestedItem.FindControl("lblReason_For_Change") as Label;
if (chkIsActive.Checked == true && chkIsActive != null)
{
DataRow dr = dtcr.NewRow();
dr["PKID"] = 0;
dr["Field_Name"] = lblFields_Name.Text;
dr["Old_Value"] = lblCurrentValue.Text;
dr["New_Value"] = lblNew_Value.Text;
dr["Reason_For_Change"] = lblReason_For_Change.Text;
dr["Approver"] = ddlApprover.SelectedValue;
dr["Final_Approver"] = ddlFinalApprover.SelectedValue;
dtcr.Rows.Add(dr);
}
}
}
int RetValue = 0;
if (dtcr.Rows.Count > 0)
{
RetValue = BLL_ASL_Supplier.Supplier_ChangeRequest_Status_Update(UDFLib.ConvertIntegerToNull(hdnCRID.Value), UDFLib.ConvertStringToNull(lblSupplierCode.Text), dtcr, CR_Status, Action_On_Data_Form, UDFLib.ConvertToInteger(GetSessionUserID()));
hdnCRID.Value = Convert.ToString(RetValue);
if (CR_Status == "EFFECTED")
{
SaveChildtable(CR_Status, Action_On_Data_Form);
}
return(RetValue);
}
else
{
return(RetValue);
}
}
protected void BindPaymenterms()
{
DataTable dt = BLL_ASL_Supplier.Get_ASL_System_Parameter(43, null, UDFLib.ConvertToInteger(GetSessionUserID()));
ddlPaymentTerms.DataSource = dt;
ddlPaymentTerms.DataValueField = "Code";
ddlPaymentTerms.DataTextField = "Name";
ddlPaymentTerms.DataBind();
ddlPaymentTerms.SelectedValue = "44";
}
protected void BindType(int Type)
{
DataTable dt = BLL_ASL_Supplier.Get_ASL_System_Parameter(Type, null, UDFLib.ConvertToInteger(GetSessionUserID()));
ddlType.DataSource = dt;
ddlType.DataValueField = "Description";
ddlType.DataTextField = "Name";
ddlType.DataBind();
ddlType.Items.Insert(0, new ListItem("-SELECT-", "0"));
}
protected void BindStatus()
{
DataTable dt = BLL_ASL_Supplier.Get_ASL_System_Parameter(8, "", UDFLib.ConvertToInteger(Session["UserID"].ToString()));
ddlStatus.DataSource = dt;
ddlStatus.DataTextField = "Name";
ddlStatus.DataValueField = "Code";
ddlStatus.DataBind();
ddlStatus.Items.Insert(0, new ListItem("-SELECT-", "0"));
}
protected void SaveChildtable(string CR_Status, string Action_On_Data_Form)
{
try
{
BLL_ASL_Supplier.ASL_CR_Supplier_Child_Insert(UDFLib.ConvertIntegerToNull(hdnCRID.Value), UDFLib.ConvertStringToNull(lblSupplierCode.Text), CR_Status, Action_On_Data_Form, UDFLib.ConvertToInteger(GetSessionUserID()));
}
catch { }
{
}
}
protected void BindEmailStatus()
{
DataTable dt = BLL_ASL_Supplier.Get_ASL_System_Parameter(55, null, UDFLib.ConvertToInteger(Session["UserID"].ToString()));
ddlEmailStatus.DataSource = dt;
ddlEmailStatus.DataValueField = "Name";
ddlEmailStatus.DataTextField = "Description";
ddlEmailStatus.DataBind();
ddlEmailStatus.Items.Insert(0, new ListItem("-Select-", "0"));
}
protected void BindScope()
{
DataSet ds = BLL_ASL_Supplier.Get_Supplier_Scope(UDFLib.ConvertStringToNull(Request.QueryString["Supp_ID"]));
ddlSupplyType.DataSource = ds;
ddlSupplyType.DataTextField = "Scope_Name";
ddlSupplyType.DataValueField = "Scope_ID";
ddlSupplyType.DataBind();
ddlSupplyType.Items.Insert(0, new ListItem("-All Scopes-", "0"));
}
protected void BindOwnerShip()
{
DataTable dt = BLL_ASL_Supplier.Get_ASL_System_Parameter(26, null, UDFLib.ConvertToInteger(GetSessionUserID()));
ddlownerShip.DataSource = dt;
ddlownerShip.DataValueField = "Code";
ddlownerShip.DataTextField = "Name";
ddlownerShip.DataBind();
ddlownerShip.SelectedValue = "30";
}
protected void BindEvaluationStatus()
{
DataTable dt = BLL_ASL_Supplier.Get_ASL_System_Parameter_Evaluation(15, "", UDFLib.ConvertToInteger(GetSessionUserID()));
ddlEvaluationStatus.DataSource = dt;
ddlEvaluationStatus.DataTextField = "Name";
ddlEvaluationStatus.DataValueField = "Description";
ddlEvaluationStatus.DataBind();
ddlEvaluationStatus.Items.Insert(0, new ListItem("-All-", "0"));
}
protected void BindProposeStatus()
{
ddlProposedStatus.DataSource = null;
DataTable dt = BLL_ASL_Supplier.Get_ASL_System_Parameter(22, "", UDFLib.ConvertToInteger(GetSessionUserID()));
ddlProposedStatus.DataSource = dt;
ddlProposedStatus.DataTextField = "Name";
ddlProposedStatus.DataValueField = "Name";
ddlProposedStatus.DataBind();
}
//Send Mail
protected void SendEmail(string Evaluationstatus, string Approve, string Reject)
{
try
{
int RetValue = BLL_ASL_Supplier.Evaluation_Send_Email(UDFLib.ConvertIntegerToNull(ViewState["ReturnEvalutionID"].ToString()), UDFLib.ConvertStringToNull(GetSuppID()), Evaluationstatus,
UDFLib.ConvertIntegerToNull(GetSessionUserID()), Approve, Reject);
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
}
protected void BindGrid()
{
string SupplierID = GetSuppID();
// int? SuppID = UDFLib.ConvertIntegerToNull(Request.QueryString["Supp_ID"]);
DataSet ds = BLL_ASL_Supplier.Get_Supplier_Attachment(UDFLib.ConvertStringToNull(SupplierID));
gvDataAttachment.DataSource = ds.Tables[0];
gvDataAttachment.DataBind();
gvCompanyAttachment.DataSource = ds.Tables[1];
gvCompanyAttachment.DataBind();
gvAllAtttachment.DataSource = ds.Tables[2];
gvAllAtttachment.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(Request.QueryString["Supp_ID"].ToString()))
{
//Supplier_Data_Insert
DataTable dt = BLL_ASL_Supplier.Supplier_Email_Verification(UDFLib.ConvertStringToNull(Request.QueryString["Supp_ID"].ToString()));
if (dt.Rows.Count > 0)
{
lbl1.Text = "Email Verification Successfully.";
}
}
}