public LocalitiesModel GetLocalityById(int id) { //ResponseStatus respponse = new ResponseStatus(); LocalitiesModel data = new LocalitiesModel(); using (evergreen_androidEntities context = new evergreen_androidEntities()) { data = (from lo in context.localitymasters join st in context.storemasters on lo.StoreId1 equals st.StoreId into j1 from j2 in j1.DefaultIfEmpty() join st1 in context.storemasters on lo.StoreId2 equals st1.StoreId into j3 from j4 in j3.DefaultIfEmpty() join st2 in context.storemasters on lo.StoreId3 equals st2.StoreId into j5 from j6 in j5.DefaultIfEmpty() orderby lo.CreatedOn descending where lo.LocalityId == id select new LocalitiesModel() { LocalityId = lo.LocalityId, LocalityName = lo.LocalityName, StoreName = j2.StoreName, StoreName1 = j4.StoreName, StoreName2 = j6.StoreName }).FirstOrDefault(); } return(data); }
public HttpResponseMessage AddNewLocalityName(string LocalityId, string localityname, string storeid, string storeid1, string storeid2) { ResponseStatus response = new ResponseStatus(); try { LocalitiesModel model = new LocalitiesModel(); model.LocalityId = Convert.ToInt32(LocalityId); model.LocalityName = localityname; model.StoreId = Convert.ToInt32(storeid); model.StoreId1 = Convert.ToInt32(storeid1); model.StoreId2 = Convert.ToInt32(storeid2); var data = _repository.AddNewLocalityName(model); //if (data.LocalityId > 0) //{ // response.isSuccess = true; // response.serverResponseTime = DateTime.Now; return(Request.CreateResponse(HttpStatusCode.OK, new { data })); //} //else //{ // response.isSuccess = false; // response.serverResponseTime = DateTime.Now; // return Request.CreateResponse(HttpStatusCode.BadRequest, new { data }); //} } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Something Worng !", ex)); } }
public LocalitiesModel AddNewLocalityName(LocalitiesModel model) { //ResponseStatus respponse = new ResponseStatus(); LocalitiesModel data = new LocalitiesModel(); using (evergreen_androidEntities context = new evergreen_androidEntities()) { var lc = context.localitymasters.Find(model.LocalityId); if (lc != null) { lc.LocalityName = model.LocalityName; lc.StoreId1 = model.StoreId; lc.StoreId2 = model.StoreId1; lc.StoreId3 = model.StoreId2; var result = context.SaveChanges(); if (result > 0) { data.LocalityId = lc.LocalityId; data.LocalityName = lc.LocalityName; } } else { localitymaster l = new localitymaster(); l.LocalityName = model.LocalityName; l.StoreId1 = model.StoreId; l.StoreId2 = model.StoreId1; l.StoreId3 = model.StoreId2; context.localitymasters.Add(l); var result = context.SaveChanges(); if (result > 0) { data.LocalityId = l.LocalityId; data.LocalityName = l.LocalityName; } } } return(data); }