public vmSizeBeamIssue GetSizeBeamIssuemasterDetailByBeamIssueID(int?pageNumber, int?pageSize, int?IsPaging, int?BeamIssueId, int?LoginCompanyID) { GFactory_VM_SetDetail = new PrdSizeBeamIssue_VM(); vmSizeBeamIssue _vmSetDetails = null; string spQuery = string.Empty; try { using (_ctxCmn = new ERP_Entities()) { Hashtable ht = new Hashtable(); ht.Add("CompanyID", LoginCompanyID); ht.Add("LoggedUser", 0); ht.Add("PageNo", 0); ht.Add("RowCountPerPage", 0); ht.Add("IsPaging", 0); ht.Add("BeamIssueID", BeamIssueId); spQuery = "[Get_PrdSizeBeamIssuemasterDetailByBeamIssueID]"; _vmSetDetails = GFactory_VM_SetDetail.ExecuteQuery(spQuery, ht).FirstOrDefault(); } } catch (Exception e) { e.ToString(); } return(_vmSetDetails); }
private Int64 UpdateSizeBeamIssueMaster(vmSizeBeamIssue _objSizeIssueMaster) { GenericFactory_EFSizingBeamIssue = new PrdSizingBeamIssue_EF(); PrdSizingBeamIssue _objPrdSizingBeamIssue = GenericFactory_EFSizingBeamIssue.FindBy(x => x.BeamIssueID == _objSizeIssueMaster.BeamIssueID).FirstOrDefault(); _objPrdSizingBeamIssue.TransactionTypeID = _objSizeIssueMaster.TransactionTypeID; _objPrdSizingBeamIssue.ItemID = _objSizeIssueMaster.ItemID; _objPrdSizingBeamIssue.Setlength = _objSizeIssueMaster.SetLength; _objPrdSizingBeamIssue.SetID = _objSizeIssueMaster.SetID; _objPrdSizingBeamIssue.SizeMRRID = _objSizeIssueMaster.SizeMRRID; _objPrdSizingBeamIssue.WeavingDepartmentID = _objSizeIssueMaster.WeavingDepartmentID; _objPrdSizingBeamIssue.WeavingReceiveDate = _objSizeIssueMaster.WeavingReceiveDate; _objPrdSizingBeamIssue.WeavingReceiveBy = _objSizeIssueMaster.WeavingReceiveBy; _objPrdSizingBeamIssue.WeavingReceivedRemarks = _objSizeIssueMaster.WeavingReceivedRemarks; _objPrdSizingBeamIssue.IsReceivedWeaving = _objSizeIssueMaster.IsReceivedWeaving; //_objPrdSizingBeamIssue.SizeDepartmentID = _objSizeIssueMaster.SizeDepartmentID ?? 0; //_objPrdSizingBeamIssue.IsIssuedSize = _objSizeIssueMaster.IsIssuedSize; //_objPrdSizingBeamIssue.SizeIssueDate = _objSizeIssueMaster.SizeIssueDate; //_objPrdSizingBeamIssue.SizeIssueBy = _objSizeIssueMaster.SizeIssueBy; //_objPrdSizingBeamIssue.SizeIssueRemarks = _objSizeIssueMaster.SizeIssueRemarks; //_objPrdSizingBeamIssue.UpdateBy = _objSizeIssueMaster.CreateBy; // _objPrdSizingBeamIssue.IsDeleted = _objSizeIssueMaster.IsDeleted; GenericFactory_EFSizingBeamIssue.Update(_objPrdSizingBeamIssue); GenericFactory_EFSizingBeamIssue.Save(); return(_objSizeIssueMaster.BeamIssueID); }
private Int64 SaveSizeBeamIssueMaster(vmSizeBeamIssue _objSizeIssueMaster) { Int64 NextId = 0; GenericFactory_EFSizingBeamIssue = new PrdSizingBeamIssue_EF(); NextId = GenericFactory_EFSizingBeamIssue.getMaxVal_int64("BeamIssueID", "PrdSizingBeamIssue"); PrdSizingBeamIssue _prdSizingBeamIssue = new PrdSizingBeamIssue(); _prdSizingBeamIssue.BeamIssueID = NextId; _prdSizingBeamIssue.TransactionTypeID = _objSizeIssueMaster.TransactionTypeID; _prdSizingBeamIssue.BeamIssueNo = NextId.ToString();// BeamIssueno is BeamIssueID _prdSizingBeamIssue.ItemID = _objSizeIssueMaster.ItemID; _prdSizingBeamIssue.Setlength = _objSizeIssueMaster.SetLength; _prdSizingBeamIssue.SetID = _objSizeIssueMaster.SetID; _prdSizingBeamIssue.SizeMRRID = _objSizeIssueMaster.SizeMRRID; _prdSizingBeamIssue.SizeDepartmentID = _objSizeIssueMaster.SizeDepartmentID ?? 0; _prdSizingBeamIssue.IsIssuedSize = _objSizeIssueMaster.IsIssuedSize; _prdSizingBeamIssue.SizeIssueDate = _objSizeIssueMaster.SizeIssueDate; _prdSizingBeamIssue.SizeIssueBy = _objSizeIssueMaster.SizeIssueBy; _prdSizingBeamIssue.SizeIssueRemarks = _objSizeIssueMaster.SizeIssueRemarks; _prdSizingBeamIssue.CompanyID = _objSizeIssueMaster.CompanyID; _prdSizingBeamIssue.CreateBy = _objSizeIssueMaster.CreateBy; _prdSizingBeamIssue.IsDeleted = _objSizeIssueMaster.IsDeleted; _prdSizingBeamIssue.Shade = _objSizeIssueMaster.Shade; _prdSizingBeamIssue.GPL = _objSizeIssueMaster.GPL; GenericFactory_EFSizingBeamIssue.Insert(_prdSizingBeamIssue); GenericFactory_EFSizingBeamIssue.Save(); return(NextId); }
public vmSizeBeamIssue GetSetDeatailBySetNo(int?pageNumber, int?pageSize, int?IsPaging, int?SetNo, int?LoginCompanyID) { vmSizeBeamIssue _setDetailobj = null; try { _objiSizeBeamIssueMgt = new SizeBeamIssueMgt(); _setDetailobj = _objiSizeBeamIssueMgt.GetSetDeatailBySetNo(pageNumber, pageSize, IsPaging, SetNo, LoginCompanyID); } catch (Exception e) { e.ToString(); } return(_setDetailobj); }
public vmSizeBeamIssue GetSizeBeamIssuemasterDetailByBeamIssueID(int?pageNumber, int?pageSize, int?IsPaging, int?BeamIssueId, int?LoginCompanyID) { vmSizeBeamIssue _setDetailobj = null; try { _objiSizeBeamIssueMgt = new SizeBeamIssueMgt(); _setDetailobj = _objiSizeBeamIssueMgt.GetSizeBeamIssuemasterDetailByBeamIssueID(pageNumber, pageSize, IsPaging, BeamIssueId, LoginCompanyID); } catch (Exception e) { e.ToString(); } return(_setDetailobj); }
public int SaveSizeBeamIssue(object[] data) { List <vmSizeBeamIssue> _objSizeIssueDetails = JsonConvert.DeserializeObject <List <vmSizeBeamIssue> >(data[0].ToString()); vmSizeBeamIssue _objSizeIssueMaster = JsonConvert.DeserializeObject <vmSizeBeamIssue>(data[1].ToString()); int result = 0; try { _objiSizeBeamIssueMgt = new SizeBeamIssueMgt(); result = _objiSizeBeamIssueMgt.SaveSizeBeamIssue(_objSizeIssueDetails, _objSizeIssueMaster); } catch (Exception e) { e.ToString(); } return(result); }
public int SaveSizeBeamIssue(List <vmSizeBeamIssue> _objSizeIssueDetails, vmSizeBeamIssue _objSizeIssueMaster) { int result = 0; // using (TransactionScope transaction = new TransactionScope()) //{ try { if (_objSizeIssueMaster.BeamIssueID == 0) { Int64 BeamIssueID = SaveSizeBeamIssueMaster(_objSizeIssueMaster); if (BeamIssueID > 0) { result = SaveSizeBeamIssueMasterDetails(_objSizeIssueDetails, BeamIssueID, _objSizeIssueMaster); } } else { Int64 BeamIssueID = UpdateSizeBeamIssueMaster(_objSizeIssueMaster); if (BeamIssueID > 0) { result = UpdateSizeBeamIssueMasterDetails(_objSizeIssueDetails, BeamIssueID, _objSizeIssueMaster); result = SaveWeavingMachineBook(_objSizeIssueDetails, _objSizeIssueMaster); result = UpdateWeavingMachineConfig(_objSizeIssueDetails); } } } catch (Exception) { throw; } // } return(result); }
private int SaveSizeBeamIssueMasterDetails(List <vmSizeBeamIssue> _objSizeIssueDetails, Int64 BeamIssueID, vmSizeBeamIssue _objSizeIssueMaster) { int status = 0; GenericFactory_EFSizingBeamIssueDetail = new PrdSizingBeamIssueDetail_EF(); try { Int64 NextId = 0; foreach (vmSizeBeamIssue aitem in _objSizeIssueDetails) { NextId = GenericFactory_EFSizingBeamIssueDetail.getMaxVal_int64("BeamIssueDetailID", "PrdSizingBeamIssueDetail"); PrdSizingBeamIssueDetail _prdSizingBeamIssueDetail = new PrdSizingBeamIssueDetail(); _prdSizingBeamIssueDetail.BeamIssueDetailID = NextId; _prdSizingBeamIssueDetail.BeamIssueID = BeamIssueID; _prdSizingBeamIssueDetail.BeamID = aitem.OutputID;// OutputID is the beamID _prdSizingBeamIssueDetail.Length = aitem.LengthYds; if (aitem.BSDate != null) { _prdSizingBeamIssueDetail.BSDate = Convert.ToDateTime(aitem.BSDate).AddDays(1); } else { _prdSizingBeamIssueDetail.BSDate = null; } if (aitem.BMDate != null) { _prdSizingBeamIssueDetail.BMDate = Convert.ToDateTime(aitem.BMDate).AddDays(1); } else { _prdSizingBeamIssueDetail.BMDate = null; } _prdSizingBeamIssueDetail.LoomID = aitem.LoomID; _prdSizingBeamIssueDetail.Totalfabric = aitem.Totalfabric ?? 0; if (aitem.BFDate != null) { _prdSizingBeamIssueDetail.BFDate = Convert.ToDateTime(aitem.BFDate).AddDays(1); } else { _prdSizingBeamIssueDetail.BFDate = null; } _prdSizingBeamIssueDetail.CompanyID = _objSizeIssueMaster.CompanyID; _prdSizingBeamIssueDetail.CreateBy = _objSizeIssueMaster.CreateBy; _prdSizingBeamIssueDetail.IsDeleted = _objSizeIssueMaster.IsDeleted; GenericFactory_EFSizingBeamIssueDetail.Insert(_prdSizingBeamIssueDetail); GenericFactory_EFSizingBeamIssueDetail.Save(); } status = 1; } catch { } return(status); }
private int UpdateSizeBeamIssueMasterDetails(List <vmSizeBeamIssue> _objSizeIssueDetails, long BeamIssueID, vmSizeBeamIssue _objSizeIssueMaster) { try { GenericFactory_EFSizingBeamIssueDetail = new PrdSizingBeamIssueDetail_EF(); foreach (vmSizeBeamIssue aitem in _objSizeIssueDetails) { PrdSizingBeamIssueDetail _prdSizingBeamIssueDetail = GenericFactory_EFSizingBeamIssueDetail.FindBy(x => x.BeamIssueDetailID == aitem.BeamIssueDetailID).FirstOrDefault(); _prdSizingBeamIssueDetail.BeamIssueID = BeamIssueID; _prdSizingBeamIssueDetail.BeamID = aitem.OutputID;// OutputID is the beamID _prdSizingBeamIssueDetail.Length = aitem.LengthYds; if (aitem.BSDate != null) { _prdSizingBeamIssueDetail.BSDate = Convert.ToDateTime(aitem.BSDate).AddDays(1); } else { _prdSizingBeamIssueDetail.BSDate = null; } if (aitem.BMDate != null) { _prdSizingBeamIssueDetail.BMDate = Convert.ToDateTime(aitem.BMDate).AddDays(1); } else { _prdSizingBeamIssueDetail.BMDate = null; } _prdSizingBeamIssueDetail.LoomID = aitem.LoomID; _prdSizingBeamIssueDetail.Totalfabric = aitem.Totalfabric ?? 0; if (aitem.BFDate != null) { _prdSizingBeamIssueDetail.BFDate = Convert.ToDateTime(aitem.BFDate).AddDays(1); } else { _prdSizingBeamIssueDetail.BFDate = null; } _prdSizingBeamIssueDetail.UpdateBy = _objSizeIssueMaster.CreateBy; // _prdSizingBeamIssueDetail. GenericFactory_EFSizingBeamIssueDetail.Update(_prdSizingBeamIssueDetail); GenericFactory_EFSizingBeamIssueDetail.Save(); } } catch (Exception) { throw; } return(1); }
private int SaveWeavingMachineBook(List <vmSizeBeamIssue> _objSizeIssueDetails, vmSizeBeamIssue _objSizeIssueMaster) { try { Int64 NextId = 0; GenericFactory_EFWeavingMachineBook = new PrdWeavingMachineBook_EF(); foreach (vmSizeBeamIssue aitem in _objSizeIssueDetails) { NextId = GenericFactory_EFWeavingMachineBook.getMaxVal_int64("MachineBookID", "PrdWeavingMachineBook"); PrdWeavingMachineBook _prdWeavingMachineBook = new PrdWeavingMachineBook(); _prdWeavingMachineBook.MachineBookID = NextId; _prdWeavingMachineBook.MachineConfigID = Convert.ToInt64(aitem.LoomID); _prdWeavingMachineBook.BeamIssueDetailID = aitem.BeamIssueDetailID; _prdWeavingMachineBook.ItemID = _objSizeIssueMaster.ItemID; _prdWeavingMachineBook.SetID = _objSizeIssueMaster.SetID; _prdWeavingMachineBook.SizeMRRID = _objSizeIssueMaster.SizeMRRID; if (aitem.BFDate != null) { _prdWeavingMachineBook.BookingDate = Convert.ToDateTime(aitem.BFDate).AddDays(1); } else { _prdWeavingMachineBook.BookingDate = null; } _prdWeavingMachineBook.Remarks = aitem.Remarks; _prdWeavingMachineBook.CompanyID = aitem.CompanyID; _prdWeavingMachineBook.IsDeleted = _objSizeIssueMaster.IsDeleted; GenericFactory_EFWeavingMachineBook.Insert(_prdWeavingMachineBook); GenericFactory_EFWeavingMachineBook.Save(); } return(1); } catch (Exception) { throw; } }