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; } }