public int InsertTicketTran(TicketTranModel model)
{
try
{
Mapper.CreateMap <TicketTranModel, TicketTran>();
TicketTran objUser = Mapper.Map <TicketTran>(model);
Dbcontext.TicketTrans.Add(objUser);
Dbcontext.SaveChanges();
int ttid = Dbcontext.TicketTrans.Max(m => m.TTranID);
return(ttid);
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult Index(HttpPostedFileBase[] files, TicketModel model, TicketTranModel model1)
{
TicketService objService = new TicketService();
model.TicketStatusID = 1;
model.IsActive = true;
int uid = 0;
int tid = 0;
int cid = 0;
if (Session["UID"] != null)
{
uid = Convert.ToInt32(Session["UID"].ToString());
if (model.CreatedBy == null)
{
model.CreatedBy = uid;
}
if (Session["CompID"] != null)
{
cid = Convert.ToInt32(Session["CompID"].ToString());
}
if (model.comp == null || model.comp == 0)
{
model.CompID = cid;
}
else
{
model.CompID = model.comp;
}
//if (model.TicketTypeID == 1)
//{
// var TList = Dbcontext.TicketMasters.Where(m => m.TicketNo.Contains("REQ")).Max(m => m.TicketNo).ToList();
//}
model.CreatedDate = System.DateTime.Now;
var lstCat = Dbcontext.TicketTypeMasters.Where(m => m.TicketTypeID == model.TicketTypeID).SingleOrDefault();
string spre = "";
if (model.SubType != null && model.SubType != 0)
{
var lstSubCat = Dbcontext.TicketSubTypes.Where(m => m.TTSID == model.SubType).SingleOrDefault();
spre = lstSubCat.SubType.Substring(0, 3);
}
string pre = lstCat.TicketType.Substring(0, 3);
string result = pre + "" + spre;
//var prefix = Regex.Replace(result, @"\b(\w)", m => m.Value.ToUpper());
var prefix = Thread.CurrentThread.CurrentCulture.TextInfo.ToUpper(result);
model.Prefix = prefix;
model1.Prefix = prefix;
//if (model.TicketTypeID == 1)
//{
// model.Prefix = "REQ";
// model1.Prefix = "REQ";
//}
//else if (model.TicketTypeID == 2)
//{
// model.Prefix = "INC";
// model1.Prefix = "INC";
//}
//else
//{
// model.Prefix = "CHG";
// model1.Prefix = "CHG";
//}
tid = objService.InsertTicket(model);
TempData["Msg"] = "Ticket Sent Successfully.";
if (files != null)
{
//string k = objService.Getid();
//int s = Convert.ToInt32(k);
//string strtext = "Customer";
foreach (HttpPostedFileBase file in files)
{
if (file != null)
{
string filename = System.IO.Path.GetFileName(file.FileName);
string folderPath = Server.MapPath("~/Attachment/") + model.TicketID;
// obj.EmpId = Convert.ToInt32(Url.RequestContext.RouteData.Values["id"].ToString());
string destinationPath = folderPath;
string employeeFolderPath = destinationPath;
// create folder if it is not exist
if (!Directory.Exists(folderPath))
{
Directory.CreateDirectory(folderPath);
if (!Directory.Exists(employeeFolderPath))
{
Directory.CreateDirectory(employeeFolderPath);
// create emp id folder of not exist
}
}
else
{
if (!Directory.Exists(employeeFolderPath))
{
Directory.CreateDirectory(employeeFolderPath);
// create emp id folder of not exist
}
}
destinationPath = employeeFolderPath;
/*Saving the file in server folder*/
//file.SaveAs(Server.MapPath("~/Images/" + filename));
string fileNewName = Guid.NewGuid() + Path.GetExtension(file.FileName);
file.SaveAs(Path.Combine(destinationPath, fileNewName));
model1.TicketID = tid;
model1.Comment = model.Description;
model1.FileURL = Path.Combine("/Attachment/" + model.TicketID + "/", fileNewName);
model1.FileName = Path.GetFileNameWithoutExtension(file.FileName);
if (model.CreatedBy == null)
{
model1.CreatedBy = uid;
}
else
{
model1.CreatedBy = model.CreatedBy;
}
model1.CreatedDate = System.DateTime.Now;
//model1.ReplayBy = uid;
//model1.ReplayDate = System.DateTime.Now;
objService.InsertTicketTran(model1);
TempData["Msg"] = "Ticket Sent Successfully.";
}
else
{
model1.TicketID = tid;
model1.Comment = model.Description;
if (model.CreatedBy == null)
{
model1.CreatedBy = uid;
}
else
{
model1.CreatedBy = model.CreatedBy;
}
model1.CreatedDate = System.DateTime.Now;
//model1.ReplayBy = uid;
//model1.ReplayDate = System.DateTime.Now;
objService.InsertTicketTran(model1);
TempData["Msg"] = "Ticket Sent Successfully.";
}
}
}
try
{
var user = Dbcontext.UserMasters.Where(m => m.UID == model.CreatedBy).SingleOrDefault();
var comp = Dbcontext.CompanyMasters.Where(m => m.CompID == user.CompID).SingleOrDefault();
string priority = "";
if (model.Priority == 1)
{
priority = "High";
}
else if (model.Priority == 2)
{
priority = "Medium";
}
else
{
priority = "Normal";
}
var fromAddress = new MailAddress("*****@*****.**", comp.Name);
var toAddress = new MailAddress("*****@*****.**", "Niraj Shah");
//var toAddress = new MailAddress("*****@*****.**", "Administrator of Techflow");
const string fromPassword = "******";
var tt = Dbcontext.TicketTypeMasters.Where(a => a.TicketTypeID == model.TicketTypeID).SingleOrDefault();
string subject = "New Ticket-" + model.Subject;
StringBuilder sb = new StringBuilder();
sb.Append("<html>");
sb.Append("<Body>");
sb.Append("<table><tr><td><b>Dear Newtech Administrator,</b></td></tr><tr><td><br/><b>Ticket Created By : </b></td><td><br/>" + user.Title + ' ' + user.FirstName + ' ' + user.LastName + "</td></tr><tr><td><b>Ticket ID : </b></td><td>" + model.Prefix + "" + tid + "</td></tr><tr><td><b>Description : </b></td><td>" + model.Description + "</td></tr><tr><td><b>Ticket Type : </b></td><td>" + tt.TicketType + "</td></tr><tr><td><b>Ticket Priority : </b></td><td>" + priority + "</td></tr><tr><td><br/><b>Thanks and Regards,</b><br/></td></tr><tr><td>" + user.FirstName + ' ' + user.LastName + "</td></tr><tr><td>" + comp.Name + "</td></tr></table>");
sb.Append("</Body>");
sb.Append("</html>");
string body = sb.ToString();
var smtp = new SmtpClient
{
Host = "smtp.mail.yahoo.com",
Port = 25,
EnableSsl = true,
DeliveryMethod = SmtpDeliveryMethod.Network,
UseDefaultCredentials = false,
Credentials = new NetworkCredential(fromAddress.Address, fromPassword)
};
using (var message = new MailMessage(fromAddress, toAddress)
{
Subject = subject,
Body = body
})
{
foreach (HttpPostedFileBase file in files)
{
if (file != null)
{
string fileName = Path.GetFileName(file.FileName);
message.Attachments.Add(new Attachment(file.InputStream, fileName));
}
}
message.IsBodyHtml = true;
message.CC.Add(new MailAddress(Convert.ToString("*****@*****.**"), "Ketan Panchal"));
message.CC.Add(new MailAddress(Convert.ToString("*****@*****.**"), "Ketan-2"));
message.CC.Add(new MailAddress(Convert.ToString("*****@*****.**"), "Kuldip Patel"));
smtp.Send(message);
TempData["Msg"] = "Your Ticket Successfully Sent.";
}
}
catch (Exception ex)
{
TempData["Msg"] = "Sorry!!Ticket not sent try after some time.";
}
}
return(RedirectToAction("Index"));
}
public ActionResult Replay(HttpPostedFileBase[] files, TicketTranModel model, TicketModel model1)
{
TicketService objService = new TicketService();
int uid = 0;
int rid = 0;
if (Session["UID"] != null)
{
uid = Convert.ToInt32(Session["UID"].ToString());
rid = Convert.ToInt32(Session["Role"].ToString());
TicketMaster tm = Dbcontext.TicketMasters.Where(m => m.TicketID == model1.TicketID).SingleOrDefault();
//mailto CA
if (model1.TicketStatusID != null)
{
var status = Dbcontext.TicketMasters.Where(m => m.TicketID == model.TicketID && m.TicketStatusID == model1.TicketStatusID).SingleOrDefault();
if (status == null)
{
try
{
var cby = Dbcontext.UserMasters.Where(m => m.UID == tm.CreatedBy).SingleOrDefault();
var user = Dbcontext.UserMasters.Where(m => m.CompID == @cby.CompID && m.Role == 2).ToList();
int adminID = 0;
if (Session["UID"] != null)
{
adminID = Convert.ToInt32(Session["UID"].ToString());
}
var admin = Dbcontext.UserMasters.Where(m => m.UID == adminID).SingleOrDefault();
string priority = "";
if (model1.Priority == 1)
{
priority = "High";
}
else if (model1.Priority == 2)
{
priority = "Medium";
}
else
{
priority = "Normal";
}
var comp = Dbcontext.CompanyMasters.Where(m => m.CompID == cby.CompID).SingleOrDefault();
var fromAddress = new MailAddress("*****@*****.**", "Newtech Ticketing Soultion");
var toAddress = new MailAddress(@user[0].Email, @user[0].FirstName + ' ' + @user[0].LastName);
//var toAddress = new MailAddress("*****@*****.**", "Administrator of Techflow");
const string fromPassword = "******";
var tt = Dbcontext.TicketTypeMasters.Where(a => a.TicketTypeID == tm.TicketTypeID).SingleOrDefault();
var bts = Dbcontext.TicketStatusMasters.Where(m => m.TicketStatusID == tm.TicketStatusID).SingleOrDefault();
var ats = Dbcontext.TicketStatusMasters.Where(m => m.TicketStatusID == model1.TicketStatusID).SingleOrDefault();
int tid = tm.TicketID;
string ticketID = tm.Prefix + "" + tm.TicketID;
string subject = "Status Changed from " + bts.TicketStatus + " To " + ats.TicketStatus + " of " + ticketID;
StringBuilder sb = new StringBuilder();
sb.Append("<html>");
sb.Append("<Body>");
sb.Append("<table><tr><td><b>Dear sir/madam,</b></td></tr><tr><td><br/><b>Ticket Created By : </b></td><td><br/>" + cby.Title + ' ' + cby.FirstName + ' ' + cby.LastName + "</td></tr><tr><td><b>Ticket ID : </b></td><td>" + ticketID + "</td></tr><tr><td><b>Description : </b></td><td>" + tm.Description + "</td></tr><tr><td><b>Ticket Type : </b></td><td>" + tt.TicketType + "</td></tr><tr><td><b>Ticket Priority : </b></td><td>" + priority + "</td></tr><tr><td><br/><b>Thanks and Regards,</b><br/></td></tr><tr><td>" + admin.Title + ' ' + admin.FirstName + ' ' + admin.LastName + "</td></tr><tr><td>Newtech Infosoft Pvt. Ltd.</td></tr></table>");
sb.Append("</Body>");
sb.Append("</html>");
string body = sb.ToString();
var smtp = new SmtpClient
{
Host = "smtp.mail.yahoo.com",
Port = 25,
EnableSsl = true,
DeliveryMethod = SmtpDeliveryMethod.Network,
UseDefaultCredentials = false,
Credentials = new NetworkCredential(fromAddress.Address, fromPassword)
};
using (var message = new MailMessage(fromAddress, toAddress)
{
Subject = subject,
Body = body
})
{
//foreach (HttpPostedFileBase file in files)
//{
// if (file != null)
// {
// string fileName = Path.GetFileName(file.FileName);
// message.Attachments.Add(new Attachment(file.InputStream, fileName));
// }
//}
message.IsBodyHtml = true;
//var user = Dbcontext.UserMasters.Where(m => m.CompID == @cby.CompID && m.Role == 2).ToList();
//foreach (var u in user)
//{
// message.CC.Add(new MailAddress(Convert.ToString(u.Email), u.FirstName));
//}
//message.CC.Add(new MailAddress(Convert.ToString("*****@*****.**"), "Info-Sugam Health Care"));
smtp.Send(message);
TempData["Msg"] = "Mail Successfully Sent.";
}
}
catch (Exception ex)
{
TempData["Msg"] = "Sorry!!Mail not sent.";
}
}
}
if (model1.AssignTo != null)
{
var assign = Dbcontext.TicketMasters.Where(m => m.AssignTo == model.AssignTo && m.TicketID == model.TicketID).SingleOrDefault();
if (assign == null)
{
try
{
var user = Dbcontext.UserMasters.Where(m => m.UID == model.AssignTo).SingleOrDefault();
var cby = Dbcontext.UserMasters.Where(m => m.UID == tm.CreatedBy).SingleOrDefault();
int adminID = 0;
if (Session["UID"] != null)
{
adminID = Convert.ToInt32(Session["UID"].ToString());
}
var admin = Dbcontext.UserMasters.Where(m => m.UID == adminID).SingleOrDefault();
string priority = "";
if (model1.Priority == 1)
{
priority = "High";
}
else if (model1.Priority == 2)
{
priority = "Medium";
}
else
{
priority = "Normal";
}
//var comp = Dbcontext.CompanyMasters.Where(m => m.CompID == user.CompID).SingleOrDefault();
var fromAddress = new MailAddress("*****@*****.**", "Newtech Infosoft Pvt. Ltd.");
var toAddress = new MailAddress(@user.Email, @user.FirstName);
//var toAddress = new MailAddress("*****@*****.**", "Administrator of Techflow");
const string fromPassword = "******";
var tt = Dbcontext.TicketTypeMasters.Where(a => a.TicketTypeID == tm.TicketTypeID).SingleOrDefault();
int tid = tm.TicketID;
string ticketID = tm.Prefix + "" + model.TicketID;
string subject = "New Ticket-" + tm.Subject;
StringBuilder sb = new StringBuilder();
sb.Append("<html>");
sb.Append("<Body>");
sb.Append("<table><tr><td><b>Dear " + user.Title + ' ' + @user.FirstName + ' ' + @user.LastName + ",</b></td></tr><tr><td><br/><b>Ticket Created By : </b></td><td><br/>" + cby.Title + ' ' + cby.FirstName + ' ' + cby.LastName + "</td></tr><tr><td><b>Ticket ID : </b></td><td>" + ticketID + "</td></tr><tr><td><b>Description : </b></td><td>" + tm.Description + "</td></tr><tr><td><b>Ticket Type : </b></td><td>" + tt.TicketType + "</td></tr><tr><td><b>Ticket Priority : </b></td><td>" + priority + "</td></tr><tr><td><br/><b>Thanks and Regards,</b><br/></td></tr><tr><td>" + admin.Title + ' ' + admin.FirstName + ' ' + admin.LastName + "</td></tr><tr><td>Newtech Infosoft Pvt. Ltd.</td></tr></table>");
sb.Append("</Body>");
sb.Append("</html>");
string body = sb.ToString();
var smtp = new SmtpClient
{
Host = "smtp.mail.yahoo.com",
Port = 25,
EnableSsl = true,
DeliveryMethod = SmtpDeliveryMethod.Network,
UseDefaultCredentials = false,
Credentials = new NetworkCredential(fromAddress.Address, fromPassword)
};
using (var message = new MailMessage(fromAddress, toAddress)
{
Subject = subject,
Body = body
})
{
//foreach (HttpPostedFileBase file in files)
//{
// if (file != null)
// {
// string fileName = Path.GetFileName(file.FileName);
// message.Attachments.Add(new Attachment(file.InputStream, fileName));
// }
//}
message.IsBodyHtml = true;
message.CC.Add(new MailAddress(Convert.ToString("*****@*****.**"), "Kuldip"));
//message.CC.Add(new MailAddress(Convert.ToString("*****@*****.**"), "Info-Sugam Health Care"));
smtp.Send(message);
TempData["Msg"] = "Mail sent successfully.";
}
}
catch (Exception ex)
{
TempData["Msg"] = "Sorry!!Mail not sent.";
}
}
}
//mail to CA end
tm.TicketStatusID = model1.TicketStatusID;
tm.UpdatedDate = System.DateTime.Now;
tm.UpdatedBy = uid;
tm.AssignTo = model1.AssignTo;
Dbcontext.SaveChanges();
if (files != null)
{
//string k = objService.Getid();
//int s = Convert.ToInt32(k);
//string strtext = "Customer";
foreach (HttpPostedFileBase file in files)
{
if (file != null)
{
string filename = System.IO.Path.GetFileName(file.FileName);
string folderPath = Server.MapPath("~/Attachment/") + model.TicketID;
// obj.EmpId = Convert.ToInt32(Url.RequestContext.RouteData.Values["id"].ToString());
string destinationPath = folderPath;
string employeeFolderPath = destinationPath;
// create folder if it is not exist
if (!Directory.Exists(folderPath))
{
Directory.CreateDirectory(folderPath);
if (!Directory.Exists(employeeFolderPath))
{
Directory.CreateDirectory(employeeFolderPath);
// create emp id folder of not exist
}
}
else
{
if (!Directory.Exists(employeeFolderPath))
{
Directory.CreateDirectory(employeeFolderPath);
// create emp id folder of not exist
}
}
destinationPath = employeeFolderPath;
/*Saving the file in server folder*/
//file.SaveAs(Server.MapPath("~/Images/" + filename));
string fileNewName = Guid.NewGuid() + Path.GetExtension(file.FileName);
file.SaveAs(Path.Combine(destinationPath, fileNewName));
//objModel.CID = Convert.ToInt32(s);
model.FileURL = Path.Combine("/Attachment/" + model.TicketID + "/", fileNewName);
model.FileName = Path.GetFileNameWithoutExtension(file.FileName);
model.TicketID = model1.TicketID;
model.Prefix = model1.Prefix;
model.Comment = model1.Comment;
model.CreatedBy = model.CreatedBy;
model.CreatedDate = model.CreatedDate;
model.ReplayBy = uid;
model.ReplayDate = System.DateTime.Now;
objService.InsertTicketTran(model);
//objModel.BID = Convert.ToInt32(Session["BranchID"].ToString());
//objService.InsertTicketAttachment(model1);
//string filepathtosave = "Images/" + filename;
/*HERE WILL BE YOUR CODE TO SAVE THE FILE DETAIL IN DATA BASE*/
}
else if (model1.Comment != null)
{
model.TicketID = model1.TicketID;
model.Prefix = model1.Prefix;
model.Comment = model1.Comment;
model.CreatedBy = model.CreatedBy;
model.CreatedDate = model.CreatedDate;
model.ReplayBy = uid;
model.ReplayDate = System.DateTime.Now;
objService.InsertTicketTran(model);
}
else
{
TempData["AMsg"] = "Status updated.But message not sent, Enter your message or Attach any files in attachment.";
}
}
}
if (model1.Comment != null || files[0] != null)
{
try
{
if (rid != 1)
{
//var user = Dbcontext.UserMasters.Where(m => m.UID == model.ReplayBy).SingleOrDefault();
//var comp = Dbcontext.CompanyMasters.Where(m => m.CompID == user.CompID).SingleOrDefault();
//var ts = Dbcontext.TicketStatusMasters.Where(m => m.TicketStatusID == model1.TicketStatusID).SingleOrDefault();
//var fromAddress = new MailAddress("*****@*****.**", comp.Name);
//var toAddress = new MailAddress("*****@*****.**", "Administrator of Techflow");
////var toAddress = new MailAddress("*****@*****.**", "Administrator of Techflow");
//const string fromPassword = "******";
//var ticket = Dbcontext.TicketMasters.Where(m => m.TicketID == model1.TicketID).SingleOrDefault();
//string subject = ticket.Subject;
//StringBuilder sb = new StringBuilder();
//sb.Append("<html>");
//sb.Append("<Body>");
//sb.Append("<table><tr><td><b>Dear Techflow Administrator,</b></td></tr><tr><td><br/><b>Ticket ID : </b></td><td><br/>" + model.Prefix + "" + model.TicketID + "</td></tr><tr><td><b>Reply By : </b></td><td>" + user.Title + ' ' + user.FirstName + ' ' + user.LastName + "</td></tr><tr><td><b>Ticket Status : </b></td><td>" + ts.TicketStatus + "</td></tr><tr><td><b>Comment : </b></td><td>" + model.Comment + "</td></tr><tr><td><br/><b>Thanks and Regards,</b><br/></td></tr><tr><td>" + user.FirstName + ' ' + user.LastName + "</td></tr></table>");
//sb.Append("</Body>");
//sb.Append("</html>");
//string body = sb.ToString();
//var smtp = new SmtpClient
//{
// Host = "smtp.mail.yahoo.com",
// Port = 25,
// EnableSsl = true,
// DeliveryMethod = SmtpDeliveryMethod.Network,
// UseDefaultCredentials = false,
// Credentials = new NetworkCredential(fromAddress.Address, fromPassword)
//};
//using (var message = new MailMessage(fromAddress, toAddress)
//{
// Subject = subject,
// Body = body
//})
//{
// foreach (HttpPostedFileBase file in files)
// {
// if (file != null)
// {
// string fileName = Path.GetFileName(file.FileName);
// message.Attachments.Add(new Attachment(file.InputStream, fileName));
// }
// }
// message.IsBodyHtml = true;
// message.CC.Add(new MailAddress(Convert.ToString("*****@*****.**"), "Kuldip"));
// //message.CC.Add(new MailAddress(Convert.ToString("*****@*****.**"), "Info-Sugam Health Care"));
// smtp.Send(message);
// TempData["Msg"] = "Your Reply Successfully Sent.";
//}
}
else
{
//var user = Dbcontext.UserMasters.Where(m => m.UID == model1.CreatedBy).SingleOrDefault();
//var fromAddress = new MailAddress("*****@*****.**", "Techflow Administrator");
////var toAddress = new MailAddress("*****@*****.**", "Administrator of Techflow");
//var toAddress = new MailAddress(user.Email, user.FirstName+" "+user.LastName);
//const string fromPassword = "******";
//var ticket = Dbcontext.TicketMasters.Where(m => m.TicketID == model1.TicketID).SingleOrDefault();
//string subject = ticket.Subject;
//StringBuilder sb = new StringBuilder();
//sb.Append("<html>");
//sb.Append("<Body>");
//sb.Append("<table><tr><td><b>Dear User,</b></td></tr><tr><td><br/><b>Ticket ID : </b></td><td><br/>" + model.Prefix + "" + model.TicketID + "</td></tr><tr><td><b>Reply By : </b></td><td>Techflow Administrator</td></tr><tr><td><b>Comment : </b></td><td>" + model.Comment + "</td></tr><tr><td><br/><b>Thanks and Regards,</b><br/></td></tr><tr><td>Techflow</td></tr></table>");
//sb.Append("</Body>");
//sb.Append("</html>");
//string body = sb.ToString();
//var smtp = new SmtpClient
//{
// Host = "smtp.mail.yahoo.com",
// Port = 25,
// EnableSsl = true,
// DeliveryMethod = SmtpDeliveryMethod.Network,
// UseDefaultCredentials = false,
// Credentials = new NetworkCredential(fromAddress.Address, fromPassword)
//};
//using (var message = new MailMessage(fromAddress, toAddress)
//{
// Subject = subject,
// Body = body
//})
//{
// foreach (HttpPostedFileBase file in files)
// {
// if (file != null)
// {
// string fileName = Path.GetFileName(file.FileName);
// message.Attachments.Add(new Attachment(file.InputStream, fileName));
// }
// }
// message.IsBodyHtml = true;
// message.CC.Add(new MailAddress(Convert.ToString("*****@*****.**"), "Kuldip"));
// //message.CC.Add(new MailAddress(Convert.ToString("*****@*****.**"), "Info-Sugam Health Care"));
// smtp.Send(message);
// TempData["Msg"] = "Your Reply Successfully Sent.";
//}
}
}
catch (Exception ex)
{
TempData["Msg"] = "Sorry!!Reply not sent try after some time.";
}
}
}
return(RedirectToAction("Replay", new { @id = TempData["tid"], @uid = TempData["uid"] }));
}
public ActionResult Index(HttpPostedFileBase[] files, TicketModel model, TicketTranModel model1)
{
TicketService objService = new TicketService();
TicketModel objModel = new TicketModel();
model.TicketStatusID = 1;
model.IsActive = true;
int uid = 0;
int tid = 0;
if (Session["UID"] != null)
{
uid = Convert.ToInt32(Session["UID"].ToString());
if (model.CreatedBy == null)
{
model.CreatedBy = uid;
}
//if (model.TicketTypeID == 1)
//{
// var TList = Dbcontext.TicketMasters.Where(m => m.TicketNo.Contains("REQ")).Max(m => m.TicketNo).ToList();
//}
model.CreatedDate = System.DateTime.Now;
if (model.TicketTypeID == 1)
{
model.Prefix = "REQ";
model1.Prefix = "REQ";
}
else if (model.TicketTypeID == 2)
{
model.Prefix = "INC";
model1.Prefix = "INC";
}
else
{
model.Prefix = "CHG";
model1.Prefix = "CHG";
}
objModel = objService.GetLastID();
var dateTimeNow = DateTime.Now;
var dateOnlyString = dateTimeNow.ToShortDateString();
//DateTime dt = DateTime.ParseExact(objModel.CreatedDate.ToString(), "yyyy-MM-dd HH:mm:ss.fff", CultureInfo.InvariantCulture);
//string createddt = dt.ToString("dd/M/yyyy", CultureInfo.InvariantCulture);
DateTime dt = DateTime.Parse(objModel.CreatedDate.ToString());
string createddt = dt.ToString("dd-MMM-yy", CultureInfo.InvariantCulture);
if (createddt == dateOnlyString)
{
model.TicketID = objModel.TicketID + 1;
}
else
{
model.TicketID = objModel.TicketID + 38;
}
tid = objService.InsertTicket(model);
TempData["Msg"] = "New Ticket Created.";
if (files != null)
{
//string k = objService.Getid();
//int s = Convert.ToInt32(k);
//string strtext = "Customer";
foreach (HttpPostedFileBase file in files)
{
if (file != null)
{
string filename = System.IO.Path.GetFileName(file.FileName);
string folderPath = Server.MapPath("~/Attachment/") + model.TicketID;
// obj.EmpId = Convert.ToInt32(Url.RequestContext.RouteData.Values["id"].ToString());
string destinationPath = folderPath;
string employeeFolderPath = destinationPath;
// create folder if it is not exist
if (!Directory.Exists(folderPath))
{
Directory.CreateDirectory(folderPath);
if (!Directory.Exists(employeeFolderPath))
{
Directory.CreateDirectory(employeeFolderPath);
// create emp id folder of not exist
}
}
else
{
if (!Directory.Exists(employeeFolderPath))
{
Directory.CreateDirectory(employeeFolderPath);
// create emp id folder of not exist
}
}
destinationPath = employeeFolderPath;
/*Saving the file in server folder*/
//file.SaveAs(Server.MapPath("~/Images/" + filename));
string fileNewName = Guid.NewGuid() + Path.GetExtension(file.FileName);
file.SaveAs(Path.Combine(destinationPath, fileNewName));
model1.TicketID = tid;
model1.Comment = model.Description;
model1.FileURL = Path.Combine("/Attachment/" + model.TicketID + "/", fileNewName);
model1.FileName = Path.GetFileNameWithoutExtension(file.FileName);
if (model.CreatedBy == null)
{
model1.CreatedBy = uid;
}
else
{
model1.CreatedBy = model.CreatedBy;
}
model1.CreatedDate = System.DateTime.Now;
//model1.ReplayBy = uid;
//model1.ReplayDate = System.DateTime.Now;
objService.InsertTicketTran(model1);
TempData["Msg"] = "New Ticket Created.";
}
else
{
model1.TicketID = tid;
model1.Comment = model.Description;
if (model.CreatedBy == null)
{
model1.CreatedBy = uid;
}
else
{
model1.CreatedBy = model.CreatedBy;
}
model1.CreatedDate = System.DateTime.Now;
//model1.ReplayBy = uid;
//model1.ReplayDate = System.DateTime.Now;
objService.InsertTicketTran(model1);
TempData["Msg"] = "New Ticket Created.";
}
}
}
try
{
var user = Dbcontext.UserMasters.Where(m => m.UID == model.CreatedBy).SingleOrDefault();
var comp = Dbcontext.CompanyMasters.Where(m => m.CompID == user.CompID).SingleOrDefault();
//var fromAddress = new MailAddress("*****@*****.**", comp.Name);
var fromAddress = new MailAddress("*****@*****.**", comp.Name);
var toAddress = new MailAddress("*****@*****.**", "Administrator of Techflow");
//var toAddress = new MailAddress("*****@*****.**", "Administrator of Techflow");
const string fromPassword = "******";
var tt = Dbcontext.TicketTypeMasters.Where(a => a.TicketTypeID == model.TicketTypeID).SingleOrDefault();
string subject = "New Ticket-" + model.Prefix + "" + tid;
StringBuilder sb = new StringBuilder();
sb.Append("<html>");
sb.Append("<Body>");
sb.Append("<table><tr><td><b>Dear Techflow Administrator,</b></td></tr><tr><td><br/><b>Created By : </b></td><td><br/>" + user.Title + ' ' + user.FirstName + ' ' + user.LastName + "</td></tr><tr><td><b>Company : </b></td><td>" + comp.Name + "</td></tr><tr><td><b>Ticket ID : </b></td><td>" + model.Prefix + "" + tid + "</td></tr><tr><td><b>Subject : </b></td><td>" + model.Subject + "</td></tr><tr><td><b>Ticket Type : </b></td><td>" + tt.TicketType + "</td></tr><tr><td><b>Ticket Priority : </b></td><td>" + "P" + model.Priority + "</td></tr><tr><td><br/><b>Thanks and Regards,</b><br/></td></tr><tr><td>" + user.FirstName + ' ' + user.LastName + "</td></tr></table>");
sb.Append("</Body>");
sb.Append("</html>");
string body = sb.ToString();
var smtp = new SmtpClient
{
//Host = "smtp.mail.yahoo.com",
//Port = 587,
//EnableSsl = true,
//DeliveryMethod = SmtpDeliveryMethod.Network,
//UseDefaultCredentials = false,
//Credentials = new NetworkCredential(fromAddress.Address, fromPassword)
Host = "smtp.gmail.com",
Port = 587,
EnableSsl = true,
DeliveryMethod = SmtpDeliveryMethod.Network,
UseDefaultCredentials = false,
Credentials = new NetworkCredential(fromAddress.Address, fromPassword)
};
using (var message = new MailMessage(fromAddress, toAddress)
{
Subject = subject,
Body = body
})
{
foreach (HttpPostedFileBase file in files)
{
if (file != null)
{
string fileName = Path.GetFileName(file.FileName);
message.Attachments.Add(new Attachment(file.InputStream, fileName));
}
}
message.IsBodyHtml = true;
//message.CC.Add(new MailAddress(Convert.ToString("*****@*****.**"), "Distributer Order"));
//message.CC.Add(new MailAddress(Convert.ToString("*****@*****.**"), "Dhrumil"));
smtp.Send(message);
TempData["Msg"] = "New Ticket Created.";
}
}
catch (Exception ex)
{
TempData["Msg"] = "New Ticket Created but Email not sent.";
}
}
return(RedirectToAction("Index"));
}
public ActionResult Replay(HttpPostedFileBase[] files, TicketTranModel model, TicketModel model1)
{
TicketService objService = new TicketService();
int uid = 0;
int rid = 0;
if (Session["UID"] != null)
{
uid = Convert.ToInt32(Session["UID"].ToString());
rid = Convert.ToInt32(Session["Role"].ToString());
TicketMaster tm = Dbcontext.TicketMasters.Where(m => m.TicketID == model1.TicketID).SingleOrDefault();
tm.TicketStatusID = model1.TicketStatusID;
tm.UpdatedDate = System.DateTime.Now;
tm.UpdatedBy = uid;
Dbcontext.SaveChanges();
if (files != null)
{
//string k = objService.Getid();
//int s = Convert.ToInt32(k);
//string strtext = "Customer";
foreach (HttpPostedFileBase file in files)
{
if (file != null)
{
string filename = System.IO.Path.GetFileName(file.FileName);
string folderPath = Server.MapPath("~/Attachment/") + model.TicketID;
// obj.EmpId = Convert.ToInt32(Url.RequestContext.RouteData.Values["id"].ToString());
string destinationPath = folderPath;
string employeeFolderPath = destinationPath;
// create folder if it is not exist
if (!Directory.Exists(folderPath))
{
Directory.CreateDirectory(folderPath);
if (!Directory.Exists(employeeFolderPath))
{
Directory.CreateDirectory(employeeFolderPath);
// create emp id folder of not exist
}
}
else
{
if (!Directory.Exists(employeeFolderPath))
{
Directory.CreateDirectory(employeeFolderPath);
// create emp id folder of not exist
}
}
destinationPath = employeeFolderPath;
/*Saving the file in server folder*/
//file.SaveAs(Server.MapPath("~/Images/" + filename));
string fileNewName = Guid.NewGuid() + Path.GetExtension(file.FileName);
file.SaveAs(Path.Combine(destinationPath, fileNewName));
//objModel.CID = Convert.ToInt32(s);
model.FileURL = Path.Combine("/Attachment/" + model.TicketID + "/", fileNewName);
model.FileName = Path.GetFileNameWithoutExtension(file.FileName);
model.TicketID = model1.TicketID;
model.Prefix = model1.Prefix;
model.Comment = model1.Comment;
model.CreatedBy = model.CreatedBy;
model.CreatedDate = model.CreatedDate;
model.ReplayBy = uid;
model.ReplayDate = System.DateTime.Now;
objService.InsertTicketTran(model);
//objModel.BID = Convert.ToInt32(Session["BranchID"].ToString());
//objService.InsertTicketAttachment(model1);
//string filepathtosave = "Images/" + filename;
/*HERE WILL BE YOUR CODE TO SAVE THE FILE DETAIL IN DATA BASE*/
}
else if (model1.Comment != null)
{
model.TicketID = model1.TicketID;
model.Prefix = model1.Prefix;
model.Comment = model1.Comment;
model.CreatedBy = model.CreatedBy;
model.CreatedDate = model.CreatedDate;
model.ReplayBy = uid;
model.ReplayDate = System.DateTime.Now;
objService.InsertTicketTran(model);
}
else
{
TempData["AMsg"] = "Enter your message or Attach any files in attachment.";
}
}
}
if (model1.Comment != null || files[0] != null)
{
try
{
if (rid != 1)
{
var user = Dbcontext.UserMasters.Where(m => m.UID == model.ReplayBy).SingleOrDefault();
var comp = Dbcontext.CompanyMasters.Where(m => m.CompID == user.CompID).SingleOrDefault();
var ts = Dbcontext.TicketStatusMasters.Where(m => m.TicketStatusID == model1.TicketStatusID).SingleOrDefault();
var fromAddress = new MailAddress("*****@*****.**", comp.Name);
var toAddress = new MailAddress("*****@*****.**", "Administrator of Techflow");
//var toAddress = new MailAddress("*****@*****.**", "Administrator of Techflow");
const string fromPassword = "******";
var ticket = Dbcontext.TicketMasters.Where(m => m.TicketID == model1.TicketID).SingleOrDefault();
string subject = model.Prefix + "" + model.TicketID;
StringBuilder sb = new StringBuilder();
sb.Append("<html>");
sb.Append("<Body>");
sb.Append("<table><tr><td><b>Dear Techflow Administrator,</b></td></tr><tr><td><br/><b>Ticket ID : </b></td><td><br/>" + model.Prefix + "" + model.TicketID + "</td></tr><tr><td><b>Reply By : </b></td><td>" + user.Title + ' ' + user.FirstName + ' ' + user.LastName + "</td></tr><tr><td><b>Ticket Status : </b></td><td>" + ts.TicketStatus + "</td></tr><tr><td><b>Comment : </b></td><td>" + model.Comment + "</td></tr><tr><td><br/><b>Thanks and Regards,</b><br/></td></tr><tr><td>" + user.FirstName + ' ' + user.LastName + "</td></tr></table>");
sb.Append("</Body>");
sb.Append("</html>");
string body = sb.ToString();
var smtp = new SmtpClient
{
//Host = "smtp.mail.yahoo.com",
//Port = 25,
//EnableSsl = true,
//DeliveryMethod = SmtpDeliveryMethod.Network,
//UseDefaultCredentials = false,
//Credentials = new NetworkCredential(fromAddress.Address, fromPassword)
Host = "smtp.gmail.com",
Port = 587,
EnableSsl = true,
DeliveryMethod = SmtpDeliveryMethod.Network,
UseDefaultCredentials = false,
Credentials = new NetworkCredential(fromAddress.Address, fromPassword)
};
using (var message = new MailMessage(fromAddress, toAddress)
{
Subject = subject,
Body = body
})
{
foreach (HttpPostedFileBase file in files)
{
if (file != null)
{
string fileName = Path.GetFileName(file.FileName);
message.Attachments.Add(new Attachment(file.InputStream, fileName));
}
}
message.IsBodyHtml = true;
//message.CC.Add(new MailAddress(Convert.ToString("*****@*****.**"), "Distributer Order"));
//message.CC.Add(new MailAddress(Convert.ToString("*****@*****.**"), "Dhrumil"));
//message.CC.Add(new MailAddress(Convert.ToString("*****@*****.**"), "Info-Sugam Health Care"));
smtp.Send(message);
TempData["Msg"] = "Your Reply Successfully Sent.";
}
}
else
{
var user = Dbcontext.UserMasters.Where(m => m.UID == model1.CreatedBy).SingleOrDefault();
//var fromAddress = new MailAddress("*****@*****.**", "Techflow Administrator");
var fromAddress = new MailAddress("*****@*****.**", "Techflow Administrator");
//var toAddress = new MailAddress("*****@*****.**", "Administrator of Techflow");
var toAddress = new MailAddress(user.Email, user.FirstName + " " + user.LastName);
const string fromPassword = "******";
var ticket = Dbcontext.TicketMasters.Where(m => m.TicketID == model1.TicketID).SingleOrDefault();
string subject = model.Prefix + "" + model.TicketID;
StringBuilder sb = new StringBuilder();
sb.Append("<html>");
sb.Append("<Body>");
sb.Append("<table><tr><td><b>Dear User,</b></td></tr><tr><td><br/><b>Ticket ID : </b></td><td><br/>" + model.Prefix + "" + model.TicketID + "</td></tr><tr><td><b>Reply By : </b></td><td>Techflow Administrator</td></tr><tr><td><b>Comment : </b></td><td>" + model.Comment + "</td></tr><tr><td><br/><b>Thanks and Regards,</b><br/></td></tr><tr><td>Techflow</td></tr></table>");
sb.Append("</Body>");
sb.Append("</html>");
string body = sb.ToString();
var smtp = new SmtpClient
{
//Host = "smtp.mail.yahoo.com",
//Port = 25,
Host = "smtp.gmail.com",
Port = 587,
EnableSsl = true,
DeliveryMethod = SmtpDeliveryMethod.Network,
UseDefaultCredentials = false,
Credentials = new NetworkCredential(fromAddress.Address, fromPassword)
};
using (var message = new MailMessage(fromAddress, toAddress)
{
Subject = subject,
Body = body
})
{
foreach (HttpPostedFileBase file in files)
{
if (file != null)
{
string fileName = Path.GetFileName(file.FileName);
message.Attachments.Add(new Attachment(file.InputStream, fileName));
}
}
message.IsBodyHtml = true;
//message.CC.Add(new MailAddress(Convert.ToString("*****@*****.**"), "Distributer Order"));
//message.CC.Add(new MailAddress(Convert.ToString("*****@*****.**"), "Dhrumil"));
//message.CC.Add(new MailAddress(Convert.ToString("*****@*****.**"), "Info-Sugam Health Care"));
smtp.Send(message);
TempData["Msg"] = "Your Reply Successfully Sent.";
}
}
}
catch (Exception ex)
{
TempData["Msg"] = "Reply was not sent. Please try again later.";
}
}
}
return(RedirectToAction("Replay", new { @id = TempData["tid"], @uid = TempData["uid"] }));
}
public ActionResult Delivery(DeliveryModel model, TicketModel model1, TicketTranModel model2)
{
TicketModel objModel = new TicketModel();
TicketService TicobjService = new TicketService();
DeliveryService objService = new DeliveryService();
int uid = 0;
if (Session["UID"] != null)
{
model.Prefix = "REQ";
model1.Prefix = "REQ";
model2.Prefix = "REQ";
uid = Convert.ToInt32(Session["UID"].ToString());
model.IsActive = true;
model.CreatedDate = System.DateTime.Now;
if (model.CreatedBy == null)
{
model.CreatedBy = uid;
model1.CreatedBy = uid;
}
else
{
model1.CreatedBy = model.CreatedBy;
}
model1.Subject = "Delivery Request";
model1.Description = model.ProjectRef;
model1.CreatedDate = System.DateTime.Now;
model1.IsActive = true;
model1.TicketTypeID = 1;
model1.TicketStatusID = 1;
model1.Priority = 4;
objModel = TicobjService.GetLastID();
var dateTimeNow = DateTime.Now;
var dateOnlyString = dateTimeNow.ToShortDateString();
//DateTime dt = DateTime.ParseExact(objModel.CreatedDate.ToString(), "yyyy-MM-dd HH:mm:ss.fff", CultureInfo.InvariantCulture);
//string createddt = dt.ToString("dd/M/yyyy", CultureInfo.InvariantCulture);
DateTime dt = DateTime.Parse(objModel.CreatedDate.ToString());
string createddt = dt.ToString("dd-MMM-yy", CultureInfo.InvariantCulture);
if (createddt == dateOnlyString)
{
model1.TicketID = objModel.TicketID + 1;
}
else
{
model1.TicketID = objModel.TicketID + 38;
}
int tid = objService.Insert(model, model1);
TicketService objService1 = new TicketService();
model2.TicketID = tid;
model2.Comment = model.ProjectRef;
if (model.CreatedBy == null)
{
model2.CreatedBy = uid;
}
else
{
model2.CreatedBy = model.CreatedBy;
}
model2.CreatedDate = System.DateTime.Now;
objService1.InsertTicketTran(model2);
try
{
var user = Dbcontext.UserMasters.Where(m => m.UID == model.CreatedBy).SingleOrDefault();
var comp = Dbcontext.CompanyMasters.Where(m => m.CompID == user.CompID).SingleOrDefault();
var fromAddress = new MailAddress("*****@*****.**", comp.Name);
var toAddress = new MailAddress("*****@*****.**", "Administrator of Techflow");
//var toAddress = new MailAddress("*****@*****.**", "Administrator of Techflow");
const string fromPassword = "******";
var dc = Dbcontext.DataCenterMasters.Where(m => m.DCID == model.DataCenter).SingleOrDefault();
string subject = "Delivery Request " + model.Prefix + "" + tid;
StringBuilder sb = new StringBuilder();
sb.Append("<html>");
sb.Append("<Body>");
sb.Append("<table><tr><td><b>Dear Techflow Administrator,</b></td></tr><tr><td><br/><b>Created By : </b></td><td><br/>" + user.Title + ' ' + user.FirstName + ' ' + user.LastName + "</td></tr><tr><td><b>Data Centre : </b></td><td>" + dc.DataCenter + "</td></tr><tr><td><b>Name : </b></td><td>" + model.FirstName + ' ' + model.LastName + "</td></tr><tr><td><b>Company : </b></td><td>" + model.Company + "</td></tr><tr><td><b>Start Date/Time : </b></td><td>" + model.StDateTime + "</td></tr><tr><td><b>End Date/Time : </b></td><td>" + model.EndDateTime + "</td></tr><tr><td><b>Boxes : </b></td><td>" + model.Boxes + "</td></tr><tr><td><b>Tracking No. : </b></td><td>" + model.TrackingNo + "</td></tr><tr><td><b>Project Reference : </b></td><td>" + model.ProjectRef + "</td></tr><tr><td><b>Storage : </b></td><td>" + model.Storage + "</td></tr><tr><td><b>Remote Hands : </b></td><td>" + model.RemoteHands + "</td></tr><tr><td><br/><b>Thanks and Regards,</b><br/></td></tr><tr><td>" + user.FirstName + ' ' + user.LastName + "</td></tr></table>");
sb.Append("</Body>");
sb.Append("</html>");
string body = sb.ToString();
var smtp = new SmtpClient
{
//Host = "smtp.mail.yahoo.com",
//Port = 25,
//EnableSsl = true,
//DeliveryMethod = SmtpDeliveryMethod.Network,
//UseDefaultCredentials = false,
//Credentials = new NetworkCredential(fromAddress.Address, fromPassword)
Host = "smtp.gmail.com",
Port = 587,
EnableSsl = true,
DeliveryMethod = SmtpDeliveryMethod.Network,
UseDefaultCredentials = false,
Credentials = new NetworkCredential(fromAddress.Address, fromPassword)
};
using (var message = new MailMessage(fromAddress, toAddress)
{
Subject = subject,
Body = body
})
{
message.IsBodyHtml = true;
//message.CC.Add(new MailAddress(Convert.ToString("*****@*****.**"), "Distributer Order"));
//message.CC.Add(new MailAddress(Convert.ToString("*****@*****.**"), "Dhrumil"));
//message.CC.Add(new MailAddress(Convert.ToString("*****@*****.**"), "Info-Sugam Health Care"));
smtp.Send(message);
TempData["Msg"] = "Your Delivery Request Successfully Sent.";
}
}
catch (Exception ex)
{
TempData["Msg"] = "Sorry!!Delivery Request not sent try after some time.";
}
}
return(RedirectToAction("Delivery"));
}
public ActionResult Quotation(QuotationModel model, TicketModel model1, TicketTranModel model2)
{
QuotationService objService = new QuotationService();
QuotationModel objModel = new QuotationModel();
TicketModel TCobjModel = new TicketModel();
TicketService TicobjService = new TicketService();
int uid = 0;
int?dcid = 0;
if (Session["UID"] != null)
{
model.Prefix = "REQ";
model1.Prefix = "REQ";
model2.Prefix = "REQ";
uid = Convert.ToInt32(Session["UID"].ToString());
if (model.DataCenterOther != null)
{
dcid = model.DataCenterOther;
}
else
{
dcid = model.DataCenter;
}
model.DataCenter = dcid;
model.IsActive = true;
model.CreatedDate = System.DateTime.Now;
if (model.CreatedBy == null)
{
model.CreatedBy = uid;
}
if (model.ServiceReq == null && model.CableSource != null)
{
model1.Subject = "Cable Quotation";
model1.Description = model.CableType;
model2.Comment = model.CableType;
}
else
{
model1.Subject = "Other Quotation";
model1.Description = model.ServiceReq;
model2.Comment = model.ServiceReq;
}
if (model.CreatedBy == null)
{
model1.CreatedBy = uid;
}
else
{
model1.CreatedBy = model.CreatedBy;
}
model1.CreatedDate = System.DateTime.Now;
model1.IsActive = true;
model1.TicketTypeID = 1;
model1.TicketStatusID = 1;
model1.Priority = 4;
TCobjModel = TicobjService.GetLastID();
var dateTimeNow = DateTime.Now;
var dateOnlyString = dateTimeNow.ToShortDateString();
//DateTime dt = DateTime.ParseExact(objModel.CreatedDate.ToString(), "yyyy-MM-dd HH:mm:ss.fff", CultureInfo.InvariantCulture);
//string createddt = dt.ToString("dd/M/yyyy", CultureInfo.InvariantCulture);
DateTime dt = DateTime.Parse(objModel.CreatedDate.ToString());
string createddt = dt.ToString("dd-MMM-yy", CultureInfo.InvariantCulture);
if (createddt == dateOnlyString)
{
model1.TicketID = TCobjModel.TicketID + 1;
}
else
{
model1.TicketID = TCobjModel.TicketID + 38;
}
int tid = objService.Insert(model, model1);
TicketService objService1 = new TicketService();
model2.TicketID = tid;
if (model.CreatedBy == null)
{
model2.CreatedBy = uid;
}
else
{
model2.CreatedBy = model.CreatedBy;
}
model2.CreatedDate = System.DateTime.Now;
objService1.InsertTicketTran(model2);
try
{
var user = Dbcontext.UserMasters.Where(m => m.UID == model.CreatedBy).SingleOrDefault();
var comp = Dbcontext.CompanyMasters.Where(m => m.CompID == user.CompID).SingleOrDefault();
//var fromAddress = new MailAddress("*****@*****.**", comp.Name);
//var toAddress = new MailAddress("*****@*****.**", "Administrator of Techflow");
var fromAddress = new MailAddress("*****@*****.**", comp.Name);
var toAddress = new MailAddress("*****@*****.**", "Administrator of Techflow");
//var toAddress = new MailAddress("*****@*****.**", "Administrator of Techflow");
const string fromPassword = "******";
var dc = Dbcontext.DataCenterMasters.Where(m => m.DCID == dcid).SingleOrDefault();
string subject = "Quotation Request " + model.Prefix + "" + tid;
string ReqDelDate = "";
string dateQ = "";
string dateService = "";
if (model.ReqDelDate != null)
{
ReqDelDate = model.ReqDelDate.Value.ToString("dd/MM/yyyy");
}
if (model.DateForQuote != null)
{
dateQ = model.DateForQuote.Value.ToString("dd/MM/yyyy");
}
if (model.DateForService != null)
{
dateService = model.DateForService.Value.ToString("dd/MM/yyyy");
}
StringBuilder sb = new StringBuilder();
sb.Append("<html>");
sb.Append("<Body>");
sb.Append("<table><tr><td><b>Dear Techflow Administrator,</b></td></tr><tr><td><br/><b>Created By : </b></td><td>" + user.Title + ' ' + user.FirstName + ' ' + user.LastName + "</td></tr><tr><td><b>Source of Cable : </b></td><td>" + model.CableSource + "</td></tr><tr><td><b>Destination of Cable : </b></td><td>" + model.CableDest + "</td></tr><tr><td><b>Type of Cable : </b></td><td>" + model.CableType + "</td></tr><tr><td><b>Cable Termination at Source : </b></td><td>" + model.TerminationSource + "</td></tr><tr><td><b>Cable Termination at Destination : </b></td><td>" + model.TerminationDest + "</td></tr><tr><td><b>Rquested Delivery Date : </b></td><td>" + ReqDelDate + "</td></tr><tr><td><b>Premium Service Required : </b></td><td>" + model.IsPremium + "</td></tr><tr><td><b>Patch Panel : </b></td><td>" + model.PatchPanel + "</td></tr><tr><td><b>Media Converter : </b></td><td>" + model.MediaConverter + "</td></tr><tr><td><b>Additional Comments : </b></td><td>" + model.Comments + "</td></tr><tr><td><b>Details of Service : </b></td><td>" + model.ServiceReq + "</td></tr><tr><td><b>Requested Date for Quote : </b></td><td>" + dateQ + "</td></tr><tr><td><b>Requested Date for Service : </b></td><td>" + dateService + "</td></tr><tr><td><br/><b>Thanks and Regards,</b><br/></td></tr><tr><td>" + user.FirstName + ' ' + user.LastName + "</td></tr></table>");
sb.Append("</Body>");
sb.Append("</html>");
string body = sb.ToString();
var smtp = new SmtpClient
{
//Host = "smtp.mail.yahoo.com",
//Port = 25,
//EnableSsl = true,
//DeliveryMethod = SmtpDeliveryMethod.Network,
//UseDefaultCredentials = false,
//Credentials = new NetworkCredential(fromAddress.Address, fromPassword)
Host = "smtp.gmail.com",
Port = 587,
EnableSsl = true,
DeliveryMethod = SmtpDeliveryMethod.Network,
UseDefaultCredentials = false,
Credentials = new NetworkCredential(fromAddress.Address, fromPassword)
};
using (var message = new MailMessage(fromAddress, toAddress)
{
Subject = subject,
Body = body
})
{
message.IsBodyHtml = true;
//message.CC.Add(new MailAddress(Convert.ToString("*****@*****.**"), "Distributer Order"));
//message.CC.Add(new MailAddress(Convert.ToString("*****@*****.**"), "Dhrumil"));
//message.CC.Add(new MailAddress(Convert.ToString("*****@*****.**"), "Info-Sugam Health Care"));
smtp.Send(message);
TempData["Msg"] = "Quotation Successfully Sent.";
}
}
catch (Exception ex)
{
TempData["Msg"] = "Sorry!!Quotation not sent try after some time.";
}
}
return(RedirectToAction("Quotation"));
}
