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:"));
}
