public DbActionResult <IssueManagementAnchorComment> Post(IssueManagementAnchorComment items)
{
var result = new DbActionResult <IssueManagementAnchorComment>();
bool EFlag = false;
string EmailTo = "";
try
{
var data = items;
string[] emailRegex = { "-", "<", ">", ";", "'" };
for (var i = 0; i < emailRegex.Length; i++)
{
if (data.ID_Comments != null)
{
data.ID_Comments = data.ID_Comments.Replace(emailRegex[i], " ");
}
}
using (var dbcontext = new Teckraft.Data.Sql.InitiativeHubFinalEntities())
{
var chap = dbcontext.ChapterMasters.FirstOrDefault(it => it.ChapterNameFromSystem == data.id_System_Name && it.EmailFlag == true);
if (chap != null)
{
data.id_System_Name = chap.ChapterNameFromSystem;
EFlag = chap.EmailFlag.Value;
EmailTo = chap.EmailTo;
}
}
data.RCB = _userservice.GetCurrentUser();
data = IssueService.Add(data);
// if (EFlag == true)
// {
// if (data.EmailFlag == true && EmailTo != null)
//{
//var tmplt1 = templateService.GetTemplateforComments(data);
// emailService.SendEmail(tmplt1, "*****@*****.**", EmailTo, "", "");
// emailService.SendEmail(tmplt1, "*****@*****.**", EmailTo, "*****@*****.**", "");
// }
//}
result.Success = true;
result.Message = "Comments added successfully ";
}
catch (Exception ex)
{
result.Success = false;
result.Message = "Unable to Save Record!";
result.Exception = ex;
}
return(result);
}
public DbActionResult <UserWiseColumnName> Post(UserWiseColumnName items)
{
var result = new DbActionResult <UserWiseColumnName>();
try
{
var data = items;
using (var dbcontext = new Teckraft.Data.Sql.InitiativeHubFinalEntities())
{
// foreach (var i in data) {
var chap = dbcontext.ChapterMasters.FirstOrDefault(it => it.ChapterNameFromSystem == data.chapterName);
if (chap != null)
{
data.ChapterId = chap.Id;
}
var existingList = dbcontext.UserWiseColumnNames.FirstOrDefault(it => it.UserId == data.UserId && it.ChapterId == data.ChapterId);
if (existingList != null)
{
//dbcontext.UserWiseColumnNames.Remove(existingList);
existingList.ChapterId = data.ChapterId;
existingList.UserId = data.UserId;
existingList.chapternamedisplay = data.chapternamedisplay;
existingList.chapterOwner = data.chapterOwner;
existingList.ID_Category = data.ID_Category;
existingList.id_comments = data.id_comments;
existingList.id_data_load_date = data.id_data_load_date;
existingList.id_dept = data.id_dept;
existingList.ID_Issue_Detail1 = data.ID_Issue_Detail1;
existingList.id_location = data.id_location;
existingList.ID_Logged_Date = data.ID_Logged_Date;
existingList.id_pending_with_email = data.id_pending_with_email;
existingList.id_pending_with_name = data.id_pending_with_name;
existingList.id_reported_by_email = data.id_reported_by_email;
existingList.id_reported_by_name = data.id_reported_by_name;
existingList.id_request = data.id_request;
existingList.id_status = data.id_status;
existingList.ID_Target_Date = data.ID_Target_Date;
existingList.id_tat_status = data.id_tat_status;
existingList.pendingSince = data.pendingSince;
existingList.title = data.title;
existingList.UserId = _userservice.GetCurrentUser().Id;
existingList.RUB = _userservice.GetCurrentUser().Id;
existingList.RUT = DateTime.Now;
dbcontext.SaveChanges();
}
else
{
dbcontext.UserWiseColumnNames.Add(new Teckraft.Data.Sql.UserWiseColumnName()
{
ChapterId = data.ChapterId,
UserId = _userservice.GetCurrentUser().Id,
chapternamedisplay = data.chapternamedisplay,
chapterOwner = data.chapterOwner,
ID_Category = data.ID_Category,
id_comments = data.id_comments,
id_data_load_date = data.id_data_load_date,
id_dept = data.id_dept,
ID_Issue_Detail1 = data.ID_Issue_Detail1,
id_location = data.id_location,
ID_Logged_Date = data.ID_Logged_Date,
id_pending_with_email = data.id_pending_with_email,
id_pending_with_name = data.id_pending_with_name,
id_reported_by_email = data.id_reported_by_email,
id_reported_by_name = data.id_reported_by_name,
id_request = data.id_request,
id_status = data.id_status,
ID_Target_Date = data.ID_Target_Date,
id_tat_status = data.id_tat_status,
pendingSince = data.pendingSince,
title = data.title,
RCT = DateTime.Now,
RCB = _userservice.GetCurrentUser().Id,
});
}
dbcontext.SaveChanges();
result.Success = true;
result.Message = "Comments added successfully ";
}
}
catch (Exception ex)
{
result.Success = false;
result.Message = "Unable to Save Record!";
result.Exception = ex;
}
return(result);
}
public DbActionResult <IssueManagementCommentLog> Post(IssueManagementCommentLog items)
{
var result = new DbActionResult <IssueManagementCommentLog>();
bool EFlag = false;
string EmailTo = "";
string AncEmail = "";
string EmailCC = "";
string AnchorName = "";
try
{
var data = items;
string[] emailRegex = { "-", "<", ">", ";", "'" };
for (var i = 0; i < emailRegex.Length; i++)
{
if (data.ID_Comments != null)
{
data.ID_Comments = data.ID_Comments.Replace(emailRegex[i], " ");
}
}
var csc = new CSC();
using (var dbcontext = new Teckraft.Data.Sql.InitiativeHubFinalEntities())
{
//var chap = dbcontext.ChapterMasters.FirstOrDefault(it => it.ChapterNameFromSystem == data.id_System_Name && it.EmailFlag == true);
//if (chap != null)
//{
// data.id_System_Name = chap.ChapterNameFromSystem;
// EFlag = chap.EmailFlag.Value;
// EmailTo = chap.EmailTo;
//}
var chap1 = dbcontext.ChapterMasters.FirstOrDefault(it => it.ChapterNameFromSystem == data.id_System_Name);
if (chap1 != null)
{
if (chap1.ChapterNameFromSystem == "Dealer Feedback" || chap1.ChapterNameFromSystem == "WSS Service Cell" || chap1.ChapterNameFromSystem == "MyPidilite" || chap1.ChapterNameFromSystem == "Customer Service Cell")
{
var em = dbcontext.ChapterMasters.FirstOrDefault(o => o.ChapterNameFromSystem == data.id_System_Name);
EmailCC = em.EmailCC;
AncEmail = em.EmailTo;
}
else
{
string AncData = dbcontext.ChapterOwnerMappings.FirstOrDefault(it => it.ChapterId == chap1.Id).ChapterOwner.ToString();
AncEmail = dbcontext.UserDetails.FirstOrDefault(p => p.UserName == AncData).Email.ToString();
}
//for getting Anchor Name
var q = (from pd in dbcontext.ChapterOwnerMappings
join od in dbcontext.UserDetails on pd.ChapterOwner equals od.UserName
where pd.ChapterId == chap1.Id
select new
{
od.Title,
}).FirstOrDefault();
if (q != null)
{
AnchorName = q.Title;
}
}
if (items.id_System_Name == "Customer Service Cell")
{
var cs = dbcontext.GetCSCDataBYRequestNo(items.ID_Request).FirstOrDefault();
csc.ContactEmail = cs.ContactEmail;
csc.ContactNo = cs.contactNo;
}
}
data.RCB = _userservice.GetCurrentUser();
data = IssueService.Add(data);
//if (EFlag == true) {
// if (data.EmailFlag == true && EmailTo != null) {
// var tmplt1 = templateService.GetTemplateforComments(data);
// // emailService.SendEmail(tmplt1, "*****@*****.**", EmailTo, "", "");
// emailService.SendEmail(tmplt1, "*****@*****.**", EmailTo, "*****@*****.**", "");
// }
//}
var tmplt1 = templateService.GetTemplateforAnchor(data, AnchorName, csc);
//emailService.SendEmail(tmplt1, "[email protected] ", "*****@*****.**","", "");
if (tmplt1.Subject != "")
{
//emailService.SendEmail(tmplt1, "[email protected] ", "*****@*****.**", "", "");
emailService.SendEmail(tmplt1, "[email protected] ", AncEmail, EmailCC, "");
}
result.Success = true;
result.Message = "Comments added successfully";
}
catch (Exception ex)
{
result.Success = false;
result.Message = "Unable to Save Record!";
result.Exception = ex;
}
return(result);
}
