public bool SendEmailForRFQ(RFQVM _RFQVM, string emailId, string suppName, string suppCode)
{
try
{
string strPDFFileName = string.Format("RFQ" + DateTime.Now.ToString("yyyyMMdd") + suppCode + ".pdf");
string strAttachment = Server.MapPath("~/EmpProfileImages/" + strPDFFileName);
//call fun to convert in to pdf
ConvertIntoPDF(_RFQVM, suppName, suppCode, strAttachment);
string subject = "";
string body = "";
subject = "Company Name - RFQ Details";
body = "Dear " + suppName + ",<br/><br/> Your Supplier Code: " + suppCode +
"<br/><br/><br/> Your Matter ";
MailMessage mailMessage = new MailMessage()
{
Subject = subject,
Body = body,
IsBodyHtml = true
};
//attach that pdf to mailmessage
mailMessage.Attachments.Add(new Attachment(strAttachment));
mailMessage.To.Add(new MailAddress(emailId));
SmtpClient smtpClient = new SmtpClient();
smtpClient.Send(mailMessage);
return(true);
}
catch (Exception e)
{
return(false);
}
}
public ActionResult SendRFQ(int id)
{
RFQVM rfq = new RFQVM();
if (id != 0)
{
try
{
rfq = _RFQSerivce.GetRFQById(id);
bool isSend = false;
int[] Arrid = rfq.SupplierId.Split(',').Select(x => int.Parse(x)).ToArray();
foreach (var sid in Arrid)
{
var supp = _RFQSerivce.GetSupplier(sid);
isSend = SendEmailForRFQ(rfq, supp.Email, supp.SupplierName, supp.SupplierCode);
}
if (isSend)
{
_RFQSerivce.SetMailSend(id);
// ViewBag.message = "Mail sent successfully..";
return(Json(new { message = "Mail sent successfully.." }, JsonRequestBehavior.AllowGet));
}
else
{
// ViewBag.message = "Error in email processing..";
return(Json(new { message = "Error in email processing.." }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception e) { throw e; }
}
else
{
return(Json(new { message = "Error in email processing.." }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddOrEditRFQ(RFQVM _RFQVM)
{
try
{
ViewBag.supplierList = dropDown.DDLGetSuppliers();
ViewBag.ItemList = dropDown.DDLGetItems();
ViewBag.UnitList = dropDown.DDLGetUnits();
ViewBag.TaxList = dropDown.DDLGetTax();
if (ModelState.IsValid)
{
//save rfq and details
bool status = false;
status = _RFQSerivce.AddRFQ(_RFQVM);
if (status)
{
return(Json(new { success = true, message = "Saved Successfully...!" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, message = "Error..!" }, JsonRequestBehavior.AllowGet));
}
}
else
{
return(PartialView(_RFQVM));
}
}
catch (Exception e)
{
throw e;
}
}
public ActionResult ShowRFQDetails(int id)
{
RFQVM rfqVM = new RFQVM();
if (id != 0)
{
rfqVM = _RFQSerivce.GetRFQById(id);
}
return(PartialView(rfqVM));
}
public bool AddRFQ(RFQVM _RFQVM)
{
try
{
if (_RFQVM != null)
{
tblRFQ rfq = new tblRFQ();
rfq.BidValidUntil = _RFQVM.BidValidUntil;
rfq.CompanyName = _RFQVM.CompanyName;
rfq.DeliverTo = _RFQVM.DeliverTo;
rfq.OrderDate = _RFQVM.OrderDate;
rfq.RfqDate = _RFQVM.RfqDate;
rfq.RfqNo = _RFQVM.RfqNo;
rfq.ScheduleDate = _RFQVM.ScheduleDate;
rfq.SupplierId = _RFQVM.SupplierId;
rfq.TotalAmount = _RFQVM.TotalAmount;
rfq.createdBy = user.RoleId;
rfq.CreatedDate = System.DateTime.Now;
rfq.ModifiedDate = System.DateTime.Now;
rfq.ModifiedBy = user.RoleId;
rfq.isDeleted = false;
rfq.IsEmailSent = false;
_RFQRepository.Add(rfq);
foreach (var detail in _RFQVM._RFQDetailsVMList)
{
tblRFQDetail rfqdt = new tblRFQDetail();
rfqdt.Description = detail.Description;
rfqdt.ItemId = detail.ItemId;
rfqdt.ManufacturedBy = detail.ManufacturedBy;
rfqdt.Price = detail.Price;
rfqdt.Qty = detail.Qty;
rfqdt.RfqId = rfq.RfqId;
rfqdt.SubTotal = detail.SubTotal;
rfqdt.TaxId = detail.TaxId;
rfqdt.UnitId = detail.UnitId;
rfqdt.isDeleted = false;
_rFQDtRepository.Add(rfqdt);
}
_unitOfWork.Complete();
return(true);
}
else
{
return(false);
}
}
catch (Exception e)
{
throw e;
}
}
public RFQVM GetRFQById(int id)
{
try
{
var item = _RFQRepository.GetById(id);
RFQVM rfq = new RFQVM();
rfq.BidValidUntil = item.BidValidUntil;
rfq.CompanyName = item.CompanyName;
rfq.createdByName = _EmpRepository.GetById(item.createdBy).FirstName;
rfq.CreatedDate = item.CreatedDate.Value.Date;
rfq.ModifiedByName = _EmpRepository.GetById((int)item.ModifiedBy).FirstName;
rfq.ModifiedDate = item.ModifiedDate.Value.Date;
rfq.DeliverTo = item.DeliverTo;
rfq.OrderDate = item.OrderDate;
rfq.RfqDate = item.RfqDate;
rfq.RfqId = item.RfqId;
rfq.RfqNo = item.RfqNo;
rfq.ScheduleDate = item.ScheduleDate;
rfq.SupplierId = item.SupplierId;
int[] suppIdArr = item.SupplierId.Split(',').Select(x => int.Parse(x)).ToArray();
foreach (int sid in suppIdArr)
{
rfq.SupplierName += _SuppRepository.GetById(sid).SupplierName + " ,";
}
rfq.SupplierName = rfq.SupplierName.TrimEnd(',');
rfq.hdnSupplierIds = item.SupplierId;
rfq.IsEmailSent = (bool)item.IsEmailSent;
rfq.TotalAmount = item.TotalAmount;
var detailsList = _rFQDtRepository.GetAll(x => x.RfqId == id).Select(x => new RFQDetailsVM
{
Description = x.Description,
ItemId = x.ItemId,
ItemName = _ItemRepository.GetById(x.ItemId).ItemName,
ManufacturedBy = x.ManufacturedBy,
Price = x.Price,
Qty = x.Qty,
RfqDetailsId = x.RfqDetailsId,
RfqId = x.RfqId,
SubTotal = x.SubTotal,
TaxId = x.TaxId,
TaxName = _TaxRespository.GetById(x.TaxId).TaxName,
UnitId = x.UnitId,
UnitName = _UnitRespsitory.GetById(x.UnitId).Unit
}).ToList();
rfq._RFQDetailsVMList = detailsList;
return(rfq);
}
catch (Exception e) { throw e; }
}
public IEnumerable <RFQVM> GetAllRFQ()
{
try
{
var RFQList = _RFQRepository.GetAll(x => x.isDeleted == false);
List <RFQVM> RFQVMList = new List <RFQVM>();
if (RFQList != null)
{
foreach (var item in RFQList)
{
RFQVM rfq = new RFQVM();
rfq.BidValidUntil = item.BidValidUntil;
rfq.CompanyName = item.CompanyName;
rfq.createdByName = _EmpRepository.GetById(item.createdBy).FirstName;
rfq.CreatedDate = item.CreatedDate.Value.Date;
rfq.ModifiedByName = _EmpRepository.GetById((int)item.ModifiedBy).FirstName;
rfq.ModifiedDate = item.ModifiedDate.Value.Date;
rfq.DeliverTo = item.DeliverTo;
rfq.OrderDate = item.OrderDate.Value.Date;
rfq.RfqDate = item.RfqDate.Value.Date;
rfq.RfqId = item.RfqId;
rfq.RfqNo = item.RfqNo;
rfq.ScheduleDate = item.ScheduleDate.Value.Date;
int[] sIdArr = item.SupplierId.Split(',').Select(x => int.Parse(x)).ToArray();
foreach (var sid in sIdArr)
{
rfq.SupplierName += _SuppRepository.GetById(sid).SupplierName + " ,";
}
rfq.SupplierName = rfq.SupplierName.TrimEnd(',');
rfq.SupplierId = item.SupplierId; // _SuppRepository.GetById(item.SupplierId);
rfq.IsEmailSent = (bool)item.IsEmailSent;
rfq.TotalAmount = item.TotalAmount;
RFQVMList.Add(rfq);
//---------------------------------------------------
//Array.ForEach(sIdArr, element =>rfq.SupplierName += _SuppRepository.GetById(element).SupplierName + " ,");
//rfq.SupplierName = rfq.SupplierName.TrimEnd(',');
}
}
return(RFQVMList);
}
catch (Exception e) { throw e; }
}
public ActionResult AddOrEditRFQ(int id = 0)
{
RFQVM rfqVM = new RFQVM();
RFQDetailsVM rfqdt = new RFQDetailsVM();
rfqVM._RFQDetailsVM = rfqdt;
ViewBag.supplierList = dropDown.DDLGetSuppliers();
//ViewBag.ItemList = DropDownLists.DDLGetItems();
ViewBag.UnitList = dropDown.DDLGetUnits();
ViewBag.TaxList = dropDown.DDLGetTax();
ViewBag.message = "";
if (id == 0)
{
return(PartialView(rfqVM));
}
else
{
return(PartialView(rfqVM));
}
}
public void ConvertIntoPDF(RFQVM rfq, string suppName, string suppCode, string strAttachment)
{
string strheader = "RFQ Details";
FileStream fs = new FileStream(strAttachment, FileMode.Create, FileAccess.Write, FileShare.None);
Document _document = new Document();
_document.SetPageSize(PageSize.A4);
PdfWriter _pdfWriter = PdfWriter.GetInstance(_document, fs);
_document.Open();
//pdf Header
BaseFont _basefontHead = BaseFont.CreateFont(BaseFont.TIMES_ROMAN, BaseFont.CP1252, BaseFont.NOT_EMBEDDED);
Font _fontHeader = new Font(_basefontHead, 16, 1, BaseColor.GRAY);
Paragraph _prgHeading = new Paragraph();
_prgHeading.Alignment = Element.ALIGN_CENTER;
_prgHeading.Add(new Chunk(strheader.ToUpper(), _fontHeader));
_document.Add(_prgHeading);
//Supplier Details
Paragraph _prgSupp = new Paragraph();
BaseFont _basefontSupp = BaseFont.CreateFont(BaseFont.TIMES_ROMAN, BaseFont.CP1252, BaseFont.NOT_EMBEDDED);
Font _fontSupp = new Font(_basefontSupp, 8, 1, BaseColor.DARK_GRAY);
_prgSupp.Alignment = Element.ALIGN_RIGHT;
_prgSupp.Add(new Chunk(" Supplier Name : " + suppName, _fontSupp));
_prgSupp.Add(new Chunk("\n Supplier Code : " + suppCode, _fontSupp));
_prgSupp.Add(new Chunk("\n Date : " + DateTime.Now.ToShortDateString(), _fontSupp));
_document.Add(_prgSupp);
//add line
Paragraph line = new Paragraph(new Chunk(new iTextSharp.text.pdf.draw.LineSeparator(0.0f, 100.0f, BaseColor.BLACK, Element.ALIGN_LEFT, -1)));
_document.Add(line);
_document.Add(new Chunk("\n", _fontHeader));
//Other Master Details
//Supplier Details
//Paragraph _prgMaster = new Paragraph();
//BaseFont _basefontMaster = BaseFont.CreateFont(BaseFont.TIMES_ROMAN, BaseFont.CP1252, BaseFont.NOT_EMBEDDED);
//Font _fontMaster = new Font(_basefontMaster, 8, 1, BaseColor.DARK_GRAY);
//_prgMaster.Alignment = Element.ALIGN_LEFT;
//_prgMaster.Add(new Chunk(" RFQ No. : " + rfq.RfqNo, _fontMaster));
//_prgMaster.Add(new Chunk("\n RFQ Date : " + rfq.RfqDate.Value.ToShortDateString(), _fontMaster));
//_prgMaster.Add(new Chunk("\n Order Date : " + rfq.OrderDate.Value.ToShortDateString(), _fontMaster));
//_prgMaster.Add(new Chunk("\n Company Name : " + rfq.CompanyName, _fontMaster));
//_prgMaster.Add(new Chunk("\n Deliver To : " + rfq.DeliverTo, _fontMaster));
//_prgMaster.Add(new Chunk("\n Schedule Date : " + rfq.ScheduleDate.Value.ToShortDateString(), _fontMaster));
//_prgMaster.Add(new Chunk("\n Bid Valid Until : " + rfq.BidValidUntil.Value.ToShortDateString(), _fontMaster));
//_prgMaster.Add(new Chunk("\n Total Amount : " + rfq.TotalAmount, _fontMaster));
//_document.Add(_prgMaster);
//_document.Add(new Chunk("\n", _fontMaster));
PdfPTable _MasterTable = new PdfPTable(2);
//table header
_MasterTable.WidthPercentage = 100;
PDFHelper.AddCellToBody(_MasterTable, "RFQ No.");
PDFHelper.AddCellToBody(_MasterTable, rfq.RfqNo);
PDFHelper.AddCellToBody(_MasterTable, "RFQ Date");
PDFHelper.AddCellToBody(_MasterTable, rfq.RfqDate.Value.ToShortDateString());
PDFHelper.AddCellToBody(_MasterTable, "Order Date");
PDFHelper.AddCellToBody(_MasterTable, rfq.OrderDate.Value.ToShortDateString());
PDFHelper.AddCellToBody(_MasterTable, "Company Name");
PDFHelper.AddCellToBody(_MasterTable, rfq.CompanyName);
PDFHelper.AddCellToBody(_MasterTable, "Deliver To");
PDFHelper.AddCellToBody(_MasterTable, rfq.DeliverTo);
PDFHelper.AddCellToBody(_MasterTable, "Schedule Date");
PDFHelper.AddCellToBody(_MasterTable, rfq.ScheduleDate.Value.ToShortDateString());
PDFHelper.AddCellToBody(_MasterTable, "Bid Valid Until");
PDFHelper.AddCellToBody(_MasterTable, rfq.BidValidUntil.Value.ToShortDateString());
PDFHelper.AddCellToBody(_MasterTable, "Total Amount");
PDFHelper.AddCellToBody(_MasterTable, rfq.TotalAmount.ToString());
_document.Add(_MasterTable);
_document.Add(new Chunk("\n", _fontHeader));
//List Details in table
PdfPTable _pdfTable = new PdfPTable(8);
//table header
_pdfTable.WidthPercentage = 100;
_pdfTable.HeaderRows = 1;
PDFHelper.AddCellToHeader(_pdfTable, "Item Name");
PDFHelper.AddCellToHeader(_pdfTable, "Description");
PDFHelper.AddCellToHeader(_pdfTable, "Manufactured By");
PDFHelper.AddCellToHeader(_pdfTable, "Qty");
PDFHelper.AddCellToHeader(_pdfTable, "Unit");
PDFHelper.AddCellToHeader(_pdfTable, "Price");
PDFHelper.AddCellToHeader(_pdfTable, "Tax");
PDFHelper.AddCellToHeader(_pdfTable, "Sub Total");
//table body
if (rfq._RFQDetailsVMList.Count > 0)
{
foreach (var item in rfq._RFQDetailsVMList)
{
PDFHelper.AddCellToBody(_pdfTable, item.ItemName);
PDFHelper.AddCellToBody(_pdfTable, item.Description);
PDFHelper.AddCellToBody(_pdfTable, item.ManufacturedBy);
PDFHelper.AddCellToBody(_pdfTable, item.Qty.ToString());
PDFHelper.AddCellToBody(_pdfTable, item.UnitName);
PDFHelper.AddCellToBody(_pdfTable, item.Price.ToString());
PDFHelper.AddCellToBody(_pdfTable, item.TaxName);
PDFHelper.AddCellToBody(_pdfTable, item.SubTotal.ToString());
}
}
_document.Add(new Chunk("\n Requirment Details", _fontHeader));
_document.Add(_pdfTable);
_document.Close();
_pdfWriter.Close();
fs.Close();
}//end of pdf