public AmenitiesModel GetAmenityInfo(int AmenityID = 0) { ShomaRMEntities db = new ShomaRMEntities(); AmenitiesModel model = new AmenitiesModel(); model.ID = 0; model.Amenity = ""; model.AmenityDetails = ""; var AmenityInfo = db.tbl_Amenities.Where(p => p.ID == AmenityID).FirstOrDefault(); if (AmenityInfo != null) { model.ID = AmenityInfo.ID; model.Amenity = AmenityInfo.Amenity; model.AmenityDetails = AmenityInfo.AmenityDetails; } return(model); }
public long SaveUpdateAmenity(AmenitiesModel model) { ShomaRMEntities db = new ShomaRMEntities(); var amenityExists = db.tbl_Amenities.Where(p => p.ID != model.ID && p.Amenity == model.Amenity).FirstOrDefault(); if (amenityExists == null) { if (model.ID == 0) { var data = new tbl_Amenities() { Amenity = model.Amenity, AmenityDetails = model.AmenityDetails, }; db.tbl_Amenities.Add(data); db.SaveChanges(); model.ID = data.ID; } else { var AmenityInfo = db.tbl_Amenities.Where(p => p.ID == model.ID).FirstOrDefault(); if (AmenityInfo != null) { AmenityInfo.Amenity = model.Amenity; AmenityInfo.AmenityDetails = model.AmenityDetails; db.SaveChanges(); } else { throw new Exception(model.Amenity + " not exists in the system."); } } return(model.ID); } else { throw new Exception(model.Amenity + " already exists in the system."); } }