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);
}
