public int UpdateItemGroup(CmnItemGroup model) { GenericFactory_EF_ItemGroup = new CmnItemGroup_EF(); int result = 0; try { CmnItemGroup _itemGroup = GenericFactory_EF_ItemGroup.FindBy(x => x.ItemGroupID == model.ItemGroupID).FirstOrDefault(); _itemGroup.UpdateBy = model.CreateBy; _itemGroup.UpdateOn = DateTime.Today; _itemGroup.UpdatePc = HostService.GetIP(); _itemGroup.ItemGroupName = model.ItemGroupName; _itemGroup.ItemTypeID = model.ItemTypeID; _itemGroup.ParentID = model.ParentID; _itemGroup.CustomCode = model.CustomCode; _itemGroup.AcDetailID = model.AcDetailID; _itemGroup.IsActive = model.IsActive; GenericFactory_EF_ItemGroup.Update(_itemGroup); GenericFactory_EF_ItemGroup.Save(); result = 1; } catch (Exception e) { e.ToString(); result = 0; } return(result); }
public int UpdateItemGroup(CmnItemGroup model) { int result = 0; try { CmnItemGroup _itemGroup = GenericFactory_EF_ItemGroup.FindBy(x => x.ItemGroupID == model.ItemGroupID).FirstOrDefault(); _itemGroup.UpdateBy = model.CreateBy; _itemGroup.UpdateOn = DateTime.Today; _itemGroup.UpdatePc = Environment.MachineName; _itemGroup.ItemGroupName = model.ItemGroupName; _itemGroup.ItemTypeID = model.ItemTypeID; _itemGroup.ParentID = model.ParentID; _itemGroup.IsActive = model.IsActive; GenericFactory_EF_ItemGroup.Update(_itemGroup); GenericFactory_EF_ItemGroup.Save(); result = 1; } catch (Exception e) { e.ToString(); result = 0; } return(result); }
public HttpResponseMessage UpdateItemGroup(CmnItemGroup model) { int result = 0; try { result = objItemGroupMgtFF.UpdateItemGroup(model); } catch (Exception e) { e.ToString(); result = -0; } return(Request.CreateResponse(HttpStatusCode.OK, result)); }
public int SaveItemGroup(CmnItemGroup model) { int result = 0; try { int NextId = GenericFactory_EF_ItemGroup.getMaxVal_int("ItemGroupID", "CmnItemGroup"); model.ItemGroupID = NextId; model.CustomCode = NextId.ToString(); model.CreateOn = DateTime.Today; model.CreatePc = Environment.MachineName; GenericFactory_EF_ItemGroup.Insert(model); GenericFactory_EF_ItemGroup.Save(); result = 1; } catch (Exception ex) { ex.ToString(); result = 0; } return(result); }
/// No CompanyID Provided private string SetArticaleNo(int?ItemGroup) { GenericFactory_EF_ItemGroup = new CmnItemGroup_EF(); GenericFactory_EF_RawMaterial = new CmnItemMaster_EF(); string articaleNo = string.Empty; try { CmnItemGroup itemGroup = GenericFactory_EF_ItemGroup.FindBy(x => x.ItemGroupID == ItemGroup).FirstOrDefault(); // int count = GenericFactory_EF_RawMaterial.GetAll().Where(x => x.ItemGroupID == ItemGroup).Count(); int count = GenericFactory_EF_RawMaterial.FindBy(x => x.ItemGroupID == ItemGroup).Count(); Int64 itemcode = Convert.ToInt64(itemGroup.CustomCode) + count + 1; articaleNo = itemcode.ToString(); //CmnItemGroup itemGroup = GenericFactory_EF_ItemGroup.FindBy(x => x.ItemGroupID == ItemGroup).FirstOrDefault(); //List<CmnItemMaster> _ItemMasterobj = GenericFactory_EF_RawMaterial.GetAll().Where(x => x.ItemGroupID == ItemGroup).ToList(); //string exitemGroup = itemGroup.CustomCode; //int rowNumber = (from item in _ItemMasterobj // where item.ArticleNo.Contains(exitemGroup) // select item.ArticleNo).Count(); //if (rowNumber == 0) //{ // articaleNo = exitemGroup + "00000"; // articaleNo = (Convert.ToInt64(articaleNo) + 1).ToString(); //} //else //{ // articaleNo = exitemGroup + "00000"; // Int64? Nnum = (Convert.ToInt64(articaleNo) + rowNumber) + 1; // articaleNo = Nnum.ToString(); //} } catch (Exception ex) { ex.ToString(); } return(articaleNo); }
/// No CompanyID Provided public int SaveItemGroup(CmnItemGroup model) { GenericFactory_EF_ItemGroup = new CmnItemGroup_EF(); int result = 0; try { int NextId = GenericFactory_EF_ItemGroup.getMaxVal_int("ItemGroupID", "CmnItemGroup"); model.ItemGroupID = NextId; // model.CustomCode = NextId.ToString(); model.CreateOn = DateTime.Today; model.CreatePc = HostService.GetIP(); GenericFactory_EF_ItemGroup.Insert(model); GenericFactory_EF_ItemGroup.Save(); result = 1; } catch (Exception ex) { ex.ToString(); result = 0; } return(result); }
public int CheckItemGroupCode(int?GroupCode) { int isexist = 0; using (ERP_Entities _ctx = new ERP_Entities()) { try { string customeCode = GroupCode.ToString(); CmnItemGroup _itemGroup = _ctx.CmnItemGroups.Where(x => x.CustomCode == customeCode).FirstOrDefault(); if (_itemGroup != null) { isexist = 1; } } catch { isexist = 0; } return(isexist); } }
public int DeleteItemGroup(CmnItemGroup _model) { int result = 0; try { CmnItemGroup model = GenericFactory_EF_ItemGroup.GetAll().Where(x => x.ItemGroupID == _model.ItemGroupID).FirstOrDefault(); model.DeleteOn = DateTime.Today; model.DeleteBy = _model.DeleteBy; model.IsDeleted = true; GenericFactory_EF_ItemGroup.Update(model); GenericFactory_EF_ItemGroup.Save(); result = 1; } catch (Exception e) { e.ToString(); result = 0; } return(result); }