/// <summary> /// Save Customer Complaint /// </summary> /// <param name="consumer_ID"></param> /// <param name="email"></param> /// <param name="concern"></param> /// <returns></returns> public int SaveCustomerComplaint(int consumer_ID, string email, string concern) { try { tblCustomerSupport customerSupportObj = new tblCustomerSupport(); if (consumer_ID > 0 && email != string.Empty && concern != string.Empty) { customerSupportObj.Consumer_ID = consumer_ID; customerSupportObj.Email = email; customerSupportObj.Concern = concern; customerSupportObj.ResolvedMessage = string.Empty; customerSupportObj.IsResolved = false; customerSupportObj.RaisedDate = DateTime.Now; customerSupportObj.ResolvedDate = new DateTime(1900, 01, 01); customerSupportObj.Severity = 0; db.tblCustomerSupports.Add(customerSupportObj); db.SaveChanges(); } return(customerSupportObj.ID > 0 ? customerSupportObj.ID : 0); } catch { return(0); } }
public bool ResolveCustomerSupportIssue([FromUri] int ID, [FromUri] string resolvedMessage, [FromUri] string consumerName, [FromUri] string consumerEmail) { try { if (ID > 0 && resolvedMessage != string.Empty) { tblCustomerSupport customerSupportObj = db.tblCustomerSupports.Where(x => x.ID == ID).FirstOrDefault(); { customerSupportObj.ResolvedMessage = resolvedMessage; customerSupportObj.IsResolved = true; customerSupportObj.ResolvedDate = DateTime.Now; customerSupportObj.Severity = 0; db.Entry(customerSupportObj).State = EntityState.Modified; db.SaveChanges(); } EmailParameters param = new EmailParameters() { ID = ID, fromEmailAddress = "*****@*****.**", toEmailAddress = consumerEmail, consumerName = consumerName, resolvedMessage = resolvedMessage }; SendEmail.TriggerMail(param); return(true); } } catch { return(false); } return(false); }