public IHttpActionResult uploadExcel()
{
var paid = "";
int documentid = 0;
var httpRequest = HttpContext.Current.Request;
var serverPath = HttpContext.Current.Server.MapPath("~/PADocuments");
string parsedFileName = "";
string filename = "";
if (httpRequest.Files.Count > 0)
{
paid = httpRequest.Files.AllKeys[0];
//string employeeno = httpRequest.Files.AllKeys[1];
var postedFile = httpRequest.Files[0];
parsedFileName = string.Format(DateTime.Now.Year.ToString() + "\\" + DateTime.Now.ToString("MMM") + "\\" + paid + "\\" + ToValidFileName(postedFile.FileName));
serverPath = serverPath + string.Format("\\" + DateTime.Now.Year.ToString() + "\\" + DateTime.Now.ToString("MMM")) + "\\" + paid;
var filePath = Path.Combine(serverPath, ToValidFileName(postedFile.FileName));
if (!Directory.Exists(serverPath))
{
Directory.CreateDirectory(serverPath);
}
postedFile.SaveAs(filePath);
try
{
YSCMEntities entities = new YSCMEntities();
var data = new MPRPADocument();
data.Filename = postedFile.FileName;
data.Filepath = parsedFileName;
data.uploadeddate = System.DateTime.Now;
data.paid = Convert.ToInt32(paid);
data.deleteflag = false;
entities.MPRPADocuments.Add(data);
entities.SaveChanges();
documentid = data.DocumentId;
filename = data.Filename;
//entities.MPRPADocuments.Add(new MPRPADocument
//{
// Filename = postedFile.FileName,
// Filepath = parsedFileName,
// uploadeddate = System.DateTime.Now,
// paid = Convert.ToInt32(paid)
//});
//entities.SaveChanges();
// int succRecs = iSucceRows;
}
catch (Exception e)
{
throw e;
}
//for (int i = 0; i < httpRequest.Files.Count; i++)
//{
//}
}
return(Ok(filename));
}
public List <GroupAccessNameModel> getAllAccessNameData()
{
using (var _context = new YSCMEntities())
{
try
{
var result = from an in _context.AccessNames
join agm in _context.AccessGroupMasters on an.AccessGroupId equals agm.AccessGroupId
where an.DeleteFlag == false && agm.DeleteFlag == false
orderby an.AccessGroupId ascending
select new GroupAccessNameModel()
{
AccessNameID = an.AccessNameID,
AccessName = an.AccessName1,
AccessGroupId = an.AccessGroupId,
AccessGroupMaster = new GroupMasterDomainModel()
{
GroupName = agm.GroupName,
AccessGroupId = agm.AccessGroupId
},
AuthorizationItems = new AuthorizationItemsModel()
{
RoleId = 0,
DeleteFlag = false,
}
};
return(result.ToList());
}
catch (Exception ex)
{
throw ex;
}
}
}
public async Task <string> AddNewGroupMaster(GroupMasterDomainModel model)
{
using (var _context = new YSCMEntities())
{
try
{
if (model.GroupName != "")
{
var some1 = _context.AccessGroupMasters.Where(x => model.GroupName.Contains(x.GroupName) && x.DeleteFlag == false).ToList();
if (some1.Count == 0)
{
_context.AccessGroupMasters.Add(new AccessGroupMaster
{
GroupName = model.GroupName,
UpdatedBy = model.UpdatedBy,
UpdatedDate = model.UpdatedDate
});
await _context.SaveChangesAsync();
}
else
{
return("Group Name Exist Please try with other Group Name");
}
return("Data save sucessfully");
}
else
{
return("Can't save null data");
}
}
catch (Exception ex)
{ throw ex; }
}
}
public DataSet GetmprstatusReport(ReportInputModel model)
{
DataSet ds = new DataSet();
SqlParameter[] Param = new SqlParameter[5];
string data = "";
YSCMEntities obj = new YSCMEntities();
if (model.OrgDepartmentId != 0)
{
List <int> departments = obj.MPRDepartments.Where(x => x.ORgDepartmentid == model.OrgDepartmentId).Select(x => (int)x.DepartmentId).ToList();
data = string.Join(" , ", departments);
}
if (model.BuyerGroupId == 0)
{
Param[0] = new SqlParameter("buyergroupid", SqlDbType.VarChar);
Param[0].Value = DBNull.Value;
Param[1] = new SqlParameter("@fromdate", model.Fromdate);
Param[2] = new SqlParameter("@todate", model.Todate);
Param[3] = new SqlParameter("@DepartmentId", data);
Param[4] = new SqlParameter("@issuepurpose", model.Issuepurposeid);
}
else
{
//string region = (string.Join(",", model.multiregion.Select(x => x.Region.ToString()).ToArray()));
Param[0] = new SqlParameter("@BuyerGroupId", model.BuyerGroupId);
Param[1] = new SqlParameter("@fromdate", model.Fromdate);
Param[2] = new SqlParameter("@todate", model.Todate);
Param[3] = new SqlParameter("@DepartmentId", data);
Param[4] = new SqlParameter("@issuepurpose", model.Issuepurposeid);
}
ds = _paBusenessAcess.GetmprstatusReport("newmprstatuareport", Param);
return(ds);
}
public async Task <string> AddRoleAccess(AddRoleDomainModel model)
{
using (var _context = new YSCMEntities())
{
try
{
if (model.RoleName != "")
{
var some1 = _context.AutorizationGroups.Where(x => model.RoleName.Contains(x.RoleName)).ToList();
if (some1.Count == 0)
{
_context.AutorizationGroups.Add(new AutorizationGroup
{
RoleName = model.RoleName,
UpdatedBy = model.UpdatedBy,
updatedDate = model.updatedDate
});
await _context.SaveChangesAsync();
}
else
{
return("Role Name Exist Please try with other Role Name");
}
return("Data save sucessfully");
}
else
{
return("Can't save null data");
}
}
catch (Exception ex)
{ throw ex; }
}
}
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);
}
/*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 sendMailtoBuyer(int VendorId)
{
try
{
using (var db = new YSCMEntities()) //ok
{
var mpripaddress = ConfigurationManager.AppSettings["UI_IpAddress"];
mpripaddress = mpripaddress + "SCM/VendorRegInitiate/" + VendorId + "";
var fromMail = ConfigurationManager.AppSettings["fromemail"];
VendorRegApprovalProcess vendorProcessDetails = db.VendorRegApprovalProcesses.Where(li => li.Vendorid == VendorId).FirstOrDefault();
EmailSend emlSndngList = new EmailSend();
emlSndngList.Subject = "Vendor Registration response";
emlSndngList.Body = "<html><head></head><body><div class='container'><p>Comments by Vendor</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>";
emlSndngList.FrmEmailId = fromMail;
emlSndngList.ToEmailId = (db.Employees.Where(li => li.EmployeeNo == vendorProcessDetails.IntiatedBy).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", "sendMailtoBuyer", ex.Message + "; " + ex.StackTrace.ToString());
}
return(true);
}
//Delete AccessName on delete Click
public async Task <string> DeleteAccessName(DeleteAccessNameDomainModel model)
{
using (var _context = new YSCMEntities())
{
try
{
var obj = _context.AccessNames.Where(e => e.AccessNameID == model.AccessNameID).FirstOrDefault <AccessName>();
if (obj != null)
{
//obj.AccessName = model.AccessName;
obj.DeletedBy = model.DeletedBy;
obj.DeleteFlag = true;
obj.DeletedDate = DateTime.Now;
await _context.SaveChangesAsync();
}
else
{
return("No Record Found");
}
return("Data Updated Successfully");
}
catch (Exception ex)
{ throw ex; }
}
}
/*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);
}
public async Task <string> AddNewAccessName(GroupAccessNameModel model)
{
using (var _context = new YSCMEntities())
{
try
{
if (model.AccessName != "")
{
var some1 = _context.AccessNames.Where(x => model.AccessName.Contains(x.AccessName1) && x.DeleteFlag == false).ToList();
if (some1.Count == 0)
{
_context.AccessNames.Add(new AccessName
{
AccessName1 = model.AccessName,
AccessGroupId = model.AccessGroupId,
updatedBy = model.updatedBy,
updatedDate = DateTime.Now
});
await _context.SaveChangesAsync();
}
else
{
return("Access Name Exist Please try with other Access Name");
}
return("Data save sucessfully");
}
else
{
return("Can't save null data");
}
}
catch (Exception ex)
{ throw ex; }
}
}
public async Task <string> UpdateGroupMaster(UpdateGroupMasterDomainModel model)
{
using (var _context = new YSCMEntities())
{
try
{
var existingGroup = _context.AccessGroupMasters.Where(e => e.AccessGroupId == model.AccessGroupId).FirstOrDefault <AccessGroupMaster>();
if (existingGroup != null)
{
existingGroup.UpdatedBy = "190455";
existingGroup.UpdatedDate = DateTime.Now;
existingGroup.GroupName = model.GroupName;
await _context.SaveChangesAsync();
}
else
{
return("No Record Found");
}
return("Data Updated Successfully");
}
catch (Exception ex)
{ throw ex; }
}
}
//Update AuthRole
public async Task <string> UpdateAuthRole(UpdateAuthGroupDomainModel model)
{
using (var _context = new YSCMEntities())
{
try
{
var existingGroup = _context.AutorizationGroups.Where(e => e.RoleId == model.RoleId).FirstOrDefault <AutorizationGroup>();
if (existingGroup != null)
{
existingGroup.RoleName = model.RoleName;
existingGroup.UpdatedBy = "190455";
existingGroup.updatedDate = DateTime.Now;
await _context.SaveChangesAsync();
}
else
{
return("No Record Found");
}
return("Data Updated Successfully");
}
catch (Exception ex)
{ throw ex; }
}
}
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);
YSCMEntities DB = new YSCMEntities();
string query = "insert into dbo.ApiErrorLog(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();
}
public string AddAccessRole(checkboxSelect selectCheckbox)
{
using (var _context = new YSCMEntities())
{
try
{
if (selectCheckbox.uncheckResult != null)
{
var some1 = _context.AuthorizationItems.Where(x => selectCheckbox.uncheckResult.Contains(x.AccessNamesId)).ToList();
if (some1 != null)
{
foreach (var data1 in some1)
{
//AccessNamesId = data2.AccessNameID,
//RoleId = roleid,
data1.DeletedBy = "190455";
data1.Deleteddate = DateTime.Now;
data1.DeleteFlag = true;
_context.SaveChanges();
}
}
}
if (selectCheckbox.resultText != null)
{
var some = _context.AuthorizationItems.Where(x => selectCheckbox.resultText.Contains(x.AccessNamesId)).ToList();
if (some != null)
{
foreach (var data2 in selectCheckbox.resultText)
{
_context.AuthorizationItems.Add(new AuthorizationItem
{
AccessNamesId = data2,
RoleId = selectCheckbox.roleId,
UpdatedBy = "190455",
Updateddate = DateTime.Now,
DeleteFlag = false
});
_context.SaveChanges();
}
}
}
//some.ForEach(a => a.AccessNameStatus = true);
return("Data save sucessfully");
}
catch (Exception ex)
{ throw ex; }
}
}
public DataSet GetMprstatuswisereport(ReportInputModel model)
{
DataSet ds = new DataSet();
SqlParameter[] Param = new SqlParameter[7];
string data = "";
YSCMEntities obj = new YSCMEntities();
if (model.DepartmentId == 0)
{
List <int> departments = obj.MPRDepartments.Where(x => x.ORgDepartmentid == model.OrgDepartmentId).Select(x => (int)x.DepartmentId).ToList();
data = string.Join(" , ", departments);
}
else
{
data = string.Join(",", model.DepartmentId);
}
if (model.BuyerGroupId == 0)
{
Param[0] = new SqlParameter("buyergroupid", SqlDbType.VarChar);
Param[0].Value = DBNull.Value;
Param[1] = new SqlParameter("@fromdate", model.Fromdate);
Param[2] = new SqlParameter("@todate", model.Todate);
Param[3] = new SqlParameter("@ProjectManager", model.ProjectManager);
Param[4] = new SqlParameter("@SaleOrderNo", model.SaleOrderNo);
Param[5] = new SqlParameter("@Departmentid", data);
Param[6] = new SqlParameter("@JobCode", model.jobcode);
}
else
{
//string region = (string.Join(",", model.multiregion.Select(x => x.Region.ToString()).ToArray()));
Param[0] = new SqlParameter("@BuyerGroupId", model.BuyerGroupId);
Param[1] = new SqlParameter("@fromdate", model.Fromdate);
Param[2] = new SqlParameter("@todate", model.Todate);
Param[3] = new SqlParameter("@ProjectManager", model.ProjectManager);
Param[4] = new SqlParameter("@SaleOrderNo", model.SaleOrderNo);
Param[5] = new SqlParameter("@Departmentid", data);
Param[6] = new SqlParameter("@JobCode", model.jobcode);
}
ds = _paBusenessAcess.GetMprstatuswisereport("Mprwisereport", Param);
return(ds);
}
public List <GroupMasterDomainModel> getGroupMasterDetail()
{
using (var _context = new YSCMEntities())
{
try
{
var result = from accs in _context.AccessGroupMasters
where accs.DeleteFlag == false
select new GroupMasterDomainModel()
{
GroupName = accs.GroupName,
AccessGroupId = accs.AccessGroupId
};
return(result.ToList());
}
catch (Exception ex)
{ throw ex; }
}
}
public List <AutorizationGroupModel> getAllRoleName()
{
using (var _context = new YSCMEntities())
{
try
{
var result = from ag in _context.AutorizationGroups
where ag.DeleteFlag == false
select new AutorizationGroupModel()
{
RoleName = ag.RoleName,
RoleId = ag.RoleId
};
return(result.ToList());
}
catch (Exception ex)
{ throw ex; }
}
}
/*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);
}
public async Task <string> DeleteGroupAccess(DeleteGroupAccessDomainModel model)
{
using (var _context = new YSCMEntities())
{
try
{
var res = _context.AccessNames.Where(e => e.AccessName1 == model.AccessName).FirstOrDefault <AccessName>();
if (res != null)
{
res.DeleteFlag = true;
await _context.SaveChangesAsync();
}
else
{
return("No Record Found");
}
return("Data Updated SuccessFully");
}
catch (Exception ex)
{ throw ex; }
}
}
//Add access to authitem tbl
public async Task <string> AddAccess(AddAccessDomainModel model)
{
using (var _context = new YSCMEntities())
{
try
{
_context.AuthorizationItems.Add(new AuthorizationItem
{
AccessNamesId = model.AccessNameID,
RoleId = model.RoleId,
UpdatedBy = model.UpdatedBy,
Updateddate = model.updatedDate,
DeleteFlag = model.DeleteFlag
});
await _context.SaveChangesAsync();
return("Data save sucessfully");
}
catch (Exception ex)
{ throw ex; }
}
}
public List <AuthorizationItemsModel> getAuthorizationItemDetailById(int roleid)
{
using (var _context = new YSCMEntities())
{
try
{
var result = from auth in _context.AuthorizationItems
where auth.DeleteFlag == false && auth.RoleId == roleid
select new AuthorizationItemsModel()
{
RoleAccessNameid = auth.RoleAccessNameid,
RoleId = auth.RoleId,
AccessNamesId = auth.AccessNamesId,
DeleteFlag = auth.DeleteFlag
};
return(result.ToList());
}
catch (Exception ex)
{ throw ex; }
}
}
public List <GetAllNameModel> getAllGroupById(int roleId)
{
using (var _context = new YSCMEntities())
{
try
{
var result = from agm in _context.AccessGroupMasters
join an in _context.AccessNames on agm.AccessGroupId equals an.AccessGroupId
join ai in _context.AuthorizationItems on an.AccessNameID equals ai.AccessNamesId
into temp from NetTcpStyleUriParser in temp.DefaultIfEmpty()
join ag in _context.AutorizationGroups on NetTcpStyleUriParser.RoleId equals ag.RoleId
where ag.RoleId == roleId && ag.DeleteFlag == false
select new GetAllNameModel()
{
GroupName = agm.GroupName,
//AccessViewModel = new GroupAccessNameModel
//{
AccessNamesId = an.AccessNameID,
AccessGroupId = an.AccessGroupId,
AccessName = an.AccessName1,
// AccessNameStatus = an.AccessNameStatus
//}
};
// };
return(result.Distinct()
.ToList());
}
catch (Exception ex)
{
throw ex;
}
}
}
public List <GroupAccessNameModel> getGroupAccessNameById(int accessGroupId)
{
using (var _context = new YSCMEntities())
{
try
{
var result = from an in _context.AccessNames
join agm in _context.AccessGroupMasters on an.AccessGroupId equals agm.AccessGroupId
join auth in _context.AuthorizationItems on an.AccessNameID equals auth.AccessNamesId
where an.AccessGroupId == accessGroupId && an.DeleteFlag == false
select new GroupAccessNameModel()
{
AccessNameID = an.AccessNameID,
AccessName = an.AccessName1,
AccessGroupId = an.AccessGroupId,
AccessGroupMaster = new GroupMasterDomainModel()
{
GroupName = agm.GroupName,
AccessGroupId = agm.AccessGroupId
},
AuthorizationItems = new AuthorizationItemsModel()
{
RoleId = auth.RoleId,
AccessNamesId = auth.AccessNamesId,
DeleteFlag = auth.DeleteFlag
}
};
return(result.ToList());
}
catch (Exception ex)
{
throw ex;
}
}
}
//Get all accessname by roleid for view access page
public List <GroupAccessNameModel> getAccessNameRoleId(int roleid)
{
using (var _context = new YSCMEntities())
{
try
{
var result = from an in _context.AccessNames
join agr in _context.AccessGroupMasters on an.AccessGroupId equals agr.AccessGroupId
join ai in _context.AuthorizationItems on an.AccessNameID equals ai.AccessNamesId
where ai.RoleId == roleid && ai.DeleteFlag == false
select new GroupAccessNameModel()
{
AccessNameID = an.AccessNameID,
AccessName = an.AccessName1,
AccessGroupId = an.AccessGroupId,
AccessGroupMaster = new GroupMasterDomainModel()
{
GroupName = agr.GroupName,
AccessGroupId = agr.AccessGroupId
},
AuthorizationItems = new AuthorizationItemsModel()
{
RoleId = ai.RoleId,
AccessNamesId = ai.AccessNamesId,
DeleteFlag = ai.DeleteFlag
}
};
//grpAcsModel.Add(result.ToList());
return(result.ToList());
}
catch (Exception ex)
{
throw ex;
}
}
}
//Delete AuthRole
public async Task <string> DeleteAuthRole(DeleteAuthGroupDomainModel model)
{
using (var _context = new YSCMEntities())
{
try
{
var res = _context.AutorizationGroups.Where(e => e.RoleId == model.RoleId).FirstOrDefault <AutorizationGroup>();
if (res != null)
{
res.DeleteFlag = true;
res.DeletedDate = DateTime.Now;
res.DeletedBy = model.DeletedBy;
await _context.SaveChangesAsync();
}
else
{
return("No Record Found");
}
return("Data Updated SuccessFully");
}
catch (Exception ex)
{ throw ex; }
}
}
public async Task <string> DeleteGroupMaster(DeleteGroupMasterDomainModel model)
{
using (var _context = new YSCMEntities())
{
try
{
var res = _context.AccessGroupMasters.Where(e => e.GroupName == model.GroupName).FirstOrDefault <AccessGroupMaster>();
if (res != null)
{
res.DeleteFlag = true;
res.DeleteDate = DateTime.Now;
res.DeletedBy = "190455";
await _context.SaveChangesAsync();
}
else
{
return("No Record Found");
}
return("Data Updated SuccessFully");
}
catch (Exception ex)
{ throw ex; }
}
}
//Update access to authitem tbl
//public string UpdateAccess(AuthorizationItemsModel model)
//{
// using (var _context = new YSCMEntities())
// {
// try
// {
// var some = _context.AuthorizationItems.Where(x => model.Contains(x.AccessNamesId)).ToList();
// some.ForEach(a => a.DeleteFlag = true);
// _context.SaveChanges();
// return "Data save sucessfully";
// }
// catch (Exception ex)
// { throw ex; }
// }
//}
public async Task <string> UpdateAccess(AuthorizationItemsModel model)
{
using (var _context = new YSCMEntities())
{
try
{
var obj = _context.AuthorizationItems.Where(e => e.AccessNamesId == model.AccessNamesId).FirstOrDefault <AuthorizationItem>();
if (obj != null)
{
obj.DeleteFlag = model.DeleteFlag;
await _context.SaveChangesAsync();
}
else
{
return("No Record Found");
}
return("Data Updated Successfully");
}
catch (Exception ex)
{ throw ex; }
}
}
/*Name of Function : <<getAsnList>> Author :<<Prasanna>>
* Date of Creation <<07-12-2020>>
* Purpose : <<function is used to get getAsnList>>
* Review Date :<<>> Reviewed By :<<>>*/
public List <ASNShipmentHeader> getAsnList(ASNfilters ASNfilters)
{
List <ASNShipmentHeader> asnList = new List <ASNShipmentHeader>();
try
{
using (YSCMEntities Context = new YSCMEntities())
{
Context.Configuration.ProxyCreationEnabled = false;
var query = default(string);
if (ASNfilters.ReportType == "Insurance")
{
query = "select * from ASNShipmentHeader asn inner join InvoiceDetails inv on inv.ASNId=asn.ASNId where ( Deleteflag=0 or Deleteflag is null)";
}
else
{
query = "select * from ASNShipmentHeader asn where ( Deleteflag=0 or Deleteflag is null)";
}
if (!string.IsNullOrEmpty(ASNfilters.ToDate) && ASNfilters.Type == "CreatedDate")
{
query += " and asn.CreatedDate <= '" + ASNfilters.ToDate + "'";
}
if (!string.IsNullOrEmpty(ASNfilters.FromDate) && ASNfilters.Type == "CreatedDate")
{
query += " and asn.CreatedDate >= '" + ASNfilters.FromDate + "'";
}
if (!string.IsNullOrEmpty(ASNfilters.ToDate) && ASNfilters.Type == "InvoiceDate")
{
query += " and asn.InvoiceDate <= '" + ASNfilters.ToDate + "'";
}
if (!string.IsNullOrEmpty(ASNfilters.FromDate) && ASNfilters.Type == "InvoiceDate")
{
query += " and asn.InvoiceDate >= '" + ASNfilters.FromDate + "'";
}
if (!string.IsNullOrEmpty(ASNfilters.ToDate) && ASNfilters.Type == "ShippingDate")
{
query += " and asn.ShippingDate <= '" + ASNfilters.ToDate + "'";
}
if (!string.IsNullOrEmpty(ASNfilters.FromDate) && ASNfilters.Type == "ShippingDate")
{
query += " and asn.ShippingDate >= '" + ASNfilters.FromDate + "'";
}
if (!string.IsNullOrEmpty(ASNfilters.Vendorid))
{
query += " and asn.VendorId = '" + ASNfilters.Vendorid + "'";
}
if (!string.IsNullOrEmpty(ASNfilters.InvoiceNo))
{
query += " and asn.InvoiceNo = '" + ASNfilters.InvoiceNo + "'";
}
if (!string.IsNullOrEmpty(ASNfilters.VendorName))
{
query += " and asn.VendorName like'%" + ASNfilters.VendorName + "%'";
}
if (!string.IsNullOrEmpty(ASNfilters.ASNNo))
{
query += " and asn.ASNNo = '" + ASNfilters.ASNNo + "'";
}
if (!string.IsNullOrEmpty(ASNfilters.PONo))
{
query += " and asn.PONos = '" + ASNfilters.PONo + "'";
}
query += " order by asn.ASNId desc ";
asnList = Context.ASNShipmentHeaders.SqlQuery(query).ToList <ASNShipmentHeader>();
}
}
catch (Exception ex)
{
log.ErrorMessage("ASNDA", "getAsnList", ex.Message + "; " + ex.StackTrace.ToString());
}
return(asnList);
}
