public ActionResult Create(int?id)
{
try
{
var DBContext = new CustomerDataEntities();
ViewBag.City = DBContext.TBL_City.Select(x => new SelectListItem
{
Text = x.Name,
Value = x.ID.ToString(),
}).ToList();
var customer = DBContext.TBL_Customer.Where(x => x.ID == id).Select(x => new Customer
{
FirstName = x.FirstName,
LastName = x.LastName,
Address = x.Address,
CityID = x.CityID ?? 0,
ID = x.ID,
DOB = x.DOB ?? DateTime.Now,
ContactNumber = x.Contact,
TurnOver = x.Turnover ?? 0,
}).FirstOrDefault();
return(View(customer));
}
catch (Exception e)
{
return(View());
}
}
public ActionResult DeleteCustomer(int id)
{
try
{
var DBContext = new CustomerDataEntities();
var customer = DBContext.TBL_Customer.Where(x => x.ID == id).FirstOrDefault();
DBContext.TBL_Customer.Remove(customer);
DBContext.SaveChanges();
return(Json(new { isSuccess = true }, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
return(Json(new { isSuccess = false }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetAllCustomer()
{
var DBContext = new CustomerDataEntities();
var customer = DBContext.TBL_Customer.Select(x => new Customer
{
FirstName = x.FirstName,
LastName = x.LastName,
City = x.TBL_City.Name,
ID = x.ID,
DOB = x.DOB ?? DateTime.Now,
DOBString = x.DOB.Value.Day + "/" + x.DOB.Value.Month + "/" + x.DOB.Value.Year,
ContactNumber = x.Contact,
TurnOver = x.Turnover ?? 0,
Address = x.Address,
}).ToList();
return(Json(new { isSuceess = true, data = customer }, JsonRequestBehavior.AllowGet));
}
public ActionResult Create(Customer model)
{
string ResultMessage;
try
{
var DBContext = new CustomerDataEntities();
var CustomerModel = new TBL_Customer
{
FirstName = model.FirstName,
LastName = model.LastName,
Address = model.Address,
CityID = model.CityID,
DOB = model.DOB,
Contact = model.ContactNumber,
Turnover = model.TurnOver,
ID = model.ID
};
if (model.ID > 0)
{
DBContext.Entry(CustomerModel).State = EntityState.Modified;
ResultMessage = "Customer Update Sucessfuly";
}
else
{
DBContext.TBL_Customer.Add(CustomerModel);
ResultMessage = "Customer Added Sucessfuly";
}
DBContext.SaveChanges();
TempData["ResultMessage"] = ResultMessage;
return(Json(new { isSuccess = true, Message = ResultMessage }));
}
catch (Exception e)
{
return(Json(new { isSuccess = true, Message = "Something went wrong" }));
}
}
