public VendorModel ValidateLoginCreds(VendorModel model)
{
VendorModel vendor = new VendorModel();
string[] UserCredentials = model.columnValues.Split(',');
string Id = UserCredentials[0].ToString();
string password = UserCredentials[1].ToString();
// PrincipalContext ctx = new PrincipalContext(ContextType.Domain);
using (VSCMEntities db = new VSCMEntities())
{
var person = (from p in vscm.RemoteVendorMasters
join e in vscm.RemoteVendorUserMasters
on p.Vendorid equals e.VendorId
where e.VuniqueId == Id && e.pwd == password
select new
{
e.Vuserid,
p.VendorName,
e.VuniqueId,
e.VendorId
}).ToList();
foreach (var p in person)
{
Console.WriteLine("{0} {1}", p.Vuserid, p.VendorName);
vendor.Vuserid = p.Vuserid;
vendor.UserName = p.VendorName;
vendor.VUniqueId = p.VuniqueId;
vendor.vendorId = p.VendorId;
}
}
return(vendor);
}
/*Name of Function : <<sendBGmail> Author :<<Prasanna>>
* Date of Creation <<16-01-2021>>
* Purpose : <<Sending mail to YIL members>>
* Review Date :<<>> Reviewed By :<<>>*/
public bool sendBGmail(int bgId)
{
try
{
VSCMEntities vscm = new VSCMEntities();
using (var db = new YSCMEntities()) //ok
{
var mpripaddress = ConfigurationManager.AppSettings["UI_IpAddress"];
mpripaddress = mpripaddress + "SCM/BGView/" + bgId + "";
var fromMail = ConfigurationManager.AppSettings["fromemail"];
RemoteBankGuarantee BGDeatils = vscm.RemoteBankGuarantees.Where(li => li.BGId == bgId).FirstOrDefault();
var mailData = (db.Employees.Where(li => li.EmployeeNo == BGDeatils.CreatedBy).FirstOrDefault <Employee>());
EmailSend emlSndngList = new EmailSend();
emlSndngList.Subject = "BG Submitted For PONo:" + BGDeatils.PONo + "; BGNo:" + BGDeatils.BGNo + " ";
emlSndngList.Body = "<html><head></head><body><div class='container'><p>Click below link to view details</p></div><br/><div><b style='color:#40bfbf;'>TO View Details: <a href='" + mpripaddress + "'>" + mpripaddress + "</a></b></div><br /><div><b style='color:#40bfbf;'></a></b><p style = 'margin-bottom:0px;' ><br/> Regards,</p><p> <b>" + BGDeatils.VendorName + "</b></p></body></html>";
emlSndngList.FrmEmailId = fromMail;
emlSndngList.ToEmailId = mailData.EMail + ",";
if (BGDeatils.BuyerManger != null)
{
emlSndngList.ToEmailId += (db.Employees.Where(li => li.EmployeeNo == BGDeatils.BuyerManger).FirstOrDefault <Employee>()).EMail;
}
if ((!string.IsNullOrEmpty(emlSndngList.FrmEmailId) && !string.IsNullOrEmpty(emlSndngList.FrmEmailId)) && (emlSndngList.FrmEmailId != "NULL" && emlSndngList.ToEmailId != "NULL"))
{
this.sendEmail(emlSndngList);
}
}
}
catch (Exception ex)
{
log.ErrorMessage("EmailTemplate", "sendASNCommunicationMail", ex.Message + "; " + ex.StackTrace.ToString());
}
return(true);
}
/*Name of Function : <<sendASNMailtoBuyer> Author :<<Prasanna>>
* Date of Creation <<27-11-2020>>
* Purpose : <<Sending mail method>>
* Review Date :<<>> Reviewed By :<<>>*/
public bool sendASNMailtoBuyer(int ASNId)
{
try
{
VSCMEntities vscm = new VSCMEntities();
var mpripaddress = ConfigurationManager.AppSettings["UI_IpAddress"];
mpripaddress = mpripaddress + "SCM/ASNView/" + ASNId + "";
using (var db = new YSCMEntities()) //ok
{
RemoteASNShipmentHeader ASNHeader = vscm.RemoteASNShipmentHeaders.Where(li => li.ASNId == ASNId).FirstOrDefault();
EmailSend emlSndngList = new EmailSend();
emlSndngList.FrmEmailId = ConfigurationManager.AppSettings["fromemail"];
emlSndngList.Subject = "ASNCreated";
emlSndngList.Body = "<html><head></head><body><div class='container'><p>Click below link to view details</p></div><br/><div><b style='color:#40bfbf;'>TO View Details: <a href='" + mpripaddress + "'>" + mpripaddress + "</a></b></div><br /><div><b style='color:#40bfbf;'></a></b></body></html>";
if (!string.IsNullOrEmpty(ConfigurationManager.AppSettings["ASNToEmail"]))
{
emlSndngList.ToEmailId = ConfigurationManager.AppSettings["ASNToEmail"];
}
if (!string.IsNullOrEmpty(ConfigurationManager.AppSettings["ASNCCEmail"]))
{
emlSndngList.CC = ConfigurationManager.AppSettings["ASNCCEmail"];
}
if ((!string.IsNullOrEmpty(emlSndngList.FrmEmailId) && !string.IsNullOrEmpty(emlSndngList.FrmEmailId)) && (emlSndngList.FrmEmailId != "NULL" && emlSndngList.ToEmailId != "NULL"))
{
this.sendEmail(emlSndngList);
}
}
}
catch (Exception ex)
{
log.ErrorMessage("EmailTemplate", "sendASNMailtoBuyer", ex.Message + "; " + ex.StackTrace.ToString());
}
return(true);
}
public bool sendCommunicationmailtoRequestor(int RFQRevisionId, string Remarks)
{
try
{
VSCMEntities yscmobj = new VSCMEntities();
var db = new YSCMEntities();
RemoteRFQRevisions_N rfqrevisiondetails = yscmobj.RemoteRFQRevisions_N.Where(li => li.rfqRevisionId == RFQRevisionId).FirstOrDefault <RemoteRFQRevisions_N>();
RemoteRFQMaster rfqmasterDetails = yscmobj.RemoteRFQMasters.Where(li => li.RfqMasterId == rfqrevisiondetails.rfqMasterId).FirstOrDefault <RemoteRFQMaster>();
var fromMail = ConfigurationManager.AppSettings["fromemail"];
var mpripaddress = ConfigurationManager.AppSettings["UI_IpAddress"];
mpripaddress = mpripaddress + "SCM/MPRForm/" + rfqmasterDetails.MPRRevisionId + "";
var rfqipaddress = ConfigurationManager.AppSettings["UI_IpAddress"];
rfqipaddress = rfqipaddress + "SCM/VendorQuoteView/" + rfqrevisiondetails.rfqRevisionId + "";
EmailSend emlSndngList = new EmailSend();
emlSndngList.Body = "<html><head></head><body><div class='container'><p>Comments by Vendor</p></div><br/>" + Remarks + " <br/><br/></div><b style='color:#40bfbf;'>TO View MPR: <a href='" + mpripaddress + "'>" + mpripaddress + "</a></b></div><br /><br/><div><b style='color:#40bfbf;'>TO View RFQ: <a href='" + rfqipaddress + "'>" + rfqipaddress + "</a></b></body></html>";
Employee Email = db.Employees.Where(li => li.EmployeeNo == rfqrevisiondetails.BuyergroupEmail).FirstOrDefault <Employee>();
emlSndngList.Subject = "Communication From Vendor on RFQNumber: " + rfqmasterDetails.RFQNo; // + mprrevisionDetail.RemoteRFQMaster.RFQNo;
emlSndngList.FrmEmailId = fromMail;
var toEMail = Convert.ToString(rfqrevisiondetails.CreatedBy);
emlSndngList.ToEmailId = (db.Employees.Where(li => li.EmployeeNo == toEMail).FirstOrDefault <Employee>()).EMail;
emlSndngList.CC = (db.Employees.Where(li => li.EmployeeNo == rfqrevisiondetails.BuyergroupEmail).FirstOrDefault <Employee>()).EMail;
if ((!string.IsNullOrEmpty(emlSndngList.FrmEmailId) && !string.IsNullOrEmpty(emlSndngList.FrmEmailId)) && (emlSndngList.FrmEmailId != "NULL" && emlSndngList.ToEmailId != "NULL"))
{
this.sendEmail(emlSndngList);
}
}
catch (Exception ex)
{
log.ErrorMessage("EmailTemplate", "sendmailtoRequestor", ex.Message + "; " + ex.StackTrace.ToString());
}
return(true);
}
public IHttpActionResult BGAutoReminderForVendor()
{
YSCMEntities db = new YSCMEntities();
VSCMEntities vscm = new VSCMEntities();
var bgList = db.BankGuarantees.Where(li => li.BGExpiryDate != null && (li.BGStatus == "Verified" || li.BGStatus == "Expired")).ToList();
foreach (var item in bgList)
{
//if bg expiry date- one month == current date && bg expiry date & warranty Expirydate difference should be greater than 6 months
DateTime bgExpiryDate = Convert.ToDateTime(item.BGExpiryDate);
DateTime WarrantyExpiryDate = Convert.ToDateTime(item.WarrantyExpiryDate);
var autoDate = bgExpiryDate.AddMonths(-1).ToShortDateString();
var currentDate = DateTime.Now.ToShortDateString();
var months = (WarrantyExpiryDate.Month - bgExpiryDate.Month) + 12 * (WarrantyExpiryDate.Year - bgExpiryDate.Year);
if (autoDate == currentDate && months > 1)
{
if (item.BGId != null)
{
var RemoteBankGuarantee = vscm.RemoteBankGuarantees.Where(li => li.BGId == item.BGId).FirstOrDefault();
RemoteBankGuarantee.IsBGRevised = false;
vscm.SaveChanges();
}
//local
var LocalBG = db.BankGuarantees.Where(li => li.BGId == item.BGId).FirstOrDefault();
if (LocalBG != null)
{
LocalBG.IsBGRevised = false;
db.SaveChanges();
}
var Remarks = "Your BG is Expiring Soon, Please Re submit the revised BG for BG No: " + item.BGNo + "; PO No:" + item.PONo + " ";
this.emailTemplateDA.sendBGInitiationmail(item.BGId, item.CreatedBy, Remarks, "ReSubmit");
}
//BG Expired when vendor not submit documents
int cmp = bgExpiryDate.AddDays(1).CompareTo(DateTime.Now); // if cmp value < 0 means bgexpiry date is less than current date, current date is greater means bgExpiryDate is comes after current date
if (item.IsBGRevised == false && cmp < 0 && item.BGStatus != "Expired")
{
//update BG status track status track
BGStatusTrack bgst = new BGStatusTrack();
bgst.BGId = item.BGId;
bgst.Status = "Expired";
bgst.UpdatedBy = item.CreatedBy;
this._mprBusenessAcess.updateBGStatus(bgst);
}
if (WarrantyExpiryDate.ToShortDateString() == currentDate && item.BGStatus != "Closed")
{
//update BG status track status track
BGStatusTrack bgst = new BGStatusTrack();
bgst.BGId = item.BGId;
bgst.Status = "Closed";
bgst.UpdatedBy = item.CreatedBy;
this._mprBusenessAcess.updateBGStatus(bgst);
}
}
return(Ok(true));
}
public void ErrorMessage(string controllername, string methodname, string exception)
{
exception = exception.Replace("'", String.Empty);
VSCMEntities DB = new VSCMEntities();
string query = "insert into dbo.RemoteApiErrorLog(ControllerName,MethodName,ExceptionMsg,OccuredDate,URL)values('" + controllername + "', '" + methodname + "', '" + exception + "','" + DateTime.Now + "','" + HttpContext.Current.Request.Url + "')";
SqlConnection con = new SqlConnection(DB.Database.Connection.ConnectionString);
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
//this.emailTemplateDA.sendErrorLogEmail(controllername, methodname, exception, HttpContext.Current.Request.Url);
}
/*Name of Function : <<Technical clearance mail to CMM>> Author :<<Prasanna>>
* Date of Creation <<09-10-2020>>
* Purpose : <<Sending mail method>>
* Review Date :<<>> Reviewed By :<<>>*/
public bool sendSatustoRequestor(int RFQRevisionId, string StatusTxt, string Remarks)
{
try
{
VSCMEntities yscmobj = new VSCMEntities();
var db = new YSCMEntities();
RemoteRFQRevisions_N rfqrevisiondetails = yscmobj.RemoteRFQRevisions_N.Where(li => li.rfqRevisionId == RFQRevisionId).FirstOrDefault <RemoteRFQRevisions_N>();
RemoteRFQMaster rfqmasterDetails = yscmobj.RemoteRFQMasters.Where(li => li.RfqMasterId == rfqrevisiondetails.rfqMasterId).FirstOrDefault <RemoteRFQMaster>();
RemoteVendorMaster vendor = yscmobj.RemoteVendorMasters.Where(li => li.Vendorid == rfqmasterDetails.VendorId).FirstOrDefault();
var fromMail = ConfigurationManager.AppSettings["fromemail"];
var mpripaddress = ConfigurationManager.AppSettings["UI_IpAddress"];
mpripaddress = mpripaddress + "SCM/MPRForm/" + rfqmasterDetails.MPRRevisionId + "";
var rfqipaddress = ConfigurationManager.AppSettings["UI_IpAddress"];
rfqipaddress = rfqipaddress + "SCM/VendorQuoteView/" + rfqrevisiondetails.rfqRevisionId + "";
var requestionId = db.MPRRevisions.Where(li => li.RevisionId == rfqmasterDetails.MPRRevisionId).FirstOrDefault().RequisitionId;
var mprDocNo = db.MPRDetails.Where(li => li.RequisitionId == requestionId).FirstOrDefault().DocumentNo;
EmailSend emlSndngList = new EmailSend();
emlSndngList.Subject = "Vendor " + StatusTxt + " to RFQNumber: " + rfqmasterDetails.RFQNo + " for " + mprDocNo; // + mprrevisionDetail.RemoteRFQMaster.RFQNo;
emlSndngList.Body = "<html><meta charset=\"ISO-8859-1\"><head><link rel ='stylesheet' href ='https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css'></head><body><div class='container'><p>Dear Sir,</p><p>" + Remarks + "</p><br/><div><b style='color:#40bfbf;'>TO View MPR: <a href='" + mpripaddress + "'>" + mpripaddress + "</a></b></div><br /><div><b style='color:#40bfbf;'>TO View RFQ: <a href='" + rfqipaddress + "'>" + rfqipaddress + "</a></b><p style = 'margin-bottom:0px;' ><br/> Regards,</p><p> <b>" + vendor.VendorName + " - " + vendor.VendorCode + "</b></p></div></body></html>";
Employee Email = db.Employees.Where(li => li.EmployeeNo == rfqrevisiondetails.BuyergroupEmail).FirstOrDefault <Employee>();
emlSndngList.FrmEmailId = fromMail;
var toEMail = Convert.ToString(rfqrevisiondetails.CreatedBy);
emlSndngList.ToEmailId = (db.Employees.Where(li => li.EmployeeNo == toEMail).FirstOrDefault <Employee>()).EMail;
emlSndngList.CC = (db.Employees.Where(li => li.EmployeeNo == rfqrevisiondetails.BuyergroupEmail).FirstOrDefault <Employee>()).EMail;
if ((!string.IsNullOrEmpty(emlSndngList.FrmEmailId) && !string.IsNullOrEmpty(emlSndngList.FrmEmailId)) && (emlSndngList.FrmEmailId != "NULL" && emlSndngList.ToEmailId != "NULL"))
{
this.sendEmail(emlSndngList);
}
}
catch (Exception ex)
{
log.ErrorMessage("EmailTemplate", "sendSatustoRequestor", ex.Message + "; " + ex.StackTrace.ToString());
}
return(true);
}
/*Name of Function : <<Technical clearance mail to CMM>> Author :<<Prasanna>>
* Date of Creation <<09-10-2020>>
* Purpose : <<Sending mail method>>
* Review Date :<<>> Reviewed By :<<>>*/
public bool sendTechNotificationMail(int RFQRevisionId)
{
try
{
VSCMEntities yscmobj = new VSCMEntities();
var db = new YSCMEntities();
RemoteRFQRevisions_N rfqrevisiondetails = yscmobj.RemoteRFQRevisions_N.Where(li => li.rfqRevisionId == RFQRevisionId).FirstOrDefault <RemoteRFQRevisions_N>();
RemoteRFQMaster rfqmasterDetails = yscmobj.RemoteRFQMasters.Where(li => li.RfqMasterId == rfqrevisiondetails.rfqMasterId).FirstOrDefault <RemoteRFQMaster>();
RemoteVendorMaster vendor = yscmobj.RemoteVendorMasters.Where(li => li.Vendorid == rfqmasterDetails.VendorId).FirstOrDefault();
MPRRevision mprrevisionDetails = db.MPRRevisions.Where(li => li.RevisionId == rfqmasterDetails.MPRRevisionId && li.BoolValidRevision == true).FirstOrDefault();
var mprDocNo = db.MPRDetails.Where(li => li.RequisitionId == mprrevisionDetails.RequisitionId).FirstOrDefault().DocumentNo;
List <MPRIncharge> mprincharges = new List <MPRIncharge>();
if (mprrevisionDetails != null)
{
mprincharges = db.MPRIncharges.Where(li => li.RevisionId == mprrevisionDetails.RevisionId && li.RequisitionId == mprrevisionDetails.RequisitionId && li.CanClearTechnically == true).ToList();
}
var fromMail = ConfigurationManager.AppSettings["fromemail"];
var mpripaddress = ConfigurationManager.AppSettings["UI_IpAddress"];
mpripaddress = mpripaddress + "SCM/MPRForm/" + rfqmasterDetails.MPRRevisionId + "";
var rfqipaddress = ConfigurationManager.AppSettings["UI_IpAddress"];
rfqipaddress = rfqipaddress + "SCM/VendorQuoteView/" + rfqrevisiondetails.rfqRevisionId + "";
EmailSend emlSndngList = new EmailSend();
emlSndngList.Subject = "Vendor Responded to RFQNumber: " + rfqmasterDetails.RFQNo + " for " + mprDocNo; // + mprrevisionDetail.RemoteRFQMaster.RFQNo;
emlSndngList.Body = "<html><meta charset=\"ISO-8859-1\"><head><link rel ='stylesheet' href ='https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css'></head><body><div class='container'><p>Dear Sir,</p><p>Vendor has reponded with technical documents. Plese review and confirm the documents</p><br/><div><b style='color:#40bfbf;'>TO View MPR: <a href='" + mpripaddress + "'>" + mpripaddress + "</a></b></div><br /><div><b style='color:#40bfbf;'>TO View RFQ: <a href='" + rfqipaddress + "'>" + rfqipaddress + "</a></b><p style = 'margin-bottom:0px;' ><br/> Regards,</p><p> <b>" + vendor.VendorName + " - " + vendor.VendorCode + "</b></p></div></body></html>";
emlSndngList.FrmEmailId = fromMail;
//To Emails
string ToEmails = "";
if (mprrevisionDetails != null)
{
ToEmails = (db.Employees.Where(li => li.EmployeeNo == mprrevisionDetails.CheckedBy).FirstOrDefault <Employee>()).EMail;
ToEmails += "," + (db.Employees.Where(li => li.EmployeeNo == mprrevisionDetails.ApprovedBy).FirstOrDefault <Employee>()).EMail;
}
if (mprincharges.Count() > 0)
{
foreach (var item in mprincharges)
{
ToEmails += "," + (db.Employees.Where(li => li.EmployeeNo == item.Incharge).FirstOrDefault <Employee>()).EMail;
}
}
emlSndngList.ToEmailId = ToEmails;
//CC Mails
var CC1 = Convert.ToString(rfqrevisiondetails.CreatedBy);
string CCEmails = (db.Employees.Where(li => li.EmployeeNo == CC1).FirstOrDefault <Employee>()).EMail;
if (!string.IsNullOrEmpty(rfqrevisiondetails.BuyergroupEmail))
{
CCEmails += "," + (db.Employees.Where(li => li.EmployeeNo == rfqrevisiondetails.BuyergroupEmail).FirstOrDefault <Employee>()).EMail;
}
emlSndngList.CC = CCEmails;
if ((!string.IsNullOrEmpty(emlSndngList.FrmEmailId) && !string.IsNullOrEmpty(emlSndngList.FrmEmailId)) && (emlSndngList.FrmEmailId != "NULL" && emlSndngList.ToEmailId != "NULL"))
{
this.sendEmail(emlSndngList);
}
}
catch (Exception ex)
{
log.ErrorMessage("EmailTemplate", "sendTechNotificationMail", ex.Message + "; " + ex.StackTrace.ToString());
}
return(true);
}
