public ApiResponse CreateContact(ContactMaster contact)
{
HttpResponseMessage responseMessage = Client.PostAsJsonAsync(url, contact).Result;
var responseData = CreateJsonResponse <ApiResponse>(responseMessage).Result;
return(responseData);
}
public ApiResponse EditContact(Int64 id, ContactMaster contact)
{
HttpResponseMessage responseMessage = Client.PutAsJsonAsync(url + "/" + id, contact).Result;
var responseData = CreateJsonResponse <ApiResponse>(responseMessage).Result;
return(responseData);
}
public async Task <ContactMaster> Edit(ContactMaster contactMaster)
{
try
{
using (IDbConnection con = Connection)
{
string sQuery = "ContactFunc";
con.Open();
DynamicParameters param = new DynamicParameters();
param.Add("@Mode", "EDIT");
param.Add("@Id", contactMaster.Id);
param.Add("@FirstName", contactMaster.FirstName);
param.Add("@LastName", contactMaster.LastName);
param.Add("@CompanyName", contactMaster.CompanyName);
param.Add("@JobTitle", contactMaster.JobTitle);
param.Add("@Email", contactMaster.Email);
param.Add("@Notes", contactMaster.Notes);
param.Add("@PhoneNo", contactMaster.PhoneNo);
var result = await con.QueryAsync <ContactMaster>(sQuery, param, commandType : CommandType.StoredProcedure);
return(result.FirstOrDefault());
}
}
catch (Exception ex)
{
throw ex;
}
}
public IHttpActionResult PutContactMaster(int id, ContactMaster contactMaster)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != contactMaster.ContactID)
{
return(BadRequest());
}
try
{
_contactRepo.UpdateContact(id, contactMaster);
}
catch (DbUpdateConcurrencyException)
{
if (!_contactRepo.ContactExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public async Task <ActionResult <ContactMaster> > Edit([FromBody] ContactMaster contactMaster)
{
if (contactMaster == null || !ModelState.IsValid)
{
return(BadRequest("Invalid State"));
}
return(await _contactMasterRepo.Edit(contactMaster));
}
public IHttpActionResult Create(ContactMaster contactToCreate)
{
_service.CreateContact(contactToCreate);
if (this.ModelState.IsValid)
{
return(Ok(contactToCreate));
}
return(BadRequest(this.ModelState));
}
public IHttpActionResult Edit(ContactMaster contactToEdit)
{
_service.EditContact(contactToEdit);
if (this.ModelState.IsValid)
{
return(Ok(contactToEdit));
}
return(BadRequest(this.ModelState));
}
public ActionResult Delete(Int64 id, ContactMaster contact)
{
var response = _manager.Delete(id, contact);
if (response)
{
return(RedirectToAction("Index"));
}
return(View("Delete"));
}
public bool Delete(Int64 id, ContactMaster contact)
{
HttpResponseMessage responseMessage = Client.DeleteAsync(url + "/" + id).Result;
if (responseMessage.IsSuccessStatusCode)
{
return(true);
}
return(false);
}
public IHttpActionResult GetContactMaster(int id)
{
ContactMaster contactMaster = _contactRepo.GetContactbyID(id);
if (contactMaster == null)
{
return(NotFound());
}
return(Ok(contactMaster));
}
public ActionResult Create(ContactMaster contact)
{
var response = _manager.CreateContact(contact);
if (response.StatusIsSuccessful)
{
return(RedirectToAction("Index"));
}
AddResponseErrorsToModelState(response);
return(View("Create"));
}
public ActionResult Edit(Int64 id, ContactMaster contact)
{
var response = _manager.EditContact(id, contact);
if (response.StatusIsSuccessful)
{
return(RedirectToAction("Index"));
}
AddResponseErrorsToModelState(response);
return(View("Edit"));
}
public bool DeleteContact(ContactMaster contactToDelete)
{
try
{
_repository.DeleteContact(contactToDelete);
}
catch
{
return(false);
}
return(true);
}
public ContactMaster CreateContact(ContactMaster contactToCreate)
{
// Save new contact
try
{
_entities.ContactMasters.Add(contactToCreate);
_entities.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
return(contactToCreate);
}
public void CreateValidContact()
{
// Arrange
var contact = new ContactMaster();
_manager.Expect(s => s.CreateContact(contact)).Returns(true);
var controller = new ContactServiceController(_manager.Object);
// Act
var result = (IHttpActionResult)controller.Create(contact);
// Assert
Assert.AreEqual("Create", "Create");
}
// Contact methods
public bool ValidateContact(ContactMaster contactToValidate)
{
if (contactToValidate.FirstName == null || contactToValidate.FirstName.Trim().Length == 0)
{
_validationDictionary.AddError("FirstName", "First name is required.");
}
else if (contactToValidate.FirstName == null || contactToValidate.FirstName.Trim().Length > 50)
{
_validationDictionary.AddError("FirstName", "First name cannot be longer than 50 characters.");
}
if (contactToValidate.LastName == null || contactToValidate.LastName.Trim().Length == 0)
{
_validationDictionary.AddError("LastName", "Last name is required.");
}
else if (contactToValidate.LastName == null || contactToValidate.LastName.Trim().Length > 50)
{
_validationDictionary.AddError("LastName", "Last name cannot be longer than 50 characters.");
}
if (contactToValidate.Phone == null || contactToValidate.Phone.Trim().Length == 0)
{
_validationDictionary.AddError("Phone", "Phone is required.");
}
else if (contactToValidate.Phone == null || contactToValidate.Phone.Length > 0 && !Regex.IsMatch(contactToValidate.Phone, @"^(\+\d{1,3}[- ]?)?\d{10}$"))
{
_validationDictionary.AddError("Phone", "Invalid phone number.");
}
else if (contactToValidate.Phone == null || contactToValidate.Phone.Trim().Length > 20)
{
_validationDictionary.AddError("Phone", "Phone cannot be longer than 20 characters.");
}
if (contactToValidate.Email == null || contactToValidate.Email.Trim().Length == 0)
{
_validationDictionary.AddError("Email", "Email is required.");
}
else if (contactToValidate.Email == null || contactToValidate.Email.Length > 0 && !Regex.IsMatch(contactToValidate.Email, @"^[\w-\.]+@([\w-]+\.)+[\w-]{2,4}$"))
{
_validationDictionary.AddError("Email", "Invalid email address.");
}
else if (contactToValidate.Email == null || contactToValidate.Email.Trim().Length > 150)
{
_validationDictionary.AddError("Email", "Email cannot be longer than 150 characters.");
}
return(_validationDictionary.IsValid);
}
public void DeleteContact(ContactMaster contactToDelete)
{
try
{
var originalContact = GetContact(contactToDelete.ID);
if (originalContact != null)
{
_entities.ContactMasters.Remove(contactToDelete);
}
_entities.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
protected void gvContacts_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
GridViewRow row = (GridViewRow)gvContacts.Rows[e.RowIndex];
Label lblCntMsgId = (Label)row.FindControl("lblContactMsgId");
TextBox txtReplayMsg = (TextBox)row.FindControl("txtReplay");
int iContactMsg = Convert.ToInt32(lblCntMsgId.Text);
var LoginUser = (User)Session["LoginUser"];
string strLoginUser = LoginUser.U_USERNAME;
ContactMaster objUpdateCM = db.ContactMasters.Where(aa => aa.CM_ID == iContactMsg && aa.CM_IsActive == "Y").SingleOrDefault();
if (objUpdateCM != null)
{
objUpdateCM.CM_AdminMessage = txtReplayMsg.Text;
objUpdateCM.ReplayDate = DateTime.Now;
objUpdateCM.MUSER = strLoginUser;
objUpdateCM.MDATE = DateTime.Now.ToString("yyyyMMddHHmmss");
db.SaveChanges();
var userMailID = "*****@*****.**";
var mailPassword = "******";
var subject = "Reg: ESMS Contact form";
var message = "Hi " + objUpdateCM.CM_FullName + " , " + txtReplayMsg.Text;
SmtpClient sc = new SmtpClient("smtp.gmail.com", 25);
NetworkCredential nc = new NetworkCredential(userMailID, mailPassword);
MailMessage mm = new MailMessage(userMailID, objUpdateCM.CM_Email, subject, message);
sc.EnableSsl = true;
sc.Credentials = nc;
sc.Send(mm);
gvContacts.EditIndex = -1;
LoadAllContactMessages();
}
else
{
}
}
catch (Exception ee)
{
}
}
public bool EditContact(ContactMaster contactToEdit)
{
// Validation logic
if (!ValidateContact(contactToEdit))
{
return(false);
}
// Database logic
try
{
_repository.EditContact(contactToEdit);
}
catch
{
return(false);
}
return(true);
}
public ContactMaster EditContact(ContactMaster contactToEdit)
{
try
{
// Get original contact
var originalContact = GetContact(contactToEdit.ID);
// Save changes
if (originalContact != null)
{
_entities.Entry(originalContact).CurrentValues.SetValues(contactToEdit);
}
_entities.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
return(contactToEdit);
}
public ContactMaster GetAllContactDetails()
{
try
{
ContactMaster ContactMaster = new ContactMaster()
{
ContactAddresses = unitOfWork.ContactAddress.GetAll(),
ContactDetails = unitOfWork.ContactDetails.GetAll()
};
return ContactMaster;
}
catch (Exception ex)
{
return null;
}
finally
{
unitOfWork.Dispose();
}
}
protected void submitButton_Click(object sender, EventArgs e)
{
try
{
ContactMaster objNewCM = new ContactMaster();
objNewCM.CM_FullName = nameTextBox.Text;
objNewCM.CM_PhoneNumber = phoneTextBox.Text;
objNewCM.CM_Email = emailTextBox.Text;
objNewCM.CM_Message = messageTextBox.Text;
objNewCM.PostDate = DateTime.Now;
objNewCM.CDATE = DateTime.Now.ToString("yyyyMMddHHmmss");
objNewCM.CUSER = nameTextBox.Text;
objNewCM.CM_IsActive = "Y";
db.ContactMasters.Add(objNewCM);
db.SaveChanges();
var userMailID = "*****@*****.**";
var mailPassword = "******";
var subject = "Reg: ESMS Contact form";
var message = "Thank you " + nameTextBox.Text + " for contacting us. our team will reach you with in 24hours time. \n Your message: " + messageTextBox.Text;
SmtpClient sc = new SmtpClient("smtp.gmail.com", 25);
NetworkCredential nc = new NetworkCredential(userMailID, mailPassword);
MailMessage mm = new MailMessage(userMailID, emailTextBox.Text, subject, message);
sc.EnableSsl = true;
sc.Credentials = nc;
sc.Send(mm);
resultLabel.Text = "Thank you " + nameTextBox.Text + " for contacting us. Our team will get back to you asap.";
ClearAllTextboxes();
}
catch (Exception ee)
{
resultLabel.Text = ee.Message;
}
}
public bool Put(ContactMaster contactMaster)
{
ContactMasterRepository contact = new ContactMasterRepository();
return(contact.Put(contactMaster));
}
public IHttpActionResult PostContactMaster(ContactMaster contactMaster)
{
_contactRepo.InsertContact(contactMaster);
return(CreatedAtRoute("DefaultApi", new { id = contactMaster.ContactID }, contactMaster));
}
private void Contact_Click(object sender, RoutedEventArgs e)
{
ContactMaster contactMaster = new ContactMaster();
contactMaster.ShowDialog();
}
public IHttpActionResult DeleteContactMaster(int id)
{
ContactMaster contactMaster = _contactRepo.DeleteContact(id);
return(Ok(contactMaster));
}
