public CmnItemSize GetItemSizeById(int id) { CmnItemSize objItemSize = null; try { objItemSize = objItemSizeService.GetItemSizeById(id).FirstOrDefault(); } catch (Exception e) { e.ToString(); } return(objItemSize); }
public HttpResponseMessage SaveUpdateItemSize(CmnItemSize model) { int result = 0; try { if (ModelState.IsValid) { result = objItemSizeService.SaveUpdateItemSize(model); } } catch (Exception e) { e.ToString(); result = -0; } return(Request.CreateResponse(HttpStatusCode.OK, result)); }
/// Static CompanyID Provided /// <summary> /// Save Data To Database /// <para>Use it when save data through ORM</para> /// </summary> public int SaveUpdateItemSize(CmnItemSize model) { GenericFactory_EF_ItemSize = new CmnItemSize_EF(); int result = 0; if (model.SizeID > 0) { try { if (model.IsDeleted == false) { model.StatusID = 1; model.CompanyID = 1; model.UpdateBy = 1; model.UpdateOn = DateTime.Today; model.UpdatePc = HostService.GetIP(); GenericFactory_EF_ItemSize.Update(model); GenericFactory_EF_ItemSize.Save(); } else { model.StatusID = 1; model.CompanyID = 1; model.DeleteBy = 1; model.DeleteOn = DateTime.Today; //model.DeletePc = HostService.GetIP(); GenericFactory_EF_ItemSize.Update(model); GenericFactory_EF_ItemSize.Save(); } result = 1; } catch (Exception e) { e.ToString(); result = 0; } } else { //long NextId = GenericFactory_EF_ItemSize.getMaxVal_int("SizeID", "CmnItemSize"); string strTblName = model.ToString().Substring(model.ToString().LastIndexOf(".") + 1); object[] parameters = { strTblName }; string spName = "[SPMaxRowID]"; //long NextId = GenericFactory_EF_Color.getMaxValBySp_string("SPMaxRowID", strTblName); long NextId = GenericFactory_EF_ItemSize.getMaxValBySp(spName, parameters); try { model.SizeID = Convert.ToInt32(NextId); model.StatusID = 1; model.CompanyID = 1; model.CreateBy = 1; model.CreateOn = DateTime.Today; model.CreatePc = HostService.GetIP(); GenericFactory_EF_ItemSize.Insert(model); GenericFactory_EF_ItemSize.Save(); result = 1; } catch (Exception e) { e.ToString(); result = 0; } } return(result); }