public IHttpActionResult PosttblContact(tblContact tblContact)
{
db.tblContacts.Add(tblContact);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = tblContact.ContactID }, tblContact));
}
public ActionResult SendEmail(tblContact model)
{
model.Date = DateTime.Now;
_db.tblContact.Add(model);
_db.SaveChanges();
return(Json(JsonRequestBehavior.AllowGet));
}
private static async Task UpdateContacts(List <CandidateContactModel> candidateContact, tblCandidate Candidate)
{
int x = 0;
tblContact contact = null;
using (db = new eMSPEntities())
{
await db.tblCandidateContacts.Where(a => a.CandidateID == Candidate.ID).ForEachAsync(a => { a.IsActive = false; a.IsDeleted = true; });
await Task.Run(() => db.SaveChangesAsync());
if (candidateContact.Count > 0)
{
foreach (CandidateContactModel c in candidateContact)
{
contact = await Task.Run(() => InsertContacts(c.ConvertTotblContact()));
x = await Task.Run(() => InsertCandidateContacts(Candidate, contact, c.IsPrimary));
}
}
//return model;
}
}
public JsonResult AddForContact(tblContact tblContact)
{
//return null;
try
{
if (tblContact != null)
{
if (string.IsNullOrEmpty(tblContact.Name) && string.IsNullOrEmpty(tblContact.Email) && string.IsNullOrEmpty(tblContact.Mobile) &&
string.IsNullOrEmpty(tblContact.Message) && string.IsNullOrEmpty(tblContact.Country) && string.IsNullOrEmpty(tblContact.Subject))
{
return(Json("AllFieldsRequired", JsonRequestBehavior.AllowGet));
}
db = new CourseDataContext();
tblContact.DateCreated = DateTime.Now;
tblContact.CreatedBy = tblContact.Name;
tblContact.IsPublished = true;
db.tblContacts.InsertOnSubmit(tblContact);
db.SubmitChanges();
SendOTPForEnqueryContactFAQ(tblContact.Name, tblContact.Email, "Contact", "ContactRes");
return(Json(tblContact.ContactId, JsonRequestBehavior.AllowGet));
}
return(Json("Failed", JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
throw ex;
}
}
public static CandidateContactModel ConvertToCandidateContactModel(this tblContact data, bool isPrimary = false)
{
return(new CandidateContactModel()
{
FirstName = data.FirstName,
LastName = data.LastName,
EmailAddress = data.EmailAddress,
City = data.City,
CountyID = data.CountyID.ToString(),
Country = data.tblCountry != null ? data.tblCountry.Name : "",
State = data.tblCountryState != null ? data.tblCountryState.Name : "",
ID = Convert.ToInt32(data.ID),
StateID = data.StateID.ToString(),
MobileNumber = data.MobileNumber,
StreetAddress = data.StreetAddress,
ZipCode = data.ZipCode,
isActive = data.IsActive,
isDeleted = data.IsDeleted,
createdUserID = data.CreatedUserID,
updatedUserID = data.UpdatedUserID,
createdTimestamp = data.CreatedTimestamp,
updatedTimestamp = data.UpdatedTimestamp,
IsPrimary = isPrimary
});
}
public tblContact GetContact(int id)
{
tblContact Contact = dbc.tblContacts.FirstOrDefault(x => x.Id == id);
//return Contact;
return(Contact);
}
public ActionResult Action(tblContact objSubmit)
{
if (objSubmit.ID == 0)
{
objSubmit.DateCreated = DateTime.Now;
objSubmit.DateUpdated = DateTime.Now;
objSubmit.IsDeleted = false;
objSubmit.IsViewed = false;
contactRepository.Add(objSubmit);
}
else
{
var obj = contactRepository.GetById <tblContact>(objSubmit.ID);
UpdateModel(obj);
objSubmit.DateUpdated = DateTime.Now;
contactRepository.Update(obj);
}
return(Json(new
{
Error = false
}, JsonRequestBehavior.AllowGet));
}
public ActionResult create(Contact contact)
{
var cnt = new tblContact();
cnt.FirstName = contact.FirstName;
cnt.LastName = contact.LastName;
cnt.Status = contact.Status;
cnt.Email = contact.Email;
cnt.PhoneNumber = contact.PhoneNumber;
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(System.Configuration.ConfigurationManager.AppSettings["ContactApiUrl"]);
//HTTP POST
//var postTask = client.PostAsJsonAsync<tblContact>("AddContact", cnt);
var postTask = client.PostAsync <tblContact>("AddContact", cnt, new JsonMediaTypeFormatter());
postTask.Wait();
var result = postTask.Result;
if (result.IsSuccessStatusCode)
{
return(RedirectToAction("Index"));
}
}
ModelState.AddModelError(string.Empty, "Server Error. Please contact administrator.");
return(View(contact));
}
internal static async Task <int> InsertCandidateContacts(tblCandidate can, tblContact con, bool isPrimary)
{
try
{
using (db = new eMSPEntities())
{
var scandidate = db.tblCandidateContacts.Add(new tblCandidateContact
{
ContactID = con.ID,
CandidateID = can.ID,
IsActive = true,
IsDeleted = false,
CreatedTimestamp = can.CreatedTimestamp,
CreatedUserID = can.CreatedUserID,
UpdatedTimestamp = can.UpdatedTimestamp,
UpdatedUserID = can.UpdatedUserID,
IsPrimary = isPrimary
});
return(await Task.Run(() => db.SaveChangesAsync()));
}
}
catch (Exception)
{
throw;
}
}
public static string Insert(clsContact data, out Int32 newID)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
newID = -1;
try
{
tblContact oNewRow = new tblContact()
{
idContactType = data.idContactType,
idRequest = data.idRequest,
Name = data.Name,
Title = data.Title,
Phone = data.Phone,
Email = data.Email,
CreatedBy = data.CreatedBy,
CreatedOn = data.CreatedOn
};
puroTouchContext.GetTable <tblContact>().InsertOnSubmit(oNewRow);
puroTouchContext.SubmitChanges();
newID = oNewRow.idContact;
data.idRequest = newID;
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public IHttpActionResult PuttblContact(int id, tblContact tblContact)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tblContact.ContactID)
{
return(BadRequest());
}
db.Entry(tblContact).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!tblContactExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public tblContact Find(int id)
{
using (var dbcontext = new EvolentHealthEntities())
{
tblContact Contactobj = dbcontext.tblContacts.Find(id);
return(Contactobj);
}
}
public void Create(tblContact Contactobj)
{
using (var dbcontext = new EvolentHealthEntities())
{
dbcontext.tblContacts.Add(Contactobj);
dbcontext.SaveChanges();
}
}
// GET: ViewMessage/Delete/5
public ActionResult Delete(tblContact detailsToEdit)
{
var d = instance.tblContacts.Where(x => x.id == detailsToEdit.id).FirstOrDefault();
instance.tblContacts.Remove(d);
instance.SaveChanges();
return(RedirectToAction("displayMessage"));
}
public tblContact Edit(tblContact Contactobj)
{
using (var dbcontext = new EvolentHealthEntities())
{
dbcontext.Entry(Contactobj).State = EntityState.Modified;
dbcontext.SaveChanges();
return(Contactobj);
}
}
public void Delete(int id)
{
using (var dbcontext = new EvolentHealthEntities())
{
tblContact Contactobj = dbcontext.tblContacts.Find(id);
dbcontext.tblContacts.Remove(Contactobj);
dbcontext.SaveChanges();
}
}
public ActionResult Edit([Bind(Include = "Id,FirstName,LastName,Email,PhoneNumber,Status")] tblContact tblContact)
{
if (ModelState.IsValid)
{
contactsRepository.Edit(tblContact);
return(RedirectToAction("Index"));
}
return(View(tblContact));
}
public IHttpActionResult PosttblContact(tblContact tblContact)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.tblContacts.Add(tblContact);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = tblContact.ContactID }, tblContact));
}
public IEnumerable <tblContact> UpdateContact(tblContact tblcontact)
{
var contact = dbc.tblContacts.Where(x => x.Id == tblcontact.Id).FirstOrDefault();
contact.FirstName = tblcontact.FirstName;
contact.LastName = tblcontact.LastName;
contact.Email = tblcontact.Email;
contact.PhoneNumber = tblcontact.PhoneNumber;
contact.Status = tblcontact.Status;
dbc.SaveChanges();
return(dbc.tblContacts.ToList());
}
internal static async Task <CandidateCreateModel> Insert(CandidateCreateModel model)
{
try
{
int x = 0;
tblContact contact = null;
tblFile file = null;
tblCandidate candidate = await Task.Run(() => InsertCandidate(model.Candidate.ConvertTotblCandidate()));
x = await Task.Run(() => InsertSupplierCandidate(candidate, model.SupplierId));
if (model.CandidateContact.Count > 0)
{
foreach (CandidateContactModel a in model.CandidateContact)
{
contact = await Task.Run(() => InsertContacts(a.ConvertTotblContact()));
x = await Task.Run(() => InsertCandidateContacts(candidate, contact, a.IsPrimary));
}
}
if (model.CandidateFile.Count > 0)
{
foreach (FileModel a in model.CandidateFile)
{
file = await Task.Run(() => InsertFiles(a.ConvertTotblFile()));
x = await Task.Run(() => InsertCandidateFiles(candidate, file, Convert.ToInt64(a.FileTypeId), a.ExpiryDate));
}
}
if (model.CandidateIndustries != null)
{
x = await Task.Run(() => InsertCandidateIndustries(model.CandidateIndustries.Select(a => Convert.ToInt32(a)).ToList(), candidate));
}
if (model.CandidateSkills != null)
{
x = await Task.Run(() => InsertCandidateSkills(model.CandidateSkills.Select(a => Convert.ToInt32(a)).ToList(), candidate));
}
candidate = await Task.Run(() => Get(candidate.ID));
return(candidate.ConvertToCandidateCreateModel());
}
catch (Exception)
{
throw;
}
}
public bool AddContact(tblContact contact)
{
try
{
web365db.tblContact.Add(contact);
var result = web365db.SaveChanges();
return(result > 0);
}
catch (Exception)
{
return(false);
}
}
public ActionResult Subscribe(FormCollection fc)
{
var model = new tblContact()
{
Email = fc["ContactEmail"],
Name = fc["ContactName"],
Phone = fc["ContactPhone"],
Date = DateTime.Now,
};
_db.tblContact.Add(model);
_db.SaveChanges();
return(Json(JsonRequestBehavior.AllowGet));
}
public IHttpActionResult DeletetblContact(int id)
{
tblContact tblContact = db.tblContacts.Find(id);
if (tblContact == null)
{
return(NotFound());
}
db.tblContacts.Remove(tblContact);
db.SaveChanges();
return(Ok(tblContact));
}
// GET: Contacts/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblContact tblContact = contactsRepository.Find((int)id);
if (tblContact == null)
{
return(HttpNotFound());
}
return(View(tblContact));
}
public tblContact GetContactByID(int id)
{
tblContact a_contact = null;
try
{
a_contact = dbContext.tblContacts.Where(x => x.ContactID == id).SingleOrDefault();
}
catch (Exception e)
{
a_contact = null;
}
return(a_contact);
}
public ActionResult Index(FormCollection colletion)
{
tblContact tblcontact = new tblContact();
tblcontact.Name = colletion["txtName"];
tblcontact.Mobile = colletion["txtMobile"];
tblcontact.Address = colletion["txtAddress"];
tblcontact.Email = colletion["txtEmail"];
tblcontact.Content = colletion["txtDescription"];
db.tblContacts.Add(tblcontact);
db.SaveChanges();
ViewBag.favicon = " <link href=\"" + db.tblConfigs.First().Favicon + "\" rel=\"icon\" type=\"image/x-icon\" />";
ViewBag.status = "<script>$(document).ready(function(){ alert('Bạn đã liên hệ thành công. Vui lòng Check Mail để biết chi tiết !') });</script>";
return(View());
}
public JsonResult SendEmail(tblContact tbl)
{
try
{
tbl.PostedOn = DateTime.Now;
tblContact.Insert(tbl);
tblContact.Save();
return(Json(new{ latestdata = "Success" }));
}
catch (Exception ex)
{
Log.Error(ex.ToString());
}
return(null);
}
public void AddContact(tblContact contact)
{
try
{
_contact.contact_name = contact.contact_name;
_contact.contact_email = contact.contact_email;
_contact.contact_number = contact.contact_number;
_contact.customer_id = contact.customer_id;
dbContext.tblContacts.Add(_contact);
dbContext.SaveChanges();
}
catch (Exception exe)
{
string message = exe.Message;
}
}
public HttpResponseMessage SaveContact(tblContact a_contact)
{
int result = 0;
try
{
dbContext.tblContacts.Add(a_contact);
dbContext.SaveChanges();
result = 1;
}
catch (Exception e)
{
result = 0;
}
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
internal static async Task <tblContact> InsertContacts(tblContact model)
{
try
{
using (db = new eMSPEntities())
{
var contact = db.tblContacts.Add(model);
int x = await Task.Run(() => db.SaveChangesAsync());
return(contact);
}
}
catch (Exception)
{
throw;
}
}
