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