public BaseApiResponse RemoveCallBackFromNote(OrderPartNoteEntity modal)
{
string OrderIdsWithPartIdsXML = ConvertToXml <OrderIdsPartIds> .GetXMLString(modal.OrderIdPartIdList);
var response = new BaseApiResponse();
try
{
//Guid UserId = new Guid(modal.UserId);
SqlParameter[] param = { new SqlParameter("UserId", (object)modal.UserId ?? (object)DBNull.Value)
, new SqlParameter("OrderIdsWithPartIdsXML", (object)OrderIdsWithPartIdsXML ?? (object)DBNull.Value) };
var result = _repository.ExecuteSQL <int>("RemoveCallBackForSelected", param).FirstOrDefault();
if (result == 1)
{
response.Success = true;
}
else
{
response.Success = false;
}
}
catch (Exception ex)
{
response.Message.Add(ex.Message);
}
return(response);
}
public BaseApiResponse InsertOrderPartNotes(OrderPartNoteEntity modal)
{
string OrderIdsWithPartIdsXML = ConvertToXml <OrderIdsPartIds> .GetXMLString(modal.OrderIdPartIdList);
CompanyDetailForEmailEntity objCompany = CommonFunction.CompanyDetailForEmailByOrderNo(Convert.ToString(modal.OrderId));
var response = new BaseApiResponse();
try
{
Guid UserId = new Guid(modal.UserId);
SqlParameter[] param = { new SqlParameter("OrderId", (object)modal.OrderId ?? (object)DBNull.Value)
, new SqlParameter("PartNo", (object)modal.PartNo ?? (object)DBNull.Value)
, new SqlParameter("NotesClient", (object)modal.NotesClient ?? (object)DBNull.Value)
, new SqlParameter("NotesInternal", (object)modal.NotesInternal ?? (object)DBNull.Value)
, new SqlParameter("CallBack", (object)modal.CallBack ?? (object)DBNull.Value)
, new SqlParameter("CanDate", (object)modal.CanDate ?? (object)DBNull.Value)
, new SqlParameter("DueDate", (object)modal.DueDate ?? (object)DBNull.Value)
, new SqlParameter("EntDate", (object)modal.EntDate ?? (object)DBNull.Value)
, new SqlParameter("FirstCall", (object)modal.FirstCall ?? (object)DBNull.Value)
, new SqlParameter("HoldDate", (object)modal.HoldDate ?? (object)DBNull.Value)
, new SqlParameter("NRDate", (object)modal.NRDate ?? (object)DBNull.Value)
, new SqlParameter("OrdDate", (object)modal.OrdDate ?? (object)DBNull.Value)
, new SqlParameter("AuthRecDate", (object)modal.AuthRecDate ?? (object)DBNull.Value)
, new SqlParameter("PartStatusId", (object)modal.PartStatusId ?? (object)DBNull.Value)
, new SqlParameter("AssgnTo", (object)modal.AssgnTo ?? (object)DBNull.Value)
, new SqlParameter("InternalStatusId", (object)modal.InternalStatusId ?? (object)DBNull.Value)
, new SqlParameter("InternalStatusText", (object)modal.InternalStatusText ?? (object)DBNull.Value)
, new SqlParameter("UserId", (object)UserId ?? (object)DBNull.Value)
, new SqlParameter("PageFrom", (object)modal.PageFrom ?? (object)DBNull.Value)
, new SqlParameter("OrderIdsWithPartIdsXML", (object)OrderIdsWithPartIdsXML ?? (object)DBNull.Value) };
var result = _repository.ExecuteSQL <int>("InsertOrderPartNotes", param).FirstOrDefault();
SqlParameter[] paramAuth = { new SqlParameter("Orderno", (object)modal.OrderId ?? (object)DBNull.Value)
, new SqlParameter("PartNo", (object)modal.PartNo ?? (object)DBNull.Value)
, new SqlParameter("Status", (object)modal.AssgnTo ?? (object)DBNull.Value) };
var resultAuth = _repository.ExecuteSQL <int>("AuthorizationToBeCalledInsert", paramAuth).FirstOrDefault();
if (result == 1)
{
if (!string.IsNullOrEmpty(modal.RoleName) && modal.RoleName == "Attorney")
{
string accExecutiveName = string.Empty;
string accExecutiveEmail = string.Empty;
SqlParameter[] param1 = { new SqlParameter("UserId", (object)UserId ?? (object)DBNull.Value) };
var MailDetail = _repository.ExecuteSQL <AccountExecutive>("GetClientAcctExec", param1).FirstOrDefault();
if (MailDetail != null)
{
accExecutiveName = Convert.ToString(MailDetail.Name);
accExecutiveEmail = Convert.ToString(MailDetail.Email);
}
else
{
accExecutiveName = "Leah Boroski";
accExecutiveEmail = "*****@*****.**";
}
string subject = "Client Note Added " + Convert.ToString(modal.OrderId) + "-" + Convert.ToString(modal.PartNo);
System.Text.StringBuilder htmlBody = new System.Text.StringBuilder();
htmlBody.Append(@"<!DOCTYPE html><html xmlns='http://www.w3.org/1999/xhtml'><head><title></title><style>table, th, td {border: 1px solid gray;font-family:Verdana;}</style></head>");
htmlBody.Append(@"<body style='font-family:Verdana;'>");
htmlBody.Append(@"##MESSAGE##");
htmlBody.Append(@"<table align='left' style='width:650px;'cellpadding='5' cellspacing='0'>");
htmlBody.Append(@"<tr><td align='right' style='width:120px;'><b>Order No :</b></td><td>##ORDERNO##</td></tr>");
htmlBody.Append(@"<tr><td align='right'><b>Note :</b></td><td>##NOTE##</td></tr>");
htmlBody.Append(@"</table></body></html>");
htmlBody.Replace("##MESSAGE##", accExecutiveName + ", <br />Client has added new note.<br /><br />");
htmlBody.Replace("##ORDERNO##", modal.OrderId + "-" + modal.PartNo);
htmlBody.Replace("##NOTE##", modal.NotesClient);
EmailHelper.Email.Send(CompanyNo: objCompany.CompNo
, mailTo: accExecutiveEmail
, body: htmlBody.ToString()
, subject: subject
, ccMail: ""
, bccMail: "[email protected],[email protected]");
}
response.Success = true;
response.InsertedId = result;
}
else
{
response.Success = false;
}
}
catch (Exception ex)
{
response.Message.Add(ex.Message);
}
return(response);
}
