public int DeleteRawMaterial(CmnItemMaster model)
{
GenericFactory_EF_RawMaterial = new CmnItemMaster_EF();
int result = 0;
try
{
CmnItemMaster _model = GenericFactory_EF_RawMaterial.GetAll().Where(x => x.ItemID == model.ItemID).FirstOrDefault();
_model.DeleteOn = DateTime.Today;
_model.DeleteBy = model.DeleteBy;
_model.DeletePc = HostService.GetIP();
_model.IsDeleted = true;
GenericFactory_EF_RawMaterial.Update(_model);
GenericFactory_EF_RawMaterial.Save();
result = 1;
// For delete into CmnAccIntegration
CmnACCIntegration _modelACCIn = GenericFactory_CmnACCIntegration.GetAll().Where(x => x.TransactionID == model.ItemID).FirstOrDefault();
_modelACCIn.DeleteOn = DateTime.Today;
_modelACCIn.DeleteBy = model.DeleteBy;
_modelACCIn.DeletePc = HostService.GetIP();
_modelACCIn.IsDeleted = true;
GenericFactory_CmnACCIntegration.Update(_modelACCIn);
GenericFactory_CmnACCIntegration.Save();
}
catch (Exception e)
{
e.ToString();
result = 0;
}
return(result);
}
public string SaveFinishGood(CmnItemMaster _itemMaster, List <vmFinishProcess> _finishing)
{
try
{
GenericFactory_EF_CmnItemMaster = new CmnItemMaster_EF();
//Int64 NextId = GenericFactory_EF_CmnItemMaster.getMaxVal_int64("ItemID", "CmnItemMaster");
Int64 NextId = Convert.ToInt64(GenericFactory_EF_CmnItemMaster.getMaxID("CmnItemMaster"));
// NextId++;
string ItemGroupName = GetItemGroupName(_itemMaster.ItemGroupID);
// int maxGroup = GetMaxByGroupWise(_itemMaster.ItemGroupID, _itemMaster.CompanyID);
_itemMaster.ArticleNo = _itemMaster.ArticleNo; //ItemGroupName + maxGroup + FinishingProcess;
_itemMaster.ItemID = NextId;
_itemMaster.CompanyID = Convert.ToInt16(_itemMaster.CompanyID);
_itemMaster.IsDeleted = false;
if (_itemMaster.IsDevelopmentComplete > 0)
{
_itemMaster.IsDevelopmentComplete = 1;
}
_itemMaster.CreateBy = Convert.ToInt16(_itemMaster.CreateBy);
_itemMaster.CreateOn = DateTime.Today;
_itemMaster.CreatePc = HostService.GetIP();
GenericFactory_EF_CmnItemMaster.Insert(_itemMaster);
GenericFactory_EF_CmnItemMaster.Save();
GenericFactory_EF_CmnItemMaster.updateMaxID("CmnItemMaster", NextId);
if (_finishing.Count > 0)
{
SaveFinishingProcess(_finishing, _itemMaster);
}
//Account Intigration
if (_itemMaster.AcDetailID != 0)
{
GenericFactoryEF_CmnACCIntegration = new CmnACCIntegration_EF();
Int64 AccMasterID = Convert.ToInt64(GenericFactoryEF_CmnACCIntegration.getMaxID("CmnACCIntegration"));
CmnACCIntegration _acc = new CmnACCIntegration();
_acc.ACID = AccMasterID;
_acc.TransactionID = NextId;
_acc.AcDetailID = _itemMaster.AcDetailID;
_acc.IsActive = true;
_acc.IsDeleted = false;
_acc.ACTypeID = 1;
_acc.CreateBy = Convert.ToInt16(_itemMaster.CreateBy);
_acc.CreateOn = DateTime.Today;
_acc.CreatePc = HostService.GetIP();
_acc.CompanyID = Convert.ToInt16(_itemMaster.CompanyID);
GenericFactoryEF_CmnACCIntegration.Insert(_acc);
GenericFactoryEF_CmnACCIntegration.Save();
GenericFactoryEF_CmnACCIntegration.updateMaxID("CmnACCIntegration", AccMasterID);
}
//Account Intigration
}
catch (Exception ex)
{
ex.ToString();
}
return(_itemMaster.ArticleNo);
}
/// No CompanyID Provided
public string SaveRowMaterial(CmnItemMaster model, int accDetailID, int ACTypeID)
{
GenericFactory_EF_RawMaterial = new CmnItemMaster_EF();
GenericFactory_CmnACCIntegration = new CmnACCIntegration_EF();
string result = "";
try
{
GenericFactory_EF_CmnItemMaster = new CmnItemMaster_EF();
//Int64 NextId = GenericFactory_EF_RawMaterial.getMaxVal_int64("ItemID", "CmnItemMaster");
Int64 NextId = Convert.ToInt64(GenericFactory_EF_CmnItemMaster.getMaxID("CmnItemMaster"));
model.ItemID = NextId;
string ArticleNo = SetArticaleNo(model.ItemGroupID);
model.ArticleNo = ArticleNo;
string UniqueCode = model.ItemTypeID.ToString() + model.ItemGroupID.ToString() + model.ItemID.ToString();
model.UniqueCode = UniqueCode;
model.CreateOn = DateTime.Today;
model.CreatePc = HostService.GetIP();
model.IsDeleted = false;
GenericFactory_EF_RawMaterial.Insert(model);
GenericFactory_EF_RawMaterial.Save();
GenericFactory_EF_CmnItemMaster.updateMaxID("CmnItemMaster", NextId);
result = ArticleNo + "," + UniqueCode;
//For insert into CmnAccIntegration
CmnACCIntegration modelAccIn = new CmnACCIntegration();
//Int64 NextIdAccIn = GenericFactory_CmnACCIntegration.getMaxVal_int64("ACID", "CmnACCIntegration");
GenericFactoryEF_CmnACCIntegration = new CmnACCIntegration_EF();
Int64 NextIdAccIn = Convert.ToInt64(GenericFactoryEF_CmnACCIntegration.getMaxID("CmnACCIntegration"));
modelAccIn.ACID = NextIdAccIn;
modelAccIn.AcDetailID = accDetailID;
modelAccIn.ACTypeID = ACTypeID;
modelAccIn.CompanyID = model.CompanyID;
modelAccIn.CreateBy = model.CreateBy;
modelAccIn.CreateOn = DateTime.Today;
modelAccIn.CreatePc = HostService.GetIP();
modelAccIn.IsDeleted = false;
modelAccIn.IsActive = true;
modelAccIn.TransactionID = model.ItemID;
GenericFactory_CmnACCIntegration.Insert(modelAccIn);
GenericFactory_CmnACCIntegration.Save();
GenericFactoryEF_CmnACCIntegration.updateMaxID("CmnACCIntegration", NextIdAccIn);
}
catch (Exception ex)
{
ex.ToString();
}
return(result);
}
/// No CompanyID Provided
public int UpdateRawMaterial(CmnItemMaster model)
{
GenericFactory_EF_RawMaterial = new CmnItemMaster_EF();
int result = 0;
try
{
CmnItemMaster _model = GenericFactory_EF_RawMaterial.GetAll().Where(x => x.ItemID == model.ItemID).FirstOrDefault();
//string ArticleNo = SetArticaleNo(model.ItemGroupID);
// _model.ArticleNo = ArticleNo;
_model.UpdateOn = DateTime.Today;
_model.UpdateBy = model.UpdateBy;
_model.UpdatePc = HostService.GetIP();
// _model.ItemTypeID = model.ItemTypeID;
// _model.ItemGroupID = model.ItemGroupID;
_model.ItemName = model.ItemName;
_model.UOMID = model.UOMID;
_model.ItemColorID = model.ItemColorID;
_model.ItemSizeID = model.ItemSizeID;
_model.ItemBrandID = model.ItemBrandID;
_model.ItemModelID = model.ItemModelID;
_model.Description = model.Description;
_model.Note = model.Note;
GenericFactory_EF_RawMaterial.Update(_model);
GenericFactory_EF_RawMaterial.Save();
result = 1;
// For update into CmnAccIntegration
CmnACCIntegration _modelACCIn = GenericFactory_CmnACCIntegration.GetAll().Where(x => x.TransactionID == model.ItemID).FirstOrDefault();
_modelACCIn.UpdateOn = DateTime.Today;
_modelACCIn.UpdateBy = model.UpdateBy;
_modelACCIn.UpdatePc = HostService.GetIP();
GenericFactory_CmnACCIntegration.Update(_modelACCIn);
GenericFactory_CmnACCIntegration.Save();
result = 1;
}
catch (Exception e)
{
e.ToString();
result = 0;
}
return(result);
}
public int UpdateFinishGood(CmnItemMaster _itemMaster, List <vmFinishProcess> _finishing)
{
GenericFactory_EF_CmnItemMaster = new CmnItemMaster_EF();
int result = 0;
try
{
CmnItemMaster _ItemMasterobj = GenericFactory_EF_CmnItemMaster.FindBy(x => x.IsDeleted == false && x.ItemID == _itemMaster.ItemID).FirstOrDefault();
_ItemMasterobj.UpdateOn = DateTime.Today;
_ItemMasterobj.IsDevelopmentComplete = _itemMaster.IsDevelopmentComplete;
_ItemMasterobj.UpdateBy = _itemMaster.CreateBy;
_ItemMasterobj.UpdatePc = HostService.GetIP();
_ItemMasterobj.ArticleNo = _itemMaster.ArticleNo;
_ItemMasterobj.FinishingWeight = _itemMaster.FinishingWeight;
_ItemMasterobj.ItemTypeID = _itemMaster.ItemTypeID;
_ItemMasterobj.WeightPerUnit = _itemMaster.WeightPerUnit;
_ItemMasterobj.FinishingWeightID = _itemMaster.FinishingWeightID;
_ItemMasterobj.ItemGroupID = _itemMaster.ItemGroupID;
_ItemMasterobj.ItemName = _itemMaster.ItemName;
_ItemMasterobj.WarpYarnID = _itemMaster.WarpYarnID;
_ItemMasterobj.BuyerID = _itemMaster.BuyerID;
_ItemMasterobj.WeftYarnID = _itemMaster.WeftYarnID;
_ItemMasterobj.WeftSupplierID = _itemMaster.WeftSupplierID;
_ItemMasterobj.PPI = _itemMaster.PPI;
_ItemMasterobj.ItemColorID = _itemMaster.ItemColorID;
_ItemMasterobj.EPI = _itemMaster.EPI;
_ItemMasterobj.GPPI = _itemMaster.GPPI;
_ItemMasterobj.SetNo = _itemMaster.SetNo;
_ItemMasterobj.FlangeNo = _itemMaster.FlangeNo;
_ItemMasterobj.Weave = _itemMaster.Weave;
_ItemMasterobj.CoatingID = _itemMaster.CoatingID;
_ItemMasterobj.SPCoatingID = _itemMaster.SPCoatingID;
_ItemMasterobj.OverDyedID = _itemMaster.OverDyedID;
_ItemMasterobj.WeftColorID = _itemMaster.WeftColorID;
//_ItemMasterobj.FinishingTypeID = _itemMaster.FinishingTypeID;
_ItemMasterobj.Length = _itemMaster.Length;
_ItemMasterobj.Note = _itemMaster.Note;
_ItemMasterobj.TotalEnds = _itemMaster.TotalEnds;
_ItemMasterobj.Description = _itemMaster.Description;
_ItemMasterobj.BuyerRefID = _itemMaster.BuyerRefID;
_ItemMasterobj.CuttableWidth = _itemMaster.CuttableWidth;
_ItemMasterobj.HSCODE = _itemMaster.HSCODE;
//----------Weaving Info-------------------------------
_ItemMasterobj.WeavingMachineID = _itemMaster.WeavingMachineID;
_ItemMasterobj.WeavingDate = _itemMaster.WeavingDate;
_ItemMasterobj.GWidth = _itemMaster.GWidth;
_ItemMasterobj.WeavingLength = _itemMaster.WeavingLength;
_ItemMasterobj.GGSM = _itemMaster.GGSM;
//--------Finishing Info----------------------------------
_ItemMasterobj.MinLShrinkage = _itemMaster.MinLShrinkage;
_ItemMasterobj.MaxLshrinkage = _itemMaster.MaxLshrinkage;
_ItemMasterobj.MinWshrinkage = _itemMaster.MinWshrinkage;
_ItemMasterobj.MaxWShrinkage = _itemMaster.MaxWShrinkage;
_ItemMasterobj.Skew = _itemMaster.Skew;
_ItemMasterobj.EPI = _itemMaster.EPI;
_ItemMasterobj.PPI = _itemMaster.PPI;
_ItemMasterobj.Cotton = _itemMaster.Cotton;
_ItemMasterobj.Spandex = _itemMaster.Spandex;
_ItemMasterobj.Polyester = _itemMaster.Polyester;
_ItemMasterobj.Lycra = _itemMaster.Lycra;
_ItemMasterobj.FinishingWidth = _itemMaster.FinishingWidth;
_ItemMasterobj.T4100 = _itemMaster.T4100;
_ItemMasterobj.Viscos = _itemMaster.Viscos;
_ItemMasterobj.Modal = _itemMaster.Modal;
_ItemMasterobj.C4100 = _itemMaster.C4100;
_ItemMasterobj.Tencel = _itemMaster.Tencel;
_ItemMasterobj.OtherComp = _itemMaster.OtherComp;
//-----------------------washing Info--------------------------
_ItemMasterobj.MinLShrinkageW = _itemMaster.MinLShrinkageW;
_ItemMasterobj.MaxLshrinkageW = _itemMaster.MaxLshrinkageW;
_ItemMasterobj.MaxWShrinkageW = _itemMaster.MaxWShrinkageW;
_ItemMasterobj.MinWshrinkageW = _itemMaster.MinWshrinkageW;
_ItemMasterobj.SkewW = _itemMaster.SkewW;
_ItemMasterobj.WEPI = _itemMaster.WEPI;
_ItemMasterobj.WPPI = _itemMaster.WPPI;
_ItemMasterobj.WashingWidth = _itemMaster.WashingWidth;
_ItemMasterobj.WashingWeigth = _itemMaster.WashingWeigth;
GenericFactory_EF_CmnItemMaster.Update(_ItemMasterobj);
GenericFactory_EF_CmnItemMaster.Save();
if (_finishing.Count > 0)
{
UpdateFinishingProcess(_finishing, _itemMaster);
}
//Account Intigration
GenericFactoryEF_CmnACCIntegration = new CmnACCIntegration_EF();
if (_itemMaster.AcDetailID == 0)
{
CmnACCIntegration _acc = GenericFactoryEF_CmnACCIntegration.FindBy(x => x.TransactionID == _itemMaster.ItemID && x.IsDeleted == false).FirstOrDefault();
_acc.DeleteBy = Convert.ToInt16(_itemMaster.CreateBy);
_acc.DeleteOn = DateTime.Today;
_acc.DeletePc = HostService.GetIP();
_acc.IsDeleted = true;
GenericFactoryEF_CmnACCIntegration.Update(_acc);
GenericFactoryEF_CmnACCIntegration.Save();
}
if (_itemMaster.AcDetailID != 0)
{
Int64 AccMasterID = Convert.ToInt64(GenericFactoryEF_CmnACCIntegration.getMaxID("CmnACCIntegration"));
CmnACCIntegration _acc = GenericFactoryEF_CmnACCIntegration.FindBy(x => x.TransactionID == _itemMaster.ItemID && x.IsDeleted == false).FirstOrDefault();
_acc.AcDetailID = _itemMaster.AcDetailID;
_acc.IsActive = true;
_acc.IsDeleted = false;
_acc.ACTypeID = 1;
_acc.UpdateBy = Convert.ToInt16(_itemMaster.CreateBy);
_acc.UpdateOn = DateTime.Today;
_acc.UpdatePc = HostService.GetIP();
GenericFactoryEF_CmnACCIntegration.Update(_acc);
GenericFactoryEF_CmnACCIntegration.Save();
GenericFactoryEF_CmnACCIntegration.updateMaxID("", AccMasterID);
}
//Account Intigration
result = 1;
}
catch (Exception ex)
{
result = 0;
}
return(result);
}
