//Update a record public static int UpdateRecord(eAmenity eobj) { int retval = 0; using (OneFineRateEntities db = new OneFineRateEntities()) { try { int dbobj = (from s in db.tblAmenityMs.Where(u => u.sAmenityName == eobj.sAmenityName.Trim() && u.iAmenityId != eobj.iAmenityId) select new { s.iAmenityId, }).Count(); if (dbobj > 0) { return(retval = 2); } OneFineRate.tblAmenityM obj = (OneFineRate.tblAmenityM)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblAmenityM()); db.tblAmenityMs.Attach(obj); db.Entry(obj).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); retval = 1; } catch (Exception) { throw; } } return(retval); }
//Add new record public static int AddRecord(eAmenity eobj) { int retval = 0; using (OneFineRateEntities db = new OneFineRateEntities()) { try { int dbobj = (from s in db.tblAmenityMs.Where(u => u.sAmenityName == eobj.sAmenityName.Trim()) select new { s.iAmenityId, }).Count(); if (dbobj > 0) { return(retval = 2); } OneFineRate.tblAmenityM dbuser = (OneFineRate.tblAmenityM)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblAmenityM()); db.tblAmenityMs.Add(dbuser); db.SaveChanges(); retval = 1; } catch (Exception) { throw; } } return(retval); }
public string UpdateStatus(int id, string status) { object result = null; string strReturn = string.Empty; try { eAmenity obj = new eAmenity(); obj = BL_Amenity.GetSingleRecordById(id); obj.dtActionDate = DateTime.Now; obj.cStatus = status; obj.iActionBy = ((OneFineRateBLL.BL_Login.UserDetails)Session["UserDetails"]).iUserId; int i = BL_Amenity.UpdateRecord(obj); if (i == 1) { result = new { st = 1, msg = clsUtils.ErrorMsg("Amenity", 4, status) }; } else { result = new { st = 0, msg = clsUtils.ErrorMsg("Amenity", 0) }; } } catch (Exception) { result = new { st = 0, msg = clsUtils.ErrorMsg("", 3) }; } strReturn = OneFineRateAppUtil.clsUtils.ConvertToJson(result); return(strReturn); }
//Get Single Record public static eAmenity GetSingleRecordById(int id) { eAmenity eobj = new eAmenity(); using (OneFineRateEntities db = new OneFineRateEntities()) { var dbobj = db.tblAmenityMs.SingleOrDefault(u => u.iAmenityId == id); if (dbobj != null) { eobj = (eAmenity)OneFineRateAppUtil.clsUtils.ConvertToObject(dbobj, eobj); } } return(eobj); }
public string AddAmenity(string name) { object result = null; string strReturn = string.Empty; try { eAmenity eObj = new eAmenity(); eObj.sAmenityName = name; eObj.dtActionDate = DateTime.Now; eObj.cStatus = "A"; eObj.iActionBy = ((OneFineRateBLL.BL_Login.UserDetails)Session["UserDetails"]).iUserId; if (name.Trim() == "") { result = new { st = 0, msg = clsUtils.ErrorMsg("", 9) }; } else { int i = BL_Amenity.AddRecord(eObj); if (i == 1) { result = new { st = 1, msg = clsUtils.ErrorMsg("Amenity", 1) }; } else if (i == 2) { result = new { st = 0, msg = clsUtils.ErrorMsg("Amenity", 0) }; } else { result = new { st = 0, msg = clsUtils.ErrorMsg("Amenity", 3) }; } } } catch (Exception) { result = new { st = 0, msg = clsUtils.ErrorMsg("", 3) }; } strReturn = OneFineRateAppUtil.clsUtils.ConvertToJson(result); return(strReturn); }