//Get Single Record public static eLoyalityPointsCustomerData GetRecordById(int iId) { eLoyalityPointsCustomerData eobj = new eLoyalityPointsCustomerData(); using (OneFineRateEntities db = new OneFineRateEntities()) { var dbobj = (from t in db.tblCustomerPointsMaps select new eLoyalityPointsCustomerData { iId = t.iId, iCustomerId = t.iCustomerId, iTotalPoints = t.iTotalPoints, iUsedPoints = t.iUsedPoints, iRemPoints = t.iRemPoints, dtCreatedOn = t.dtCreatedOn, dtExpiryOriginal = t.dtExpiryOriginal, dtExpiry = t.dtExpiry, cType = t.cType, cStatus = t.cStatus, }).Where(u => u.iId == iId).ToList(); if (dbobj != null) { eobj = (eLoyalityPointsCustomerData)OneFineRateAppUtil.clsUtils.ConvertToObject(dbobj[0], eobj); } } return(eobj); }
//Update a record public static int UpdateLoyalityPointsExpiryDate(eLoyalityPointsCustomerData eobj) { int retval = 0; using (OneFineRateEntities db = new OneFineRateEntities()) { try { OneFineRate.tblCustomerPointsMap obj = (OneFineRate.tblCustomerPointsMap)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblCustomerPointsMap()); db.tblCustomerPointsMaps.Attach(obj); db.Entry(obj).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); retval = 1; } catch (Exception) { throw; } } return(retval); }
public string UpdateLoyalityPointsExpiry(string ExpiryDate, Array gridData) { object result = null; string strReturn = string.Empty; try { eLoyalityPointsCustomerData objData = new eLoyalityPointsCustomerData(); List <eLoyalityPointsCustomerData> objDataList = new List <eLoyalityPointsCustomerData>(); foreach (var item in gridData) { objData = BL_LoyalityAmenityMap.GetRecordById(Convert.ToInt32(item)); objData.dtExpiry = Convert.ToDateTime(clsUtils.ConvertddmmyyyytoDateTime(ExpiryDate)); objDataList.Add(objData); } int counter = 0; for (int c = 0; c < objDataList.Count; c++) { BL_LoyalityAmenityMap.UpdateLoyalityPointsExpiryDate(objDataList[c]); counter++; } if (objDataList.Count == counter) { result = new { st = 1, msg = clsUtils.ErrorMsg("Expiry Date for the selected records", 2) }; } else { var diff = objDataList.Count - counter; result = new { st = 0, msg = "Not able to update" + diff + "records out off" + objDataList.Count }; } } catch (Exception) { result = new { st = 0, msg = "Kindly try after some time." }; } strReturn = OneFineRateAppUtil.clsUtils.ConvertToJson(result); return(strReturn); }