public ActionResult Search() { customerdbEntities2 entities = new customerdbEntities2(); return(View(entities.SearchCustomers("int CustomerId", "string LastName"))); }
public ActionResult EditTestingImage(int?id) { customerdbEntities2 db = new customerdbEntities2(); CustomerModel model = new CustomerModel(); if (id != null) { var Cusdet = db.GetCustomerdb(id).FirstOrDefault(); if (Cusdet != null) { model.CustomerId = Cusdet.CustomerId; model.FirstName = Cusdet.FirstName; model.LastName = Cusdet.LastName; model.Gender = Cusdet.Gender.Value; model.DoB = Cusdet.DoB; model.Email = Cusdet.Email; model.PhoneNumber = Cusdet.PhoneNumber; model.Address = Cusdet.Address; model.City = Cusdet.City; model.State = Cusdet.State; model.Pincode = Convert.ToInt32(Cusdet.Pincode); model.ImagePath = "~/CustomerImages/" + Cusdet.ImagePath; } } return(View("HtmlBeginForm", model)); }
public ActionResult FollowupMasterView(int id)//id=cust id { FollowUpModel model = new FollowUpModel(); try { List <FollowUpModel> cusDetailsList = new List <FollowUpModel>(); customerdbEntities2 db = new customerdbEntities2(); var cus = db.CustomerFollowUpsGet(null, id).ToList(); foreach (var item in cus) { cusDetailsList.Add(new FollowUpModel() { FollowUpDate = item.FollowUpDate.Value, FollowUpType = item.FollowUpType.Value, Comments = item.Comments, Status = item.Status.Value, NextFollowUpDate = item.NextFollowUpDate.Value, FollowUpId = item.FollowUpId, Cid = item.CustomerId.Value }); } model.cusDetailsList = cusDetailsList; var Details = db.GetCustomerdb(id).FirstOrDefault(); model.FirstName = Details.FirstName; } catch (Exception ex) { string error = ex.Message; } return(View(model)); }
public ActionResult StatusCustomerFollowup(FollowUpModel model, int id) { customerdbEntities2 db = new customerdbEntities2(); string message = string.Empty; string Statustext = string.Empty; bool status = false; if (model.Status > 0) { model.Status = 0; db.CustomerFollowUpsStatus(id, model.Status); message = "Status Opened."; Statustext = "Open"; status = true; } else { model.Status = 1; message = "Status Closed."; Statustext = "Closed"; status = true; } db.CustomerFollowUpsStatus(id, model.Status); return(Json(new { status = status, id = id, message = message, Statustext = Statustext })); }
public ActionResult EditCustomer(int?id) { customerdbEntities2 db = new customerdbEntities2(); CustomerModel model = new CustomerModel(); if (id != null) { var Cusdet = db.GetCustomerdb(id).FirstOrDefault(); if (Cusdet != null) { model.CustomerId = Cusdet.CustomerId; model.FirstName = Cusdet.FirstName; model.LastName = Cusdet.LastName; model.Gender = Cusdet.Gender.Value; model.DoB = Cusdet.DoB; model.Email = Cusdet.Email; model.PhoneNumber = Cusdet.PhoneNumber; model.Address = Cusdet.Address; model.City = Cusdet.City; model.State = Cusdet.State; model.Pincode = Convert.ToInt32(Cusdet.Pincode); } } return(PartialView("_EditFormCustomer", model)); }
public ActionResult HtmlBeginForm(int?id) { CustomerModel model = new CustomerModel(); try { List <CustomerModel> cusDetailsList = new List <CustomerModel>(); customerdbEntities2 db = new customerdbEntities2(); var cus = db.GetCustomerdb(null).ToList(); foreach (var item in cus) { int?Pin = null; if (!string.IsNullOrEmpty(item.Pincode)) { Pin = Convert.ToInt32(item.Pincode.Trim()); } cusDetailsList.Add(new CustomerModel() { FirstName = item.FirstName, LastName = item.LastName, Gender = item.Gender.Value, DoB = item.DoB, Email = item.Email, PhoneNumber = item.PhoneNumber, Address = item.Address, City = item.City, State = item.State, Pincode = Pin, CustomerId = item.CustomerId, FollowUpCount = item.FollowUpCount }); } model.cusDetailsList = cusDetailsList; if (id != null) { var cusDet = cusDetailsList.Where(m => m.CustomerId == id).FirstOrDefault(); model.FirstName = cusDet.FirstName; model.LastName = cusDet.LastName; model.Gender = cusDet.Gender; model.DoB = cusDet.DoB; model.Email = cusDet.Email; model.PhoneNumber = cusDet.PhoneNumber; model.Address = cusDet.Address; model.City = cusDet.City; model.State = cusDet.State; model.Pincode = cusDet.Pincode; } } catch (Exception ex) { string error = ex.Message; } return(View(model)); }
public ActionResult DeleteCustomerFollowup(int id, int cid)//id=followupid cid=custid { customerdbEntities2 db = new customerdbEntities2(); FollowUpModel model = new FollowUpModel(); string message = string.Empty; bool status = false; try { var Cusdet = db.CustomerFollowUpsDelete(id); var cus = db.CustomerFollowUpsGet(null, cid).ToList(); List <FollowUpModel> cusDetailsList = new List <FollowUpModel>(); foreach (var item in cus) { cusDetailsList.Add(new FollowUpModel() { FollowUpDate = item.FollowUpDate.Value, FollowUpType = item.FollowUpType.Value, Comments = item.Comments, Status = item.Status.Value, NextFollowUpDate = item.NextFollowUpDate.Value, FollowUpId = item.FollowUpId, Cid = item.CustomerId.Value }); } model.cusDetailsList = cusDetailsList; message = "Record deleted successfully."; status = true; } catch (Exception ex) { string error = ex.Message; message = "Record not deleted, try again."; status = false; } return(Json(new { status = status, message = message, content = RenderRazorViewToString("FollowUpCustomerDetailsList", model) })); //public ActionResult DeletePopUp() //{ // return View(); //} }
public ActionResult EditCustomerFollowup(int id)//id=followupid { customerdbEntities2 db = new customerdbEntities2(); FollowUpModel model = new FollowUpModel(); if (id != null) { var Cusdet = db.CustomerFollowUpsGet(id, null).FirstOrDefault(); if (Cusdet != null) { model.FollowUpId = Cusdet.FollowUpId; model.FollowUpDate = Cusdet.FollowUpDate.Value; model.FollowUpType = Cusdet.FollowUpType.Value; model.Comments = Cusdet.Comments; model.Status = Cusdet.Status.Value; model.NextFollowUpDate = Cusdet.NextFollowUpDate; model.Cid = Cusdet.CustomerId.Value; } } return(PartialView("EditCustomerFollowupForm", model)); }
public ActionResult Search(string FirstName, string LastName) { customerdbEntities2 entities = new customerdbEntities2(); return(View(entities.SearchCustomers(FirstName, LastName))); }
public ActionResult HtmlBeginDeleteCustomer(int id) { CustomerModel model = new CustomerModel(); customerdbEntities2 db = new customerdbEntities2(); string message = string.Empty; bool status = false; try { var Cusdets = db.GetCustomerdb(id).FirstOrDefault(); var filepath = Request.MapPath("~/CustomerImages/" + Cusdets.ImagePath); System.IO.File.SetAttributes(filepath, FileAttributes.Normal); System.IO.File.Delete(filepath); //Delete All Files In Folder //System.IO.DirectoryInfo folderInfo = new DirectoryInfo(folderPath); // foreach (FileInfo file in folderInfo.GetFiles()) // { // file.Delete(); //} //foreach (DirectoryInfo dir in folderInfo.GetDirectories()) //{ // dir.Delete(true); var Cusdet = db.DeleteCustomerdb(id); var cus = db.GetCustomerdb(null).ToList(); List <CustomerModel> cusDetailsList = new List <CustomerModel>(); foreach (var item in cus) { cusDetailsList.Add(new CustomerModel() { FirstName = item.FirstName, LastName = item.LastName, Gender = item.Gender.Value, DoB = item.DoB, Email = item.Email, PhoneNumber = item.PhoneNumber, Address = item.Address, City = item.City, State = item.State, Pincode = Convert.ToInt32(item.Pincode), CustomerId = item.CustomerId }); } model.cusDetailsList = cusDetailsList; message = "Record deleted successfully."; status = true; } catch (Exception ex) { string error = ex.Message; message = "Error! This User Has Followup."; status = false; } return(View("DisplayCustomerDetailsList", model)); }
public ActionResult HtmlBeginForm(CustomerModel model) { customerdbEntities2 db = new customerdbEntities2(); string message = string.Empty; bool status = false; try { if (model.DoB.Value.Year <= 2000) { if (!model.CustomerId.HasValue) { //var filename = Server.MapPath("~/CustomerImages/" + model.ImageFile.FileName); string filename = Path.GetFileNameWithoutExtension(model.ImageFile.FileName); if (model.ImageFile.ContentLength < 1000000) { if (model.ImageFile.ContentType == "image/png" || model.ImageFile.ContentType == "image/jpeg" || model.ImageFile.ContentType == "image/jpg") { model.ImagePath = "~/CustomerImages/"; model.ImageFile.SaveAs(Path.Combine(Server.MapPath("~/CustomerImages/"), filename)); //model.ImageFile.SaveAs(filename); db.SaveCustomerdb(model.FirstName, model.LastName, model.Gender, model.DoB, model.Email, model.PhoneNumber, model.Address, model.City, model.State, model.Pincode.ToString(), null, model.ImageFile.FileName); message = "Record saved successfully."; status = true; } else { Response.Write("<h1 style='color: Tomato;'><marquee>Upload Failed!Supports Only JPEG and PNG Format.</marquee></h1>"); } } else { Response.Write("<h1 style='color: Tomato;'><marquee>Upload Failed!File size must be below 1Mb.</marquee></h1>"); } } else { if (model.ImageFile == null) { var fileNames = Path.GetFileName(model.ImagePath); db.UpdateCustomerdb(model.CustomerId, model.FirstName, model.LastName, model.Gender, model.DoB, model.Email, model.PhoneNumber, model.Address, model.City, model.State, model.Pincode.ToString(), null, fileNames); message = "Record updated successfully."; status = true; } else { if (model.ImageFile.ContentLength < 1000000) { if (model.ImageFile.ContentType == "image/png" || model.ImageFile.ContentType == "image/jpeg" || model.ImageFile.ContentType == "image/jpg") { db.UpdateCustomerdb(model.CustomerId, model.FirstName, model.LastName, model.Gender, model.DoB, model.Email, model.PhoneNumber, model.Address, model.City, model.State, model.Pincode.ToString(), null, model.ImageFile.FileName); message = "Record updated successfully."; status = true; } else { Response.Write("<h1 style='color: Tomato;'><marquee>Upload Failed!Supports Only JPEG and PNG Format.</marquee></h1>"); } } else { Response.Write("<h1 style='color: Tomato;'><marquee>Upload Failed!File size must be below 1Mb.</marquee></h1>"); } } } } else { message = "Date error, Please try again."; status = false; } List <CustomerModel> cusDetailsList = new List <CustomerModel>(); var cus = db.GetCustomerdb(null).ToList(); foreach (var item in cus) { cusDetailsList.Add(new CustomerModel() { FirstName = item.FirstName, LastName = item.LastName, Gender = item.Gender.Value, DoB = item.DoB, Email = item.Email, PhoneNumber = item.PhoneNumber, Address = item.Address, City = item.City, State = item.State, Pincode = Convert.ToInt32(item.Pincode), CustomerId = item.CustomerId, ImagePath = item.ImagePath }); } model.cusDetailsList = cusDetailsList; } catch (Exception ex) { string error = ex.Message; message = "ERROR! Please Try Again"; status = false; } return(RedirectToAction("DisplayCustomerDetailsList")); }
public ActionResult EditCustomerFollowup(FollowUpModel model)//id=customerid { customerdbEntities2 db = new customerdbEntities2(); string message = string.Empty; bool status = false; FollowUpModel fc = new FollowUpModel(); try { if (model.FollowUpDate.Value <= DateTime.Now) { if (model.NextFollowUpDate > model.FollowUpDate) { if (!model.FollowUpId.HasValue) { //db.CustomerFollowUpsInsert(model.FollowUpDate, model.FollowUpType, model.Comments, model.Status, model.NextFollowUpDate, null, id); //message = "Record saved successfully."; //status = true; } else { db.CustomerFollowUpsUpdate(model.FollowUpId, model.Cid, model.FollowUpDate, model.FollowUpType, model.Comments, model.Status, model.NextFollowUpDate, null); message = "Record updated successfully."; status = true; } } else { message = "Next FollowUp Date Must Be Greater."; } } else { message = "Date error, Please try again."; status = false; } List <FollowUpModel> cusDetailsList = new List <FollowUpModel>(); if (model.FollowUpId != null) { var cus = db.CustomerFollowUpsGet(null, model.Cid).ToList(); foreach (var item in cus) { cusDetailsList.Add(new FollowUpModel() { FollowUpDate = item.FollowUpDate.Value, FollowUpType = item.FollowUpType.Value, Comments = item.Comments, Status = item.Status.Value, NextFollowUpDate = item.NextFollowUpDate, FollowUpId = item.FollowUpId, Cid = item.CustomerId.Value }); } } model.cusDetailsList = cusDetailsList; } catch (Exception ex) { string error = ex.Message; message = "ERROR! Please Try Again"; status = false; } return(Json(new { status = status, message = message, content = RenderRazorViewToString("FollowUpCustomerDetailsList", model) //, //content1 = RenderRazorViewToString("FollowUpAddForm",fc) } )); // ModelState.Clear(); }
public ActionResult Index(CustomerModel model) { customerdbEntities2 db = new customerdbEntities2(); string message = string.Empty; bool status = false; try { if (model.DoB.Value.Year <= 2000) { if (!model.CustomerId.HasValue) { db.SaveCustomerdb(model.FirstName, model.LastName, model.Gender, model.DoB, model.Email, model.PhoneNumber, model.Address, model.City, model.State, model.Pincode.ToString(), null, null); message = "Record saved successfully."; status = true; } else { db.UpdateCustomerdb(model.CustomerId, model.FirstName, model.LastName, model.Gender, model.DoB, model.Email, model.PhoneNumber, model.Address, model.City, model.State, model.Pincode.ToString(), null, model.ImagePath); message = "Record updated successfully."; status = true; } } else { message = "Date error, Please try again."; status = false; } List <CustomerModel> cusDetailsList = new List <CustomerModel>(); var cus = db.GetCustomerdb(null).ToList(); foreach (var item in cus) { cusDetailsList.Add(new CustomerModel() { FirstName = item.FirstName, LastName = item.LastName, Gender = item.Gender.Value, DoB = item.DoB, Email = item.Email, PhoneNumber = item.PhoneNumber, Address = item.Address, City = item.City, State = item.State, Pincode = Convert.ToInt32(item.Pincode), CustomerId = item.CustomerId }); } model.cusDetailsList = cusDetailsList; } catch (Exception ex) { string error = ex.Message; message = "ERROR! Please Try Again"; status = false; } return(Json(new { status = status, message = message, content = RenderRazorViewToString("_PartialCustomerDetailsList", model) } )); }