public static void TemplateMissing(string template, string folder, string servername)
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
DsrcMailSystem.MailSender AppValue = new DsrcMailSystem.MailSender();
//string ServerName = WebConfigurationManager.AppSettings["SeverName"];
string ServerName = AppValue.GetFromMailAddress("ServerName");
DateTime indianTime = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, INDIAN_ZONE);
var UserID = Convert.ToInt64(System.Web.HttpContext.Current.Session["UserID"]);
var username = db.Users.Where(x => x.UserID == UserID).Select(o => o.FirstName + " " + o.LastName).FirstOrDefault();
DateTime currentdate = DateTime.Now;
var Assignobj = db.MissingTemplates.CreateObject();
Assignobj.TemplateName = template;
Assignobj.MissedProcess = folder;
Assignobj.ProcessedBy = username;
Assignobj.ProcessedDate = currentdate;
db.MissingTemplates.AddObject(Assignobj);
db.SaveChanges();
MailMessage mail = new System.Net.Mail.MailMessage();
string EmailAddres = "*****@*****.**";
mail.To.Add(EmailAddres);
mail.From = new MailAddress("*****@*****.**");
mail.Subject = "HRMS-Test Template Missing Exception";
var company = db.Master_ApplicationSettings.Where(x => x.AppKey == "Company Name").Select(o => o.AppValue).FirstOrDefault();
mail.Body = "Template Missing Exception: " + " " + template + " <br/><br/>ServerName: " + " " + servername + " <br/><br/>Date: " + " " + indianTime + " " + "<br/><br/>This email has been automatically generated.</br>Please do not reply to this email address as all responses are directed to an unattended,<br/>mailbox, and you will not receive a response.</p><br/><p style=font-size:15px>Thanks,<br/>" + company + "HRMS</p>";
mail.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
string port = db.Master_ApplicationSettings.Where(x => x.AppKey == "Port").Select(o => o.AppValue).FirstOrDefault();
smtp.Host = db.Master_ApplicationSettings.Where(x => x.AppKey == "Host Name").Select(o => o.AppValue).FirstOrDefault();
smtp.Port = Convert.ToInt32(port.ToString());
smtp.UseDefaultCredentials = false;
smtp.Credentials = new System.Net.NetworkCredential
("*****@*****.**", "dsrc1234");// Enter senders User name and password
smtp.EnableSsl = false;
smtp.Send(mail);
}
public static void Mail_Trigger(Exception ex, string actionName, string controllerName)
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
DsrcMailSystem.MailSender AppValue = new DsrcMailSystem.MailSender();
//string ServerName = WebConfigurationManager.AppSettings["SeverName"];
string ServerName = AppValue.GetFromMailAddress("ServerName");
string AssignedbyEmailId = System.Web.HttpContext.Current.Application["UserName"].ToString();
// var userid = Convert.ToInt32(Session["UserID"].ToString());
var objuser = db.Users.Where(o => o.UserName == AssignedbyEmailId).Select(o => o).FirstOrDefault();
string UserName = objuser.FirstName + " " + objuser.LastName;
DateTime indianTime = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, INDIAN_ZONE);
var MethodName = (ex.InnerException != null) ? (ex.InnerException.TargetSite.Name == null ? "" : ex.InnerException.TargetSite.Name) : (ex.TargetSite.Name == null ? "" : ex.TargetSite.Name);;
var ExceptionDate = DateTime.Now;
var ExceptionMessage = (ex.InnerException != null) ? ex.InnerException.Message : ex.Message;
var Source = (ex.InnerException != null) ? ex.InnerException.Source : ex.Source;
var StackTrace = (ex.InnerException != null) ? ex.InnerException.StackTrace : ex.StackTrace;
var url = ServerName + controllerName + "/" + actionName;
var objcom = db.Master_ApplicationSettings.Where(x => x.AppKey == "Company Name").Select(o => o.AppValue).FirstOrDefault();
//var company = db.Master_ApplicationSettings.Where(x => x.AppKey == "Company Name").Select(o => o.AppValue).FirstOrDefault();
var obj1 = (from p in db.EmailPurposes.Where(x => x.EmailPurposeName == "Error Message")
join q in db.EmailTemplates on p.EmailTemplateID equals q.EmailTemplateID
select new DSRCManagementSystem.Models.Email
{
To = p.To,
CC = p.CC,
BCC = p.BCC,
Subject = p.Subject,
Template = q.TemplatePath
}).FirstOrDefault();
var path = System.Web.Hosting.HostingEnvironment.MapPath(obj1.Template);
//var file = server.MapPath("~/SomeDirectory/Somefile");
//string TemplatePath = Server.MapPath(obj1.Template);
string html = System.IO.File.ReadAllText(path);
string FromMailId = "*****@*****.**";
//string Title = " " + objcom + " calendar event Created";
string Subject = "Management Portal : Error Report" + " " + "on" + " " + DateTime.Today.ToString("ddd, MMM d, yyyy");
obj1.Subject = " " + objcom + " " + "Management Portal : Error Report";
html = html.Replace("#Error", ExceptionMessage);
html = html.Replace("#Subject", Subject);
html = html.Replace("#Date", DateTime.Today.ToString("dd/MM/yyyy"));
html = html.Replace("#url", url);
html = html.Replace("#UserName", UserName);
html = html.Replace("#CompanyName", objcom.ToString());
html = html.Replace("#ServerName", ServerName);
List <string> MailIds = db.TestMailIDs.Select(o => o.MailAddress).ToList();
string EmailAddres = "";
for (int i = 0; i < MailIds.Count(); i++)
{
if (i != MailIds.Count() - 1)
{
EmailAddres += MailIds[i] + ",";
}
else
{
EmailAddres += MailIds[i];
}
}
if (ServerName != "http://win2012srv:88/")
{
Task.Factory.StartNew(() =>
{
string pathvalue = CommonLogic.getLogoPath();
DsrcMailSystem.MailSender.TaskMail(null, Subject, html, FromMailId, EmailAddres, System.Web.Hosting.HostingEnvironment.MapPath(pathvalue.ToString()));
});
}
else
{
Task.Factory.StartNew(() =>
{
string pathvalue = CommonLogic.getLogoPath();
DsrcMailSystem.MailSender.TaskMail(null, Subject, html, FromMailId, EmailAddres, System.Web.Hosting.HostingEnvironment.MapPath(pathvalue.ToString()));
});
}
}
public ActionResult Skills(skilllist model, FormCollection formData)
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
DsrcMailSystem.MailSender AppValue = new DsrcMailSystem.MailSender();
int UserId = (int)Session["UserId"];
List <string> Technology = new List <string>();
List <string> Specialization = new List <string>();
List <string> Lastused = new List <string>();
List <string> Experience = new List <string>();
int t = 0;
int? s = 0;
string ServerName = AppValue.GetFromMailAddress("ServerName");
var objcompany = db.Master_ApplicationSettings.Where(x => x.AppKey == "Company Name").Select(o => o.AppValue).FirstOrDefault();
for (int i = 0; i < model.skilllists.Count; i++)
{
var LDobj = db.Skills.CreateObject();
if (model.skilllists[i].Id != 0)
{
try
{
LDobj.Technology = model.skilllists[i].Id;
t = model.skilllists[i].Id;
var Techname = db.SkillsTechnologies.Where(o => o.SkillId == t).Select(o => o.SkillName).FirstOrDefault();
Technology.Add(Convert.ToString(Techname));
LDobj.Specialization = model.skilllists[i].SpecificationId;
s = model.skilllists[i].SpecificationId;
var SpecializationName = db.SkillsSpecifications.Where(o => o.SpecificationId == s).Select(o => o.Specification).FirstOrDefault();
Specialization.Add(Convert.ToString(SpecializationName));
LDobj.Level = model.skilllists[i].LevelId;
LDobj.Date = Convert.ToDateTime(model.skilllists[i].DateAssessed);
LDobj.LastUsed = model.skilllists[i].yearid;
Lastused.Add(Convert.ToString(model.skilllists[i].yearid));
LDobj.UserId = Convert.ToInt32(Session["UserID"]);
LDobj.Primary = Convert.ToBoolean(model.skilllists[i].Primary);
LDobj.Secondary = Convert.ToBoolean(model.skilllists[i].Secondary);
LDobj.experiance = model.skilllists[i].experiance.Trim();
Experience.Add(Convert.ToString(model.skilllists[i].experiance));
LDobj.Isactive = true;
LDobj.status = 2;
LDobj.ApprovedBy = model.skilllists[i].ApprovedBy;
db.Skills.AddObject(LDobj);
db.SaveChanges();
}
catch (Exception)
{
}
}
TempData["Success"] = "Skill details Saved Successfully";
}
var LevelList = db.Master_TrainingLevel.ToList();
var TechList = db.SkillsTechnologies.ToList();
var yearlist = db.Master_years.ToList();
var specList = db.SkillsSpecifications.ToList();
skilllist sk = new skilllist();
List <Skills> skl = new List <Skills>();
Skills lModel = new Skills();
List <SelectListItem> LevelList1 = new List <SelectListItem>();
List <SelectListItem> TechList1 = new List <SelectListItem>();
List <SelectListItem> yearlist11 = new List <SelectListItem>();
List <SelectListItem> specList1 = new List <SelectListItem>();
foreach (var list in specList)
{
specList1.Add(new SelectListItem {
Text = list.Specification, Value = Convert.ToString(list.SpecificationId)
});
}
lModel.speciIdList = specList1;
foreach (var list in LevelList)
{
LevelList1.Add(new SelectListItem {
Text = list.LevelName, Value = Convert.ToString(list.LevelId)
});
}
lModel.LevelIDList = LevelList1;
foreach (var list in TechList)
{
TechList1.Add(new SelectListItem {
Text = list.SkillName, Value = Convert.ToString(list.SkillId)
});
}
lModel.TechIDList = TechList1;
foreach (var list in yearlist)
{
//yearlist11.Add(new SelectListItem { Text = list.year1.ToString(), Value = Convert.ToString(list.ID) });
yearlist11.Add(new SelectListItem {
Text = list.year.ToString(), Value = Convert.ToString(list.ID)
});
}
lModel.yearidlist = yearlist11;
for (int i = 0; i < 1; i++)
{
Skills lm = new Skills();
lm.SpecificationId = 0;
lm.LevelId = 0;
lm.Id = 0;
lm.DateAssessed = null;
lm.LastUsed = 0;
lm.Primary = false;
lm.Secondary = false;
skl.Add(lm);
}
sk.skilllists = skl;
sk.SKL = lModel;
var skillid = db.Skills.Where(o => o.UserId == UserId && o.Technology == t && o.Specialization == s).Select(o => o.Id).FirstOrDefault();
var empname = db.Users.Where(o => o.UserID == UserId).Select(o => o.FirstName + " " + ((o.LastName).Length > 0? o.LastName:" ")).FirstOrDefault();
var reporting = db.Skills.Where(o => o.UserId == UserId && o.Technology == t && o.Specialization == s).Select(o => o.ApprovedBy).FirstOrDefault();
int reportingid = (int)reporting;
var reportingname = db.Users.Where(o => o.UserID == reportingid).Select(o => o.FirstName + " " + ((o.LastName).Length > 0 ? o.LastName : " ")).FirstOrDefault();
var reportingemail = db.Users.Where(o => o.UserID == reportingid).Select(o => o.EmailAddress).FirstOrDefault();
var checks = db.EmailTemplates.Where(x => x.TemplatePurpose == "Skill Added").Select(o => o.EmailTemplateID).FirstOrDefault();
var folder = db.EmailTemplates.Where(o => o.TemplatePurpose == "Skill Added").Select(x => x.TemplatePath).FirstOrDefault();
if ((checks != null) && (checks != 0))
{
var objRequest = (from p in db.EmailPurposes.Where(x => x.EmailPurposeName == "Skill Added")
join q in db.EmailTemplates on p.EmailTemplateID equals q.EmailTemplateID
select new DSRCManagementSystem.Models.Email
{
To = p.To,
CC = p.CC,
BCC = p.BCC,
Subject = p.Subject,
Template = q.TemplatePath
}).FirstOrDefault();
var company = db.Master_ApplicationSettings.Where(x => x.AppKey == "Company Name").Select(o => o.AppValue).FirstOrDefault();
string TemplatePath = Server.MapPath(objRequest.Template);
string html = System.IO.File.ReadAllText(TemplatePath);
string Title = " Following Skills were Added by " + " " + empname + " " + "for Approval";
html = html.Replace("#Title", Title);
html = html.Replace("#Technology", Technology[0]);
html = html.Replace("#Specialization", Specialization[0]);
html = html.Replace("#LastUsed", Lastused[0]);
html = html.Replace("#Experience", Experience[0]);
html = html.Replace("#RequestedId", Convert.ToString(skillid));
html = html.Replace("#ReportingPersonName", Convert.ToString(reportingname));
html = html.Replace("#ServerName", ServerName);
html = html.Replace("#CompanyName", objcompany);
html = html.Replace("#ReqUser", empname);
var logo = CommonLogic.getLogoPath();
if (ServerName != "http://*****:*****@dsrc.co.in", EmailAddress, Server.MapPath(logo.ToString()));
});
}
//else
//{
// Task.Factory.StartNew(() =>
// {
// DsrcMailSystem.MailSender.SendMail(null, objRequest.Subject, null, html, "*****@*****.**", Convert.ToString(reportingemail), Server.MapPath(logo.ToString()));
// });
//}
}
else
{
ExceptionHandlingController.TemplateMissing("Skill Added", folder, ServerName);
}
return(RedirectToAction("Skills", sk));
}
