/// <summary>
/// check if reqeust staus is pending than not allow to add request for same card holder.
/// </summary>
private bool CheckPendingComplaint()
{
btnSubmit.Attributes.Add("class", "button");
CardHolderComplaintManager objCardHolderComplaintManager = new CardHolderComplaintManager();
CH_Complaint_DtlDTO objCH_Complaint_DtlDTO = new CH_Complaint_DtlDTO();
objCH_Complaint_DtlDTO.CardHolder_Id = CardHolderManager.GetLoggedInUser().CardHolder_Id;
objCH_Complaint_DtlDTO.ComplaintType_Id = Convert.ToInt32(ddlAppropRequestComplaint.SelectedValue);
objCH_Complaint_DtlDTO.Complaint_Status = DEFAULT_STATUS;
int PendingCount = objCardHolderComplaintManager.CheckComplaintPending(objCH_Complaint_DtlDTO);
if (PendingCount > 0)
{
btnSubmit.Enabled = false;
btnSubmit.Attributes.Add("class", "buttonDisble");
EnableDisableControl(false);
return(false);
}
else
{
btnSubmit.Enabled = true;
EnableDisableControl(true);
lblMessage.Text = string.Empty;
DivMessage.Attributes.CssStyle.Add("display", "none");
return(true);
}
}
//public CH_ComplaintType_MstDTO getCHComplaintTypeById(long ComplaintType_Id)
//{
// CH_ComplaintType_MstDTO objToReturn = new CH_ComplaintType_MstDTO();
// CH_ComplaintType_Mst obj = repCH_ComplaintType_Mst.SingleOrDefault(c => c.ComplaintType_Id == ComplaintType_Id);
// if (obj != null && obj.ComplaintType_Id == ComplaintType_Id)
// {
// objToReturn.ComplaintType_Id = obj.ComplaintType_Id;
// objToReturn.ComplaintType_nm = obj.ComplaintType_nm;
// objToReturn.ComplaintType_Desc = obj.ComplaintType_Desc;
// objToReturn.Department = obj.Dept_Mst.Dept_nm;
// objToReturn.Dept_Id = obj.Dept_Id;
// objToReturn.Created_by = obj.Created_by;
// objToReturn.Created_dt = obj.Created_dt;
// objToReturn.Updated_by = obj.Updated_by;
// objToReturn.Updated_dt = obj.Updated_dt;
// objToReturn.IP_Address = obj.IP_Address;
// }
// return objToReturn;
//}
//public bool CheckComplaintTypeExist(string ComplaintType_nm, long ComplaintType_Id = 0)
//{
// if (ComplaintType_Id != 0)
// {
// return repCH_ComplaintType_Mst.Find(c => c.ComplaintType_nm == ComplaintType_nm && c.ComplaintType_Id != ComplaintType_Id).Count() > 0;
// }
// else
// {
// return repCH_ComplaintType_Mst.Find(c => c.ComplaintType_nm == ComplaintType_nm).Count() > 0;
// }
//}
//#region Data Modification Methods
//public long SaveComplaintType(CH_ComplaintType_MstDTO objComplaintType_MstDTO)
//{
// CH_ComplaintType_Mst obj = repCH_ComplaintType_Mst.SingleOrDefault(c => c.ComplaintType_Id == objComplaintType_MstDTO.ComplaintType_Id);
// if (obj == null || obj.ComplaintType_Id != objComplaintType_MstDTO.ComplaintType_Id)
// {
// obj = new CH_ComplaintType_Mst();
// }
// obj.ComplaintType_nm = objComplaintType_MstDTO.ComplaintType_nm;
// obj.ComplaintType_Desc = objComplaintType_MstDTO.ComplaintType_Desc;
// obj.Dept_Id = objComplaintType_MstDTO.Dept_Id;
// obj.IP_Address = objComplaintType_MstDTO.IP_Address;
// if (obj.ComplaintType_Id == 0)
// {
// obj.Created_by = objComplaintType_MstDTO.Created_by;
// obj.Created_dt = objComplaintType_MstDTO.Created_dt;
// }
// obj.Updated_by = objComplaintType_MstDTO.Updated_by;
// obj.Updated_dt = objComplaintType_MstDTO.Updated_dt;
// if (obj.ComplaintType_Id == 0)
// {
// repCH_ComplaintType_Mst.Add(obj);
// }
// GeneralManager.Commit();
// return objComplaintType_MstDTO.ComplaintType_Id;
//}
//public bool DeleteCHComplaintType(long ComplaintType_Id)
//{
// bool rvalue = false;
// repCH_ComplaintType_Mst.Delete(c => c.ComplaintType_Id == ComplaintType_Id);
// GeneralManager.Commit();
// return rvalue;
//}
//#endregion Data Modification Methods
/// <summary>
/// Find Complaint By Primary Key Complaint_Dtl_Id
/// </summary>
/// <param name="Complaint_Dtl_Id"></param>
/// <returns></returns>
//public CH_Complaint_DtlDTO FindComplaintDetail(long Complaint_Dtl_Id)
//{
// CH_Complaint_DtlDTO Compl_detail = repCH_Complaint_Dtl.Find(c => c.Complaint_Dtl_Id == Complaint_Dtl_Id).Select(
// x => new CH_Complaint_DtlDTO()
// {
// Complaint_Dtl_Id = x.Complaint_Dtl_Id,
// Complaint_Dt = x.Complaint_Dt,
// CardHolder_Id = x.CardHolder_Id,
// ComplaintType_Id = x.ComplaintType_Id,
// IP_Address = x.IP_Address,
// Remarks = x.Remarks,
// Complaint_Status = x.Complaint_Status,
// Created_by = x.Created_by,
// Created_dt = x.Created_dt,
// Updated_by = x.Updated_by,
// Updated_dt = x.Updated_dt,
// UID = x.UID,
// }
// ).Single();
// return Compl_detail;
//}
#endregion
public int CheckComplaintPending(CH_Complaint_DtlDTO objCH_Complaint_DtlDTO)
{
int count = 0;
IQueryable <CH_Complaint_Dtl> repCH_Complaint_Dtl = ObjectFactory.GetInstance <IRepository <CH_Complaint_Dtl> >().GetQuery();
var Complaint_list = (from a in repCH_Complaint_Dtl
where a.CardHolder_Id == objCH_Complaint_DtlDTO.CardHolder_Id &&
a.Complaint_Status == objCH_Complaint_DtlDTO.Complaint_Status &&
a.ComplaintType_Id == objCH_Complaint_DtlDTO.ComplaintType_Id
select a).ToList();
if (Complaint_list != null && Complaint_list.Count > 0)
{
count = Complaint_list.Count;
}
return(count);
}
/// <summary>
/// Mailfunctions the specified request compliant DTL id.
/// </summary>
/// <param name="requestCompliantDtlId">The request compliant DTL id.</param>
/// <remarks></remarks>
private void Mailfunction(long requestCompliantDtlId)
{
var cdm = new CHRequestDetailManager();
var ChRequestDto = new CH_Request_DtlDTO();
var ccm = new CardHolderComplaintManager();
var ChComplaintDTO = new CH_Complaint_DtlDTO();
string EMAIL_Subject = string.Empty;
string CardHolderName = lblCardHolder.Text;
string Email = CardHolderManager.GetLoggedInUser().CH_Card.EMAIL_ID;
string RequestComplType = ddlAppropRequestComplaint.SelectedItem.Text;
string RequestComplaintDtl = txtremarks.Text;
string BOBMail = ConfigurationManager.AppSettings["BOB_EMAIL"];
// long cardHolderID = CardHolderManager.GetLoggedInUser().CardHolder_Id;
string OverRideEmail = ConfigurationManager.AppSettings["OverRideUserEmail"];
if (!string.IsNullOrEmpty(OverRideEmail))
{
Email = OverRideEmail;
}
try
{
var bodyString = new StringBuilder();
bodyString.Append(System.IO.File.ReadAllText(Server.MapPath("../") + Constants.OtherReqComplTemplatepath));
if (RadioRequestComplaint.SelectedValue == "1")
{
ChComplaintDTO = ccm.getComplaintUID(requestCompliantDtlId);
string ComplaintNumber = ChComplaintDTO.UID;
bodyString.Replace("Request Type", "Complaint Type");
//bodyString.Replace("Request Details", "Complaint Details");
bodyString.Replace("@@reqcom", "Complaint");
bodyString.Replace("@@ReqNum", ComplaintNumber);
EMAIL_Subject = ConfigurationManager.AppSettings["COMPLAINT_EMAIL_SUBJECT"].ToString();
}
else
{
ChRequestDto = cdm.getRequestUID(requestCompliantDtlId);
string RequestNumber = ChRequestDto.UID;
bodyString.Replace("@@reqcom", "Request");
bodyString.Replace("@@ReqNum", RequestNumber);
EMAIL_Subject = ConfigurationManager.AppSettings["REQUEST_EMAIL_SUBJECT"].ToString();
}
bodyString.Replace("@@CardHolderName", CardHolderName);
bodyString.Replace("@@Creditcard", lblCreditCardNumber.Text);
bodyString.Replace("@@RequestType", RequestComplType);
bodyString.Replace("@@RequestDetails", RequestComplaintDtl);
bodyString.Replace("@@ImagePath", UrlHelper.GetAbsoluteUri() + "/images/mailer-banner.jpg");
var CCemail = new List <string>();
long CardHolderId = CardHolderManager.GetLoggedInUser().CardHolder_Id;
bool IsMailSent = SendMailfunction.SendMail(BOBMail, new List <string>()
{
Email
}, CCemail, "", "", EMAIL_Subject, bodyString.ToString(), true, CardHolderId, null);
if (IsMailSent)
{
LblSuccessMessage.Text = "Your Request/Complaint has been successfully registered";
DivSuccess.Attributes.CssStyle.Add("display", "block");
}
else
{
LblErrorMessage.Text = Constants.ErrorMailButRqstLogged;
DivERROR.Attributes.CssStyle.Add("display", "block");
}
}
catch (Exception)
{
LblErrorMessage.Text = Constants.ErrorMailButRqstLogged;
DivERROR.Attributes.CssStyle.Add("display", "block");
}
}
/// <summary>
/// This method is used to save the complaint submitted by CardHolder
/// </summary>
/// <param name="objComplaint_DltDTO">The obj complaint_ DLT DTO.</param>
/// <returns></returns>
/// <remarks></remarks>
public long SaveComplaintDetail(CH_Complaint_DtlDTO objComplaint_DltDTO)
{
if (objComplaint_DltDTO.Complaint_Dtl_Id == 0)
{
BOBCardEntities _db = new BOBCardEntities();
var complaintDtl = _db.saveComplaintDtl(
objComplaint_DltDTO.Complaint_Dtl_Id,
objComplaint_DltDTO.Complaint_Dt,
objComplaint_DltDTO.CardHolder_Id,
objComplaint_DltDTO.ComplaintType_Id,
objComplaint_DltDTO.Remarks,
objComplaint_DltDTO.Complaint_Status,
objComplaint_DltDTO.Created_by,
objComplaint_DltDTO.Created_dt,
objComplaint_DltDTO.Updated_by,
objComplaint_DltDTO.Updated_dt,
objComplaint_DltDTO.IP_Address,
null,
null,
objComplaint_DltDTO.Created_dt.ToString("yyyyMMddHHmmssffff"),
objComplaint_DltDTO.AdminRemarks,
null,
null,
null
).ToList();
return((long)complaintDtl[0]);
}
else
{
CH_Complaint_Dtl obj = repCH_Complaint_Dtl.SingleOrDefault(c => c.Complaint_Dtl_Id == objComplaint_DltDTO.Complaint_Dtl_Id);
if (obj == null || obj.Complaint_Dtl_Id != objComplaint_DltDTO.Complaint_Dtl_Id)
{
obj = new CH_Complaint_Dtl();
}
obj.Complaint_Dt = objComplaint_DltDTO.Complaint_Dt;
obj.CardHolder_Id = objComplaint_DltDTO.CardHolder_Id;
obj.ComplaintType_Id = objComplaint_DltDTO.ComplaintType_Id;
obj.IP_Address = objComplaint_DltDTO.IP_Address;
obj.Remarks = objComplaint_DltDTO.Remarks;
obj.Complaint_Status = objComplaint_DltDTO.Complaint_Status;
obj.Remarks = objComplaint_DltDTO.Remarks;
if (obj.Complaint_Dtl_Id == 0)
{
obj.Created_by = objComplaint_DltDTO.Created_by;
obj.Created_dt = objComplaint_DltDTO.Created_dt;
obj.UID = objComplaint_DltDTO.Created_dt.ToString("yyyyMMddHHmmssffff");
}
obj.Updated_by = objComplaint_DltDTO.Updated_by;
obj.Updated_dt = objComplaint_DltDTO.Updated_dt;
if (obj.Complaint_Dtl_Id == 0)
{
repCH_Complaint_Dtl.Add(obj);
}
GeneralManager.Commit();
return(obj.Complaint_Dtl_Id);
}
}
