public async Task <JsonResult> AddDeviceModels(Device_BrandModel obj) { if (obj.Id == 0) { var exsist = _db.Device_BrandModels.FirstOrDefault(x => x.Name == obj.Name && x.Devices_BrandId == obj.Devices_BrandId); if (exsist != null) { return(Json("exists", JsonRequestBehavior.AllowGet)); } var model = new Device_BrandModel(); model.Name = obj.Name; model.Devices_BrandId = obj.Devices_BrandId; model.Device_VendorId = obj.Device_VendorId; model.RPMServiceId = obj.RPMServiceId; model.CreatedBy = User.Identity.GetUserId(); model.CreatedDate = DateTime.Now; _db.Device_BrandModels.Add(model); var save = await _db.SaveChangesAsync(); if (save > 0) { return(Json("added", JsonRequestBehavior.AllowGet)); } return(Json("error", JsonRequestBehavior.AllowGet)); } else { var model = await _db.Device_BrandModels.FirstOrDefaultAsync(x => x.Id == obj.Id); model.Name = obj.Name; model.Devices_BrandId = obj.Devices_BrandId; model.Device_VendorId = obj.Device_VendorId; model.RPMServiceId = obj.RPMServiceId; model.ModifiedBy = User.Identity.GetUserId(); model.ModifiedDate = DateTime.Now; _db.Entry(model).State = EntityState.Modified; var save = await _db.SaveChangesAsync(); if (save > 0) { return(Json("updated", JsonRequestBehavior.AllowGet)); } return(Json("error", JsonRequestBehavior.AllowGet)); } }
public async Task <ActionResult> DeviceModels() { var model = new Device_BrandModel(); ViewBag.IsAvtiveStatus = Enum.GetValues(typeof(IsActiveStatus)).Cast <IsActiveStatus>().Select(y => new SelectListItem { Text = y.ToString(), Value = ((int)y).ToString() }).ToList(); ViewBag.Devices_brands = _db.Devices_Brands.Select(x => new SelectListItem { Text = x.Name, Value = x.Id.ToString() }).ToList(); ViewBag.Devices_Vendors = _db.Device_Vendors.Select(x => new SelectListItem { Text = x.Name, Value = x.Id.ToString() }).ToList(); ViewBag.RpmServices = _db.RPMServices.Select(x => new SelectListItem { Text = x.ServiceName, Value = x.Id.ToString() }).ToList(); var Device_BrandModels = await _db.Device_BrandModels.ToListAsync(); ViewBag.DeviceBrandModels = Device_BrandModels; return(View(model)); }