public ActionResult Client([Bind(Include = "clientid,userid,countryid")] hc_client_user hC_CLIENT_USERS, long year = 0) { Session["button"] = ""; cache(); if (Session["userid"] == null) { return(RedirectToAction("Login", "Account")); } else { var userinfo = (long)Session["userid"]; var mapped = db.hc_client_user.Where(x => x.Userid == userinfo).FirstOrDefault(); if (mapped != null) { year = 2018; long data = DateTime.Now.Month; long uid = (long)Session["userid"]; var countrys = db.hc_client_user.Where(x => x.Userid == uid).OrderBy(x => x.HCM_COUNTRIES.CountryTitle).First(); long country = (long)countrys.Countryid; var clients = db.hc_client_user.Where(x => x.Userid == uid && x.Countryid == country).OrderBy(x => x.HC_CLIENTS.ClientName).First(); long client = (long)clients.Clientid; var lobs = db.HC_CLIENT_BRANCH.Where(m => m.ClientID == client).Join(db.hc_client_user.Where(x => x.Userid == uid), d => d.ClientID, f => f.Clientid, (d, f) => d).OrderBy(x => x.RID).First(); long lobid = (long)lobs.RID; ViewBag.clid = client; string mymonths = "" + DateTimeFormatInfo.CurrentInfo.GetAbbreviatedMonthName((int)data) + ""; string lobdata = string.Empty; string clientdata = string.Empty; getClient(country, new long[] { client }); getlob(new long[] { client }, country); ViewBag.Status = null; ViewBag.year = year; bindState(); lobdata = ""; clientdata = "" + client + ""; ViewBag.VALUE = db.TimeSheetappliGrid(clientdata, lobdata, year, mymonths); templatedata(); GetYears(); GetMonths((long)year, new[] { data }); return(View()); } else { TempData["mapped"] = "Client is not mapped to you"; ViewBag.mapped = "Client is not mapped to you"; return(RedirectToAction("Dash", "Dashboard")); } } }
public void BarChart([Bind(Include = "clientid,userid,countryid")] hc_client_user hC_CLIENT_USERS, long country, long year, long[] month) { long id = (long)Session["userid"]; try { string countries = string.Empty; // Initialize a string to hold the comma-delimited data as empty if (country != 0) { countries = "" + country + ""; } else { bindState(); IEnumerable <SelectListItem> count = (IEnumerable <SelectListItem>)TempData["country"]; foreach (var item in count) { if (countries.Length > 0) { countries += ","; // Add a comma if data already exists } countries += "" + item.Value + ""; } } string mymonths = string.Empty; if (month[0] == 0) { if (year == 2018) { for (int i = 1; i <= DateTime.Now.Month; i++) { if (mymonths.Length > 0) { mymonths += ","; // Add a comma if data already exists } mymonths += "" + DateTimeFormatInfo.CurrentInfo.GetAbbreviatedMonthName(i) + ""; } } else { mymonths += "" + "Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec" + ""; } } else { foreach (var item in month) { if (mymonths.Length > 0) { mymonths += ","; // Add a comma if data already exists } mymonths += "" + DateTimeFormatInfo.CurrentInfo.GetAbbreviatedMonthName((int)item) + ""; } } List <long> lstClientID = new List <long>(); List <int?> lstTSCount = new List <int?>(); List <TimeSheetBarChart_Result> TimeSheet = new List <TimeSheetBarChart_Result>(); HCClientuserModel.ProductWiseSales(out TimeSheet, id, countries, year, mymonths); ViewBag.TimeSheet = TimeSheet; } catch (Exception ex) { string ip = Request.UserHostAddress; errorfile.SendErrorToText(ex, ip); throw; } }
public ActionResult Dash([Bind(Include = "clientid,userid,countryid")] hc_client_user hC_CLIENT_USERS) { if (TempData["mapped"] != null) { ViewBag.mapped = TempData["mapped"]; } else { ViewBag.mapped = ""; } cache(); if (Session["userid"] == null) { return(RedirectToAction("Login", "Account")); } else { long country = 0; long year = 2018; long data = 0; if (year != 2018) { data = 0; } else { data = DateTime.Now.Month; } long[] months = new[] { data }; string countries = string.Empty; // Initialize a string to hold the comma-delimited data as empty if (country != 0) { countries = "" + country + ""; } else { bindState(); IEnumerable <SelectListItem> count = (IEnumerable <SelectListItem>)TempData["country"]; foreach (var item in count) { if (countries.Length > 0) { countries += ","; // Add a comma if data already exists } countries += "" + item.Value + ""; } } string mymonths = string.Empty; if (months[0] == 0) { if (year == 2018) { for (int i = 1; i <= DateTime.Now.Month; i++) { if (mymonths.Length > 0) { mymonths += ","; // Add a comma if data already exists } mymonths += "" + DateTimeFormatInfo.CurrentInfo.GetAbbreviatedMonthName(i) + ""; } } else { mymonths += "" + "Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec" + ""; } } else { foreach (var item in months) { if (mymonths.Length > 0) { mymonths += ","; // Add a comma if data already exists } mymonths += "" + DateTimeFormatInfo.CurrentInfo.GetAbbreviatedMonthName((int)item) + ""; } } long userid = (long)Session["userid"]; bindState(); BarChart(hC_CLIENT_USERS, 0, year, new[] { data }); GetYears(); clientmapping(); var countrys = db.HCM_COUNTRIES.OrderBy(x => x.CountryTitle).Select(x => x.RID).FirstOrDefault(); getclient(countrys, 0); GetMonths(year, new[] { data }); ViewBag.viewall = db.TimeSheetBarChartDashBoardViewAll(userid, countries, year, mymonths); var mapped = db.hc_client_user.Where(x => x.Userid == userid).FirstOrDefault(); if (mapped == null) { ViewBag.mapped = "Client is not mapped to you"; } return(View()); } }
public string Sendmail(hc_client_user obj, HC_EMAIL_SENT_LOG model, string filename, string uploadefile, long country) { string message = string.Empty; string mesdata = string.Empty; int flag = 1; //message= mail(obj,obj.EmailSubject, obj.EMailBody, "*****@*****.**", null, null, uploadefile, filename, country); // if (message == "Problem while sending email, Please check details.") // { // mesdata += " Email is not sent to"+ "*****@*****.**"+" . "; // flag = 0; // } if (obj.ToEmail != null) { string[] Toemail = obj.ToEmail.Split(';'); foreach (string item in Toemail) { message = mail(obj, obj.EmailSubject, obj.EMailBody, item, null, null, uploadefile, filename, country); if (message == "Problem while sending email, Please check details.") { mesdata += " Email is not sent to" + item + " . "; flag = 0; } } } if (obj.EmailCC != null) { string[] emailcc = obj.EmailCC.Split(';'); foreach (string item in emailcc) { message = mail(obj, obj.EmailSubject, obj.EMailBody, null, null, item, uploadefile, filename, country); if (message == "Problem while sending email, Please check details.") { mesdata += " Email is not sent to" + item + " . "; flag = 0; } } } if (obj.EmailBCC != null) { string[] emailbcc = obj.EmailBCC.Split(';'); foreach (string item in emailbcc) { message = mail(obj, obj.EmailSubject, obj.EMailBody, null, item, null, uploadefile, filename, country); if (message == "Problem while sending email, Please check details.") { mesdata += " Email is not sent to" + item + " . "; flag = 0; } } } if (flag == 1) { obj.message = "Email Send." + mesdata; } else { obj.message = mesdata + " Please check details."; } TempData["country"] = obj.country; TempData["client"] = obj.clients; TempData["lob"] = obj.lobs; TempData["year"] = obj.years; TempData["month"] = obj.monthdata; TempData["message"] = obj.message; cache(); Session["button"] = ""; return(obj.message); }
public string mail(hc_client_user obj, string EmailSubject = null, string EMailBody = null, string ToEmail = null, string EmailBCC = null, string EmailCC = null, string fileupload = null, string fileUploader = null, long country = 0) { HC_EMAIL_SENT_LOG model = new HC_EMAIL_SENT_LOG(); try { var message = new MailMessage(); var from = db.IHD_Country_EmailID.Where(x => x.CountryID == country).Select(x => x.CounEmailID).FirstOrDefault(); message.From = new MailAddress(from); // replace with valid value message.Subject = EmailSubject; message.Body = EMailBody; message.IsBodyHtml = true; var smtp = new SmtpClient { Host = "mailbrd.collabera.com", Port = 25, EnableSsl = false, DeliveryMethod = SmtpDeliveryMethod.Network, UseDefaultCredentials = false, }; if (ToEmail != null) { if (fileupload != "") { string[] filesdata = fileupload.Split(','); foreach (string item in filesdata) { Attachment attachment = new Attachment(Path.Combine(Server.MapPath("~/uploadfolder/"), item)); message.Attachments.Add(attachment); } } if (fileUploader != "") { string[] files = fileUploader.Split(','); foreach (string item in files) { var value = new WebClient(); var filepath = Path.Combine(Server.MapPath("~/uploadfolder/"), item); var filedest = Path.Combine(Server.MapPath("~/uploadeddata/"), item); value.DownloadFile(filepath, filedest); Attachment attachment = new Attachment(filepath, MimeMapping.GetMimeMapping(filepath)); message.Attachments.Add(attachment); value.Dispose(); } } message.To.Add(new MailAddress(ToEmail)); smtp.Send(message); var data = db.TimeSheetDetailsAgainstCandidate(obj.clid).ToArray(); foreach (var datainfo in data) { model.employeeno = obj.clid; model.TSStartdate = datainfo.StartDate; model.TSEnddate = datainfo.EndDate; model.TemplateId = (int)obj.tempid; model.EmailSent = DateTime.Now; model.DateEmailSentUserId = (long)Session["userid"]; db.HC_EMAIL_SENT_LOG.Add(model); db.SaveChanges(); } } if (EmailCC != null) { if (fileupload != "") { string[] filesdata = fileupload.Split(','); foreach (string item in filesdata) { Attachment attachment = new Attachment(Path.Combine(Server.MapPath("~/uploadfolder/"), item)); message.Attachments.Add(attachment); } } if (fileUploader != "") { string[] files = fileUploader.Split(','); foreach (string item in files) { var value = new WebClient(); var filepath = Path.Combine(Server.MapPath("~/uploadfolder/"), item); var filedest = Path.Combine(Server.MapPath("~/uploadeddata/"), item); //FileInfo file = new FileInfo(filedest); //file.Delete(); value.DownloadFile(filepath, filedest); Attachment attachment = new Attachment(filepath, MimeMapping.GetMimeMapping(filepath)); message.Attachments.Add(attachment); value.Dispose(); } } message.CC.Add(new MailAddress(EmailCC)); smtp.Send(message); } if (EmailBCC != null) { if (fileupload != "") { string[] filesdata = fileupload.Split(','); foreach (string item in filesdata) { Attachment attachment = new Attachment(Path.Combine(Server.MapPath("~/uploadfolder/"), item)); message.Attachments.Add(attachment); } } if (fileUploader != "") { string[] files = fileUploader.Split(','); foreach (string item in files) { var value = new WebClient(); var filepath = Path.Combine(Server.MapPath("~/uploadfolder/"), item); var filedest = Path.Combine(Server.MapPath("~/uploadeddata/"), item); value.DownloadFile(filepath, filedest); Attachment attachment = new Attachment(filepath, MimeMapping.GetMimeMapping(filepath)); message.Attachments.Add(attachment); value.Dispose(); } } message.Bcc.Add(new MailAddress(EmailBCC)); smtp.Send(message); } return("Email Send."); } catch (Exception ex) { string ip = Request.UserHostAddress; errorfile.SendErrorToText(ex, ip); return("Problem while sending email, Please check details."); } }
public ActionResult SendEmail(string cid, string month, string clid = null, string name = null, string from = null, string till = null, string bulkemail = null, long countryid = 0, int lobid = 0, long year = 0) { templatedata(); hc_client_user model = new hc_client_user(); if (bulkemail != null) { ViewBag.bulk = "1"; string[] m = bulkemail.Split(','); string offemail = string.Empty; string peremail = string.Empty; string bothemails = string.Empty; string emailids = string.Empty; foreach (var item in m) { var value = db.HC_RESUME_BANK.Where(x => x.EmployeeNo == item).FirstOrDefault(); if (value.ExOfficialEmailID != null) { if (value.ExOfficialEmailID != "") { if (offemail.Length > 0) { offemail += ";"; // Add a comma if data already exists } offemail += "" + value.ExOfficialEmailID + ""; } } if (value.EmailID != null) { if (value.EmailID != "") { if (peremail.Length > 0) { peremail += ";"; // Add a comma if data already exists } peremail += "" + value.EmailID + ""; } } } ViewBag.offemail = offemail; ViewBag.peremail = peremail; if (offemail == null) { ViewBag.bothemail = peremail; } if (peremail == null) { ViewBag.bothemail = offemail; } if (offemail != null && peremail != null) { ViewBag.bothemail = offemail + ";" + peremail; } } else { ViewBag.bulk = "0"; ViewBag.a = from; ViewBag.b = till; model.name = name; var value = db.HC_RESUME_BANK.Where(x => x.EmployeeNo == clid).First(); ViewBag.offemail = value.ExOfficialEmailID; ViewBag.peremail = value.EmailID; if (value.ExOfficialEmailID == null) { ViewBag.bothemail = value.EmailID; } if (value.EmailID == null) { ViewBag.bothemail = value.ExOfficialEmailID; } if (value.ExOfficialEmailID != null && value.EmailID != null) { ViewBag.bothemail = value.ExOfficialEmailID + ";" + value.EmailID; } model.clid = clid; model.from = from; model.till = till; } model.EmailBCC = db.IHD_Country_EmailID.Where(x => x.CountryID == countryid).Select(x => x.CounEmailID).FirstOrDefault(); model.country = countryid; model.clients = cid; model.lob = lobid; model.monthdata = month; model.year = year; model.buttonvalue = "1"; Session["button"] = "1"; return(View(model)); }
public ActionResult Client(hc_client_user model, HC_EMAIL_SENT_LOG obj, long[] client, long[] month, long year = 0, long country = 0, long lob = 0, string Imagepath = null, string closedata = null, string uplodedfile = null) { if (Session["userid"] == null) { return(RedirectToAction("Login", "Account")); } else { var userinfo = (long)Session["userid"]; var data = db.hc_client_user.Where(x => x.Userid == userinfo).FirstOrDefault(); if (data != null) { if (model.buttonvalue == "1") { string[] clientinfo = model.clients.Split(','); string[] monthinfo = model.monthdata.Split(','); List <long> clientarray = new List <long>(); foreach (string s in clientinfo) { long val; if (long.TryParse(s, out val)) { clientarray.Add(val); } } client = clientarray.ToArray(); List <long> montharray = new List <long>(); foreach (string s in monthinfo) { long val; if (long.TryParse(s, out val)) { montharray.Add(val); } } month = montharray.ToArray(); } var mesaage = string.Empty; if (closedata == "0") { if (Session["button"].ToString() == "1") { mesaage = Sendmail(model, obj, Imagepath, uplodedfile, country); } } long id = (long)Session["userid"]; string mymonths = string.Empty; if (month[0] == 0) { if (year == 2018) { for (int i = 1; i <= DateTime.Now.Month; i++) { if (mymonths.Length > 0) { mymonths += ","; // Add a comma if data already exists } mymonths += "" + DateTimeFormatInfo.CurrentInfo.GetAbbreviatedMonthName(i) + ""; } } else { mymonths += "" + "Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec" + ""; } } else { foreach (var item in month) { if (mymonths.Length > 0) { mymonths += ","; // Add a comma if data already exists } mymonths += "" + DateTimeFormatInfo.CurrentInfo.GetAbbreviatedMonthName((int)item) + ""; } } string lobdata = string.Empty; string clientdata = string.Empty; var monthname = model.valclient; getClient(country, client); getlob(client, country, lob); if (client[0] == 0) { foreach (var item in ViewBag.clients) { if (clientdata.Length > 0) { clientdata += ","; // Add a comma if data already exists } clientdata += "" + item.Value + ""; } } else { foreach (var item in client) { if (clientdata.Length > 0) { clientdata += ","; // Add a comma if data already exists } clientdata += "" + item + ""; } } if (lob == 0) { foreach (var item in ViewBag.lobs) { if (lobdata.Length > 0) { lobdata += ","; // Add a comma if data already exists } lobdata += "" + item.Value + ""; } } else { lobdata = "" + lob + ""; } ViewBag.VALUE = db.TimeSheetappliGrid(clientdata, lobdata, year, mymonths); bindState(); GetYears(); GetMonths((long)year, month); ViewBag.count = country; if (mesaage != null) { ViewBag.Status = mesaage; } else { ViewBag.Status = null; } return(View()); } else { return(RedirectToAction("Dash", "Dashboard")); } } }