Пример #1
0
        //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);
        }
Пример #2
0
        //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);
        }
Пример #3
0
        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);
        }
Пример #4
0
        //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);
        }
Пример #5
0
        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);
        }