public void SendMail(int reqid)
{
try
{
DataSet dslogin = new DataSet();
DataSet Ds = new DataSet();
string StrError = string.Empty;
DMPurchaseOrder obj_PO = new DMPurchaseOrder();
Ds = obj_PO.GetPOForPrint(reqid, out StrError);
if (Ds.Tables.Count > 0 && Ds.Tables[0].Rows.Count > 0)
{
//-------------------------------------------------[Mail Code]-------------------------------------------------
string smtpServer = "smtp.gmail.com"; //localhost
string userName = "******"; //[email protected]
string password = "******"; //saprapune@12345
int cdoBasic = 1;
int cdoSendUsingPort = 2;
MailMessage msg = new MailMessage();
if (userName.Length > 0)
{
msg.Fields.Add("http://schemas.microsoft.com/cdo/configuration/smtpserver", smtpServer);
msg.Fields.Add("http://schemas.microsoft.com/cdo/configuration/smtpserverport", 465);
msg.Fields.Add("http://schemas.microsoft.com/cdo/configuration/sendusing", cdoSendUsingPort);
msg.Fields.Add("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate", cdoBasic);
msg.Fields.Add("http://schemas.microsoft.com/cdo/configuration/sendusername", userName);
msg.Fields.Add("http://schemas.microsoft.com/cdo/configuration/sendpassword", password);
msg.Fields.Add("http://schemas.microsoft.com/cdo/configuration/smtpusessl", true);
}
msg.To = "*****@*****.**";
//if (txtCC.Text != "")
//{
// msg.Cc = txtCC.Text;
//}
//if (txtBcc.Text != "")
//{
// msg.Bcc = txtBcc.Text;
//}
msg.From = "*****@*****.**";
msg.Subject = "PO " + Ds.Tables[0].Rows[0]["PONo"].ToString().ToUpper() + " Has Been Approved";
string mystring = "Hello Sir,<br/> PO No. : " + Ds.Tables[0].Rows[0]["PONo"].ToString() + "<br/>" + "PO Date :" + Ds.Tables[0].Rows[0]["PODate"].ToString() + "<br/> Please Check This PO";
mystring = mystring.Replace("<br/>", System.Environment.NewLine);
msg.Body = mystring.ToString();
SmtpMail.SmtpServer = smtpServer;
SmtpMail.Send(msg);
}
// -------------------------------------------------[End Mail Code]-------------------------------------------------
}
catch (Exception)
{
}
}
protected void BTNLOGINFORM_Click(object sender, EventArgs e)
{
try
{
DataSet DS = new DataSet();
DMPurchaseOrder DMPO = new DMPurchaseOrder();
DS = DMPO.GETACCESSForReport(Convert.ToInt32(Session["UserId"]), TXTPASSWORDFORM.Text.Trim(), out StrError);
if (DS.Tables.Count > 0 && DS.Tables[0].Rows.Count > 0)
{
Panel1.Visible = false;
}
else
{
Obj_Comm.ShowPopUpMsg("Password Not Match......Please Try Again!", this.Page);
}
}
catch (ThreadAbortException)
{
}
catch (Exception ex) { Obj_Comm.ShowPopUpMsg(ex.Message + " --> THIS ERROR OCCURED WHILE UPDATING DATA.", this.Page); }
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
EditModeId = Convert.ToInt32(Request.QueryString["ID"]);
OpenForm = Convert.ToString(Request.QueryString["Flag"]);
switch (OpenForm)
{
//Purchase Order details
case "PS":
{
DMPurchaseOrder oDMPurchaseOrder = new DMPurchaseOrder();
dsLogin = oDMPurchaseOrder.PrintPOReport_SupplierWise(EditModeId, out strError);
dsLogin.Tables[0].TableName = "PurchaseOrder_Master";
//dsLogin.Tables[1].TableName = "PurchaseOrder_Details";
//-------------------------------------------
if (dsLogin.Tables.Count > 0)
{
for (int i = 0; i < dsLogin.Tables[0].Rows.Count; i++)
{
pric += Convert.ToDecimal(dsLogin.Tables[0].Rows[i]["NetAmount"].ToString());
}
}
TotAmt = WordAmount.convertcurrency(pric);
DataColumn column = new DataColumn("Number2Word");
column.DataType = typeof(string);
dsLogin.Tables[0].Columns.Add("Number2Word");
dsLogin.Tables[0].Rows[dsLogin.Tables[0].Rows.Count - 1]["Number2Word"] = TotAmt.ToString();
//-------------------------------------------
CRpt.Load(Server.MapPath("~/PrintReport/PurchaseOrder/PurchaseOrder_SupplierWise.rpt"));
CRpt.SetDataSource(dsLogin);
break;
}
//Authorised Purchase Order
case "PO":
{
DMPurchaseOrder oDMPurchaseOrder = new DMPurchaseOrder();
dsLogin = oDMPurchaseOrder.PrintPOReport_SupplierWise(EditModeId, out strError);
dsLogin.Tables[0].TableName = "PurchaseOrder_Master";
//dsLogin.Tables[1].TableName = "PurchaseOrder_Details";
//-------------------------------------------
if (dsLogin.Tables.Count > 0)
{
for (int i = 0; i < dsLogin.Tables[0].Rows.Count; i++)
{
pric += Convert.ToDecimal(dsLogin.Tables[0].Rows[i]["NetAmount"].ToString());
}
}
TotAmt = WordAmount.convertcurrency(pric);
DataColumn column = new DataColumn("Number2Word");
column.DataType = typeof(string);
dsLogin.Tables[0].Columns.Add("Number2Word");
dsLogin.Tables[0].Rows[dsLogin.Tables[0].Rows.Count - 1]["Number2Word"] = TotAmt.ToString();
//-------------------------------------------
CRpt.Load(Server.MapPath("~/PrintReport/PurchaseOrder/Authorized PurchaseOrder.rpt"));
CRpt.SetDataSource(dsLogin);
break;
}
}
CrystalReportViewer1.ReportSource = CRpt;
CrystalReportViewer1.DataBind();
CrystalReportViewer1.DisplayToolbar = true;
}
catch (Exception ex)
{
}
}
protected void BtnUpdate_Click(object sender, EventArgs e)
{
try
{
int InsertRowDtls = 0, iUpdate = 0;
if (ddlCompany.SelectedValue != "0")
{
Entity_PurchaseOrder.POId = Convert.ToInt32(ddlpono.SelectedValue.ToString());
Entity_PurchaseOrder.PODate = Convert.ToDateTime(txtpodate.Text.ToString());
Entity_PurchaseOrder.SubTotal = txtSubTotal.Text.Equals("") ? 0 : Convert.ToDecimal(txtSubTotal.Text);
Entity_PurchaseOrder.Discount = txtDiscount.Text.Equals("") ? 0 : Convert.ToDecimal(txtDiscount.Text);
Entity_PurchaseOrder.Vat = txtVATAmount.Text.Equals("") ? 0 : Convert.ToDecimal(txtVATAmount.Text);
Entity_PurchaseOrder.GrandTotal = txtGrandTotal.Text.Equals("") ? 0 : Convert.ToDecimal(txtGrandTotal.Text);
Entity_PurchaseOrder.HamaliAmt = txtHamaliAmt.Text.Equals("") ? 0 : Convert.ToDecimal(txtHamaliAmt.Text);
Entity_PurchaseOrder.FreightAmt = txtFreightAmt.Text.Equals("") ? 0 : Convert.ToDecimal(txtFreightAmt.Text);
Entity_PurchaseOrder.PostageAmt = txtPostageAmt.Text.Equals("") ? 0 : Convert.ToDecimal(txtPostageAmt.Text);
Entity_PurchaseOrder.OtherCharges = txtOtherCharges.Text.Equals("") ? 0 : Convert.ToDecimal(txtOtherCharges.Text);
Entity_PurchaseOrder.ServiceTaxPer = Convert.ToDecimal(DDLSERVICETAX.SelectedItem.ToString());
Entity_PurchaseOrder.ServiceTaxAmt = Convert.ToDecimal(txtSerTax.Text.ToString());
Entity_PurchaseOrder.CompanyID = Convert.ToInt32(ddlCompany.SelectedValue.ToString());
Entity_PurchaseOrder.Instruction = txtNarration.Text.Trim();
Entity_PurchaseOrder.UserId = Convert.ToInt32(Session["UserId"]);
Entity_PurchaseOrder.LoginDate = DateTime.Now;
Entity_PurchaseOrder.POQTDATE = Convert.ToDateTime(txtquotdate.Text.ToString()).ToString();
Entity_PurchaseOrder.ExcisePer = Convert.ToDecimal(txtexcisedutyper.Text.ToString());
Entity_PurchaseOrder.ExciseAmount = Convert.ToDecimal(txtexciseduty.Text.ToString());
if (CHKHAMALI.Checked == true)
{
Entity_PurchaseOrder.HamaliActual = 1;
}
if (CHKHAMALI.Checked == false)
{
Entity_PurchaseOrder.HamaliActual = 0;
}
if (CHKFreightAmt.Checked == true)
{
Entity_PurchaseOrder.FreightActual = 1;
}
if (CHKFreightAmt.Checked == false)
{
Entity_PurchaseOrder.FreightActual = 0;
}
if (CHKOtherCharges.Checked == true)
{
Entity_PurchaseOrder.OtherChargeActual = 1;
}
if (CHKOtherCharges.Checked == false)
{
Entity_PurchaseOrder.OtherChargeActual = 0;
}
if (CHKLoading.Checked == true)
{
Entity_PurchaseOrder.LoadingActual = 1;
}
if (CHKLoading.Checked == false)
{
Entity_PurchaseOrder.LoadingActual = 0;
}
iUpdate = Obj_PurchaseOrder.UpdateRecord(ref Entity_PurchaseOrder, out StrError);
if (iUpdate > 0)
{
if (ViewState["POCurrentTable"] != null)
{
DataTable dttable = new DataTable();
dttable = (DataTable)ViewState["POCurrentTable"];
for (int v = 0; v < GrdReqPO.Rows.Count; v++)
{
DMPurchaseOrder oDMPO = new DMPurchaseOrder();
PurchaseOrder pod = new PurchaseOrder();
pod.POId = Convert.ToInt32(ddlpono.SelectedValue.ToString());
pod.ItemId = Convert.ToInt32(GrdReqPO.Rows[v].Cells[2].Text);
pod.Qty = Convert.ToDecimal(((TextBox)GrdReqPO.Rows[v].FindControl("GrdtxtOrdQty")).Text);
pod.Rate = Convert.ToDecimal(((TextBox)GrdReqPO.Rows[v].FindControl("GrdtxtRate")).Text);
pod.Amount = Convert.ToDecimal(((TextBox)GrdReqPO.Rows[v].FindControl("GrdtxtOrdQty")).Text) * Convert.ToDecimal(((TextBox)GrdReqPO.Rows[v].FindControl("GrdtxtRate")).Text);
pod.TaxPer = Convert.ToDecimal(((TextBox)GrdReqPO.Rows[v].FindControl("GrdtxtPerVAT")).Text);
pod.TaxAmount = Convert.ToDecimal(((TextBox)GrdReqPO.Rows[v].FindControl("GrdtxtVAT")).Text);
pod.DiscPer = Convert.ToDecimal(((TextBox)GrdReqPO.Rows[v].FindControl("GrdtxtPerDISC")).Text);
pod.DiscAmt = Convert.ToDecimal(((TextBox)GrdReqPO.Rows[v].FindControl("GrdtxtDISC")).Text);
pod.NetAmount = ((Convert.ToDecimal(((TextBox)GrdReqPO.Rows[v].FindControl("GrdtxtOrdQty")).Text) * Convert.ToDecimal(((TextBox)GrdReqPO.Rows[v].FindControl("GrdtxtRate")).Text)) - Convert.ToDecimal(((TextBox)GrdReqPO.Rows[v].FindControl("GrdtxtDISC")).Text)) + Convert.ToDecimal(((TextBox)GrdReqPO.Rows[v].FindControl("GrdtxtVAT")).Text);
pod.RequisitionCafeId = Convert.ToInt32(GrdReqPO.Rows[v].Cells[3].Text);
pod.FK_UnitConvDtlsId = Convert.ToInt32(((DropDownList)GrdReqPO.Rows[v].FindControl("GrdddlUOM")).SelectedValue);
pod.MainQty = 0;
pod.RemarkForPO = Convert.ToString(((TextBox)GrdReqPO.Rows[v].FindControl("GrdtxtRemarkForPO")).Text);
pod.CHKFLAG = (((CheckBox)GrdReqPO.Rows[v].FindControl("GrdReqPO_CHK")).Checked)?1:0;
InsertRowDtls = Obj_PurchaseOrder.Insert_PurchaseOrderDtls(ref pod, Convert.ToInt32(GrdReqPO.Rows[v].Cells[4].Text), out StrError);
oDMPO = null;
pod = null;
}
}
if (InsertRowDtls > 0)
{
DMAuthorisedPurchaseOrder ODMPUR = new DMAuthorisedPurchaseOrder();
PurchaseOrder ENPUR = new PurchaseOrder();
ENPUR.POId = Convert.ToInt32(ddlpono.SelectedValue.ToString());
ENPUR.Title = "";
ENPUR.TermsCondition = Convert.ToString(TXTTERMSCONDITION.Text);
InsertRowDtls = ODMPUR.Update_PurchaseOrderTandC(ref ENPUR, Convert.ToString(TXTPaymentTerms.Text), out StrError);
ODMPUR = null;
ENPUR = null;
}
if (InsertRowDtls != 0)
{
obj_Comman.ShowPopUpMsg("Record Updated Successfully!", this.Page);
int GETUPDATES = Obj_PurchaseOrder.UpdateInsert_PurchseOrder(Convert.ToInt32(ddlpono.SelectedValue.ToString()), out StrError);
//Response.Redirect("~/CrystalPrint/PrintCryRpt.aspx?ID=" + Convert.ToInt32(ddlpono.SelectedValue.ToString()) + "&Flag=CPS&SFlag=Authorised&PDFFlag=PDF&PrintFlag=NO");
MakeEmptyForm();
}
else
{
obj_Comman.ShowPopUpMsg(StrError, this.Page);
}
}
}
else
{
obj_Comman.ShowPopUpMsg("Please select company!", this.Page);
}
}
catch (Exception ex) { obj_Comman.ShowPopUpMsg(ex.Message + " --> THIS ERROR OCCURED WHILE UPDATING DATA.", this.Page); }
}
public string GETPDF(int reqid)
{
DMPurchaseOrder obj_PO = new DMPurchaseOrder();
string StrError = string.Empty;
string PDFMaster = string.Empty;
ReportDocument CRpt = new ReportDocument();
DataSet dslogin = new DataSet();
dslogin = obj_PO.GetPOForPrint(reqid, out StrError);
if (dslogin.Tables.Count <= 0)
{
return(string.Empty);
}
dslogin.Tables[0].TableName = "PurchaseOrderMaster";
dslogin.Tables[1].TableName = "PO";
dslogin.Tables[2].TableName = "PurchaseOrderTerms";
dslogin.Tables[3].TableName = "PurchaseOrderDetails";
dslogin.Tables[4].TableName = "PurchaseOrderNetAMT";
dslogin.Tables[5].TableName = "COMPANY";
dslogin.Tables[7].TableName = "POFROMPAYMENT";
dslogin.Tables[8].TableName = "SITENAME";
//----------------------------Image Print---------------------------------------------------------------
string Image = dslogin.Tables[5].Rows[0]["CLogo"].ToString();
string ImageSign = dslogin.Tables[5].Rows[0]["DigitalSignature"].ToString();
string ImageSign1 = dslogin.Tables[5].Rows[0]["DigitalSignature1"].ToString();
string ImageSign2 = dslogin.Tables[5].Rows[0]["DigitalSignature2"].ToString();
dslogin.Tables[5].Columns.Add("CompanyLogo", System.Type.GetType("System.Byte[]"));
dslogin.Tables[5].Columns.Add("Sign1", System.Type.GetType("System.Byte[]"));
dslogin.Tables[5].Columns.Add("Sign2", System.Type.GetType("System.Byte[]"));
dslogin.Tables[5].Columns.Add("Sign3", System.Type.GetType("System.Byte[]"));
Image = Image.Replace("~", "");
Image = Image.Replace("/", "\\");
ImageSign = ImageSign.Replace("~", "");
ImageSign = ImageSign.Replace("/", "\\");
ImageSign1 = ImageSign1.Replace("~", "");
ImageSign1 = ImageSign1.Replace("/", "\\");
ImageSign2 = ImageSign2.Replace("~", "");
ImageSign2 = ImageSign2.Replace("/", "\\");
FileStream fs;
BinaryReader br;
if (File.Exists(AppDomain.CurrentDomain.BaseDirectory + Image))
{
fs = new FileStream(AppDomain.CurrentDomain.BaseDirectory + Image, FileMode.Open);
br = new BinaryReader(fs);
byte[] imgbyte = new byte[fs.Length + 1];
imgbyte = br.ReadBytes(Convert.ToInt32((fs.Length)));
dslogin.Tables[5].Rows[0]["CompanyLogo"] = imgbyte;
dslogin.Tables[5].Rows[dslogin.Tables[5].Rows.Count - 1]["CompanyLogo"] = imgbyte;
br.Close();
fs.Close();
}
FileStream fss1;
BinaryReader brs1;//
if ((dslogin.Tables[0].Rows[0]["Status"].ToString()) == "Authorised")
{
if (File.Exists(AppDomain.CurrentDomain.BaseDirectory + ImageSign))
{
fss1 = new FileStream(AppDomain.CurrentDomain.BaseDirectory + ImageSign, FileMode.Open);
brs1 = new BinaryReader(fss1);
byte[] imgbyte1 = new byte[fss1.Length + 1];
imgbyte1 = brs1.ReadBytes(Convert.ToInt32((fss1.Length)));
dslogin.Tables[5].Rows[0]["Sign1"] = imgbyte1;
dslogin.Tables[5].Rows[dslogin.Tables[5].Rows.Count - 1]["Sign1"] = imgbyte1;
brs1.Close();
fss1.Close();
}
}
FileStream fss2;
BinaryReader brs2;
if (File.Exists(AppDomain.CurrentDomain.BaseDirectory + ImageSign1))
{
fss2 = new FileStream(AppDomain.CurrentDomain.BaseDirectory + ImageSign1, FileMode.Open);
brs2 = new BinaryReader(fss2);
byte[] imgbyte2 = new byte[fss2.Length + 1];
imgbyte2 = brs2.ReadBytes(Convert.ToInt32((fss2.Length)));
dslogin.Tables[5].Rows[0]["Sign2"] = imgbyte2;
dslogin.Tables[5].Rows[dslogin.Tables[5].Rows.Count - 1]["Sign2"] = imgbyte2;
brs2.Close();
fss2.Close();
}
FileStream fss3;
BinaryReader brs3;
if (File.Exists(AppDomain.CurrentDomain.BaseDirectory + ImageSign2))
{
fss3 = new FileStream(AppDomain.CurrentDomain.BaseDirectory + ImageSign2, FileMode.Open);
brs3 = new BinaryReader(fss3);
byte[] imgbyte3 = new byte[fss3.Length + 1];
imgbyte3 = brs3.ReadBytes(Convert.ToInt32((fss3.Length)));
dslogin.Tables[5].Rows[0]["Sign3"] = imgbyte3;
dslogin.Tables[5].Rows[dslogin.Tables[5].Rows.Count - 1]["Sign3"] = imgbyte3;
brs3.Close();
fss3.Close();
}
//-------------------------------------------------------------------------------------------
CRpt.Load(Server.MapPath("~/CrystalPrint/PurchaseOrder_OLD.rpt"));
CRpt.SetDataSource(dslogin);
string DATE = DateTime.Now.ToString("dd-MMM-yyyy ss");
PDFMaster = Server.MapPath(@"~/TempFiles/" + "PO - " + DATE + ".pdf");
CRpt.ExportToDisk(ExportFormatType.PortableDocFormat, PDFMaster);
CHKATTACHBROUCHER.Checked = true;
CHKATTACHBROUCHER.Text = "PO Details";
CHKATTACHBROUCHER.ToolTip = PDFMaster;
iframepdf.Attributes.Add("src", "../TempFiles/" + "PO - " + (DATE) + ".pdf");
//iframepdf.Attributes.Add("src","C:/Users/comp01/Downloads/Kunal Passports.pdf");
return(PDFMaster);
}
