public int insertContactUs(ContactUsModel Model)
{
ContactUsEntity ENTITY = new ContactUsEntity();
ManagementObjectMapper objMapper = new ManagementObjectMapper();
ServiceLayer.ManagementService ManObj = new ManagementService();
ENTITY = objMapper.MapContactUsModelToContactUsEntity(Model);
return(ManObj.insertContactUs(ENTITY));
}
internal ContactUsEntity MapContactUsModelToContactUsEntity(ContactUsModel Model)
{
ContactUsEntity Entity = new ContactUsEntity();
if (Model != null)
{
Entity.PhoneNumber = Model.PhoneNumber;
Entity.Subject = Model.Subject;
Entity.Description = Model.Description;
}
return(Entity);
}
public int insertContactUs(ContactUsEntity ENTITY)
{
int Success = 0;
try
{
using (DbCommand objDbCommand = DBAccessHelper.GetDBCommand(ConnectionManager.DatabaseToConnect.RaiteRajuDefaultInstance, StoredProcedures.SPInsertContactUs))
{
DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamPhoneNumber, DbType.Int64, ENTITY.PhoneNumber);
DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.PARAMSubject, DbType.String, ENTITY.Subject);
DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.PARAMDescription, DbType.String, ENTITY.Description);
Success = DBAccessHelper.ExecuteNonQuery(objDbCommand);
}
return(Success);
}
catch (Exception ex)
{
ExceptionLoggin("ManagementDal", "insertContactUs", ex.Message);
return(0);
}
}
public async Task <HttpResponseMessage> SaveContactInformation()
{
try
{
if (!Request.Content.IsMimeMultipartContent())
{
throw new HttpResponseException(HttpStatusCode.UnsupportedMediaType);
}
var root = HttpContext.Current.Server.MapPath("~/ContactUsAttachment");
Directory.CreateDirectory(root);
var provider = new MultipartFormDataStreamProvider(root);
var result = await Request.Content.ReadAsMultipartAsync(provider);
var contactId = result.FormData["ContactUsId"];
if (contactId == null)
{
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
ContactUsEntity objContactUsEntity = new ContactUsEntity();
objContactUsEntity.ContactUsId = Convert.ToInt32(result.FormData["ContactUsId"].ToString());
objContactUsEntity.Name = result.FormData["Name"].ToString();
objContactUsEntity.PhoneNumber = result.FormData["PhoneNumber"].ToString();
objContactUsEntity.EmailAddress = result.FormData["EmailAddress"].ToString();
objContactUsEntity.City = result.FormData["City"].ToString();
objContactUsEntity.Company = result.FormData["Company"].ToString();
objContactUsEntity.Message = result.FormData["Message"].ToString();
var contactusId = _unitOfWork.SQLStringReturn("EXEC SaveContactInformation @Name,@PhoneNumber,@EmailAddress,@City,@Company,@Message", new SqlParameter[]
{
new SqlParameter("@Name", objContactUsEntity.Name),
new SqlParameter("@PhoneNumber", objContactUsEntity.PhoneNumber),
new SqlParameter("@EmailAddress", objContactUsEntity.EmailAddress),
new SqlParameter("@City", objContactUsEntity.City),
new SqlParameter("@Company", objContactUsEntity.Company),
new SqlParameter("@Message", objContactUsEntity.Message)
});
if (Convert.ToInt32(contactusId) > 0)
{
HttpFileCollection uploadedFiles = HttpContext.Current.Request.Files;
for (int i = 0; i < uploadedFiles.Count; i++)
{
HttpPostedFile file = uploadedFiles[i];
if (file.ContentLength > 0)
{
string fileExtension = Path.GetExtension(file.FileName);
string fileName = objContactUsEntity.Name.Replace(" ", "_") + Guid.NewGuid() + fileExtension;
file.SaveAs(root + "\\" + fileName);
var attachmentId = _unitOfWork.SQLStringReturn("EXEC SaveContactUsAttchments @ContactUsId,@Path", new SqlParameter[]
{
new SqlParameter("@ContactUsId", contactusId),
new SqlParameter("@Path", fileName)
});
}
}
string AdminMail = System.Configuration.ConfigurationManager.AppSettings["ContactUsEmailId"];
string bodyAdminTemplate = System.IO.File.ReadAllText(System.Web.Hosting.HostingEnvironment.MapPath("~/EmailTemplate/AdminContactUs.html"));
bodyAdminTemplate = bodyAdminTemplate.Replace("[@Name]", objContactUsEntity.Name);
bodyAdminTemplate = bodyAdminTemplate.Replace("[@Email]", objContactUsEntity.EmailAddress);
bodyAdminTemplate = bodyAdminTemplate.Replace("[@Mobile]", objContactUsEntity.PhoneNumber);
bodyAdminTemplate = bodyAdminTemplate.Replace("[@company]", objContactUsEntity.Company);
bodyAdminTemplate = bodyAdminTemplate.Replace("[@Message]", objContactUsEntity.Message);
Task Admintask = new Task(() => Email.Send(AdminMail, bodyAdminTemplate, "Contact us inquiry from " + objContactUsEntity.Name, "", null));
Admintask.Start();
}
return(Request.CreateResponse(HttpStatusCode.OK, "success!"));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
public int insertContactUs(ContactUsEntity ENTITY)
{
return(new DAL.ManagementDAL().insertContactUs(ENTITY));
}
public int insertContactUs(ContactUsEntity ENTITY)
{
ManagementBusinessLayerInterface ManageObj = new BusinessLayer.ManagementBusinessLayer();
return(ManageObj.insertContactUs(ENTITY));
}
