//-----------------------------Add Edit----------------------------
public ActionResult AddEdit(int CustID)
{
LaunSysDBEntities db = new LaunSysDBEntities();
List <tb_Titles> TitleList = db.tb_Titles.ToList();
ViewBag.VTitleLists = new SelectList(TitleList, "TitleID", "Title");
List <tb_Gender> GenderList = db.tb_Gender.ToList();
ViewBag.VGenderLists = new SelectList(GenderList, "GenderID", "Gendername");
ClientsViewModel Model = new ClientsViewModel();
if (CustID > 0)
{
tb_Customers Cust = db.tb_Customers.SingleOrDefault(x => x.CustID == CustID && x.IsNotActive == false);
Model.CustID = Cust.CustID;
Model.TitleID = Cust.TitleID;
Model.SurName = Cust.SurName;
Model.OtherNames = Cust.OtherNames;
Model.GenderID = Cust.GenderID;
Model.Cust_Address = Cust.Cust_Address;
Model.Phone = Cust.Phone;
Model.Email = Cust.Email;
Model.CreatedDate = Cust.CreatedDate;
}
return(PartialView("AddEditViewPartialView", Model));
}
// to activate Authorization = [AuthorizeRoles(admin,accountant)]
// to add default route = [Route("x/x/{parameter 1}/{parameter 2}")]
// to pass parameter by exception = public ActionResult Index( string Id, ClientsViewModel Model)
public ActionResult Index(ClientsViewModel Model)
{
try
{
//if (ModelState.IsValid == true)
//{
LaunSysDBEntities db = new LaunSysDBEntities();
//------------------------To populate the drop down lists---------------------------
List <tb_Titles> TitleList = db.tb_Titles.ToList();
ViewBag.VTitleLists = new SelectList(TitleList, "TitleID", "Title");
List <tb_Gender> GenderList = db.tb_Gender.ToList();
ViewBag.VGenderLists = new SelectList(GenderList, "GenderID", "Gendername");
//----------------------------------------------------------------------------------
if (Model.CustID > 0)
{
//UPDATE EXISTING RECORD
tb_Customers Clients = db.tb_Customers.SingleOrDefault(x => x.CustID == Model.CustID && x.IsNotActive == false);
Clients.TitleID = Model.TitleID;
Clients.SurName = Model.SurName;
Clients.OtherNames = Model.OtherNames;
Clients.GenderID = Model.GenderID;
Clients.Cust_Address = Model.Cust_Address;
Clients.Phone = Model.Phone;
Clients.Email = Model.Email;
Clients.CreatedDate = Model.CreatedDate;
db.SaveChanges();
}
else
{
//INSERT NEW RECORD
tb_Customers Clients = new tb_Customers();
Clients.TitleID = Model.TitleID;
Clients.SurName = Model.SurName;
Clients.OtherNames = Model.OtherNames;
Clients.GenderID = Model.GenderID;
Clients.Cust_Address = Model.Cust_Address;
Clients.Phone = Model.Phone;
Clients.Email = Model.Email;
Clients.CreatedDate = Model.CreatedDate;
Clients.IsNotActive = false;
db.tb_Customers.Add(Clients);
db.SaveChanges();
}
return(View(Model));
//}
}
catch (Exception ex)
{
throw ex;
}
}
public JsonResult GetCustomerID(int CustID)
{
tb_Customers model = db.tb_Customers.Where(x => x.CustID == CustID).SingleOrDefault();
string value = string.Empty;
value = JsonConvert.SerializeObject(model, Formatting.Indented, new JsonSerializerSettings
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
return(Json(value, JsonRequestBehavior.AllowGet));
}
public JsonResult DeleteCustomerRecord(int CustID)
{
bool result = false;
tb_Customers Cust = db.tb_Customers.SingleOrDefault(x => x.IsNotActive == false && x.CustID == CustID);
if (Cust != null)
{
Cust.IsNotActive = true;
db.SaveChanges();
result = true;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult InsertCustomers(CustomersViewModel model)
{
var result = false;
try
{
if (model.CustID > 0)
{
tb_Customers Cust = db.tb_Customers.SingleOrDefault(x => x.IsNotActive == false && x.CustID == model.CustID);
Cust.TitleID = model.TitleID;
Cust.SurName = model.SurName;
Cust.OtherNames = model.OtherNames;
Cust.GenderID = model.GenderID;
Cust.Cust_Address = model.Cust_Address;
Cust.Phone = model.Phone;
Cust.Email = model.Email;
Cust.CreatedDate = model.CreatedDate;
//Cust.IsNotActive = false;
//3077145452
db.SaveChanges();
result = true;
}
else
{
tb_Customers Cust = new tb_Customers();
Cust.TitleID = model.TitleID;
Cust.SurName = model.SurName;
Cust.OtherNames = model.OtherNames;
Cust.GenderID = model.GenderID;
Cust.Cust_Address = model.Cust_Address;
Cust.Phone = model.Phone;
Cust.Email = model.Email;
Cust.CreatedDate = model.CreatedDate;
Cust.IsNotActive = false;
db.tb_Customers.Add(Cust);
db.SaveChanges();
result = true;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
throw ex;
}
}
//-----------------------------Delete client----------------------------
public JsonResult DeleteClient(int CustID)
{
LaunSysDBEntities db = new LaunSysDBEntities();
bool result = false;
tb_Customers Cust = db.tb_Customers.SingleOrDefault(x => x.IsNotActive == false && x.CustID == CustID);
if (Cust != null)
{
//set the customer id to true, there fore hide it from the table\
Cust.IsNotActive = true;
db.SaveChanges();
result = true;
}
//FlashMessage.Info("Invalid Login Details");
return(Json(result, JsonRequestBehavior.AllowGet));
}
