public vmSetSetupMasterDetail GetSetDetailsBySetNo(int?pageNumber, int?pageSize, int?IsPaging, int?SetNo) { vmSetSetupMasterDetail _vmSetSetupMasterDetails = null; string spQuery = string.Empty; try { using (_ctxCmn = new ERP_Entities()) { Hashtable ht = new Hashtable(); ht.Add("CompanyID", 0); ht.Add("LoggedUser", 0); ht.Add("PageNo", 0); ht.Add("RowCountPerPage", 0); ht.Add("IsPaging", 0); ht.Add("SetID", SetNo); spQuery = "[GetPrdSetDetails]"; _vmSetSetupMasterDetails = GFactory_VM_PrdSetSetupMasterDetail.ExecuteQuery(spQuery, ht).FirstOrDefault(); } } catch (Exception e) { e.ToString(); } return(_vmSetSetupMasterDetails); }
public List <vmIssueDetail> GetIssueDetailBySetNO(int?pageNumber, int?pageSize, int?IsPaging, int?SetNo) { List <vmIssueDetail> _vmIssueDetails = null; string spQuery = string.Empty; try { using (_ctxCmn = new ERP_Entities()) { Hashtable ht = new Hashtable(); ht.Add("CompanyID", 1); ht.Add("LoggedUser", 0); ht.Add("PageNo", 0); ht.Add("RowCountPerPage", 0); ht.Add("IsPaging", 0); ht.Add("SetID", SetNo); spQuery = "[GetPrdIssueDeails]"; _vmIssueDetails = GFactory_VM_prdIssueDetail.ExecuteQuery(spQuery, ht).ToList(); } } catch (Exception e) { e.ToString(); } return(_vmIssueDetails); }
public List <vmWeavingGriage> WeavingGriageDetails(vmCmnParameters objcmnParam, out int recordsTotal) { GFactory_VM_WeavingMacheGrieage = new preWeavingMachineGriage_VM(); List <vmWeavingGriage> _objWeavingGriages = null; string spQuery = string.Empty; recordsTotal = 0; try { using (_ctxCmn = new ERP_Entities()) { Hashtable ht = new Hashtable(); ht.Add("CompanyID", objcmnParam.loggedCompany); ht.Add("LoggedUser", objcmnParam.loggeduser); ht.Add("PageNo", objcmnParam.pageNumber); ht.Add("RowCountPerPage", objcmnParam.pageSize); ht.Add("IsPaging", objcmnParam.IsPaging); spQuery = "[Get_PrdWeavingGriageDetails]"; _objWeavingGriages = GFactory_VM_WeavingMacheGrieage.ExecuteQuery(spQuery, ht).ToList(); recordsTotal = _ctxCmn.PrdWeavingMRRMasters.Count(); } } catch (Exception e) { e.ToString(); } return(_objWeavingGriages); }
public IEnumerable <vmChallan> GetPOMasterList(vmCmnParameters objcmnParam, out int recordsTotal) { GenericFactory_GF_vmChallan = new vmChallan_GF(); string spQuery = ""; IEnumerable <vmChallan> lstPOMaster = null; recordsTotal = 0; try { Hashtable ht = new Hashtable(); ht.Add("CompanyID", objcmnParam.loggedCompany); ht.Add("LoggedUser", objcmnParam.loggeduser); ht.Add("PageNo", objcmnParam.pageNumber); ht.Add("RowCountPerPage", objcmnParam.pageSize); ht.Add("IsPaging", objcmnParam.IsPaging); spQuery = "[Get_PurPOList]"; lstPOMaster = GenericFactory_GF_vmChallan.ExecuteQuery(spQuery, ht); // recordsTotal = lstPOMaster.Count(); recordsTotal = (int)lstPOMaster.FirstOrDefault().RecordTotal; } catch (Exception e) { e.ToString(); } return(lstPOMaster); }
public IEnumerable <vmChallan> GetItmDetailByItmCode(vmCmnParameters objcmnParam, string ItemCode) { GenericFactory_GF_vmChallan = new vmChallan_GF(); string spQuery = ""; IEnumerable <vmChallan> lstItemDetailByItmCode = null; // recordsTotal = 0; try { Hashtable ht = new Hashtable(); ht.Add("CompanyID", objcmnParam.loggedCompany); ht.Add("LoggedUser", objcmnParam.loggeduser); ht.Add("PageNo", objcmnParam.pageNumber); ht.Add("RowCountPerPage", objcmnParam.pageSize); ht.Add("IsPaging", objcmnParam.IsPaging); ht.Add("ArticleNo", ItemCode); spQuery = "[Get_InvChallanItemByItemCode]"; lstItemDetailByItmCode = GenericFactory_GF_vmChallan.ExecuteQuery(spQuery, ht); // recordsTotal = lstMasterInfoByGrrNo.Count(); } catch (Exception e) { e.ToString(); } return(lstItemDetailByItmCode); }
public List <vmFinishingInspactionDetail> GetQAMasterList(vmCmnParameters objcmnParam, out int recordsTotal) { List <vmFinishingInspactionDetail> _objQAMasterList = null; recordsTotal = 0; try { using (_ctxCmn = new ERP_Entities()) { GenericFactory_FabricINspectionMaster_vm = new vmFinishingInspactionDetail_VM(); string spQuery = string.Empty; Hashtable ht = new Hashtable(); ht.Add("CompanyID", objcmnParam.loggedCompany); ht.Add("LoggedUser", objcmnParam.loggeduser); ht.Add("PageNo", objcmnParam.pageNumber); ht.Add("RowCountPerPage", objcmnParam.pageSize); ht.Add("IsPaging", objcmnParam.IsPaging); spQuery = "[Get_FinishingQAMaster]"; _objQAMasterList = GenericFactory_FabricINspectionMaster_vm.ExecuteQuery(spQuery, ht).ToList(); recordsTotal = _ctxCmn.PrdFinishingQAMasters.Where(x => x.CompanyID == objcmnParam.loggedCompany && x.IsDeleted == false).Count(); } } catch (Exception e) { e.ToString(); } return(_objQAMasterList); }
public IEnumerable <vmQC> GetDetailInfoByLoanSprID(vmCmnParameters objcmnParam, Int64 LoanSprID, out int recordsTotal) { GenericFactory_GF_vmQC = new vmQC_GF(); string spQuery = ""; IEnumerable <vmQC> lstQCByGrrNo = null; recordsTotal = 0; try { Hashtable ht = new Hashtable(); ht.Add("CompanyID", objcmnParam.selectedCompany); ht.Add("LoggedUser", objcmnParam.loggeduser); ht.Add("PageNo", objcmnParam.pageNumber); ht.Add("RowCountPerPage", objcmnParam.pageSize); ht.Add("IsPaging", objcmnParam.IsPaging); ht.Add("LoanSprID", LoanSprID); // spQuery = "[Get_InvPOItemDetailByQCID]"; spQuery = "[Get_InvItemsDetailByLoanSprID]"; lstQCByGrrNo = GenericFactory_GF_vmQC.ExecuteQuery(spQuery, ht); recordsTotal = lstQCByGrrNo.Count(); } catch (Exception e) { e.ToString(); } return(lstQCByGrrNo); }
public IEnumerable <vmPrdWeavingMachineConfigMasterDetail> GetWeavingMachineConfigMaster(vmCmnParameters objcmnParam, out int recordsTotal) { GenericFactory_vmPrdWeavingMachineConfigMasterDetail_GF = new vmPrdWeavingMachineConfigMasterDetail_GF(); IEnumerable <vmPrdWeavingMachineConfigMasterDetail> WMCMaster = null; recordsTotal = 0; string spQuery = string.Empty; try { Hashtable ht = new Hashtable(); ht.Add("CompanyID", objcmnParam.loggedCompany); ht.Add("LoggedUser", objcmnParam.loggeduser); ht.Add("PageNo", objcmnParam.pageNumber); ht.Add("RowCountPerPage", objcmnParam.pageSize); ht.Add("IsPaging", objcmnParam.IsPaging); spQuery = "[Get_WeavingMachinConfigMaster]"; WMCMaster = GenericFactory_vmPrdWeavingMachineConfigMasterDetail_GF.ExecuteQuery(spQuery, ht); recordsTotal = (int)WMCMaster.FirstOrDefault().recordsTotal; } catch (Exception e) { e.ToString(); } return(WMCMaster); }
public IEnumerable <vmSetMaster> GetSetSetupMaster(vmCmnParameters objcmnParam, out int recordsTotal) { GFactory_VM_PrdSetMaster = new PrdSetMaster_VM(); IEnumerable <vmSetMaster> objSetMaster = null; string spQuery = string.Empty; recordsTotal = 0; try { using (_ctxCmn = new ERP_Entities()) { Hashtable ht = new Hashtable(); ht.Add("CompanyID", objcmnParam.loggedCompany); ht.Add("LoggedUser", objcmnParam.loggeduser); ht.Add("PageNo", objcmnParam.pageNumber); ht.Add("RowCountPerPage", objcmnParam.pageSize); ht.Add("IsPaging", objcmnParam.IsPaging); spQuery = "[Get_SetMaster]"; objSetMaster = GFactory_VM_PrdSetMaster.ExecuteQuery(spQuery, ht); recordsTotal = _ctxCmn.PrdSetMasters.Where(x => x.CompanyID == objcmnParam.loggedCompany && x.IsDeleted == false).Count();//objSetMaster.Count(); } } catch (Exception e) { e.ToString(); } return(objSetMaster); }
public IEnumerable <vmStockMaster> GetAllStockItems(vmCmnParameters objcmnParam, out int recordsTotal) { GenericFactory_EF_Stock = new vmStockMaster_GF(); IEnumerable <vmStockMaster> objStock = null; string spQuery = string.Empty; recordsTotal = 0; try { Hashtable ht = new Hashtable(); ht.Add("itemTypeID", objcmnParam.ItemType); ht.Add("ItemGroupID", objcmnParam.ItemGroup); ht.Add("itemID", null); ht.Add("BatchID", null); ht.Add("LotID", null); ht.Add("GradeID", null); ht.Add("CompanyID", objcmnParam.loggedCompany); ht.Add("DepartmentID", objcmnParam.DepartmentID); ht.Add("PageNo", objcmnParam.pageNumber); ht.Add("RowCountPerPage", objcmnParam.pageNumber); ht.Add("IsPaging", objcmnParam.IsPaging); // spQuery = "[Get_AllStockItems]"; spQuery = "[sp_getStockInfo]"; objStock = GenericFactory_EF_Stock.ExecuteQuery(spQuery, ht); } catch (Exception e) { e.ToString(); } return(objStock); }
//------------- public List <vmSizeBeamIssue> GetSizingMRRMasterDetailByBeamIssueID(int?pageNumber, int?pageSize, int?IsPaging, int?BeamIssueId, int?LoginCompanyID) { GFactory_VM_SetDetail = new PrdSizeBeamIssue_VM(); List <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_PrdSizingMRRMasterDetailByBeamIssueID]"; _vmSetDetails = GFactory_VM_SetDetail.ExecuteQuery(spQuery, ht).ToList(); } } catch (Exception e) { e.ToString(); } return(_vmSetDetails); }
//public vmFinishingPackingListMasterDetail GetPIBasedData(vmCmnParameters objcmnParam) //{ // vmFinishingPackingListMasterDetail PIData = null; // try // { // GenericFactory_vmFinishingPackingListMasterDetail_GF = new vmFinishingPackingListDetail_GF(); // string spQuery = string.Empty; // Hashtable ht = new Hashtable(); // ht.Add("CompanyID", objcmnParam.loggedCompany); // ht.Add("LoggedUser", objcmnParam.loggeduser); // ht.Add("PIID", objcmnParam.id); // ht.Add("PackingID", objcmnParam.ItemType); // spQuery = "[Get_FinishingPackingPIBasedData]"; // PIData = GenericFactory_vmFinishingPackingListMasterDetail_GF.ExecuteQuerySingle(spQuery, ht); // } // catch (Exception e) // { // e.ToString(); // } // return PIData; //} public List <vmFinishingPackingListMasterDetail> GetPackingMasterList(vmCmnParameters objcmnParam, out int recordsTotal) { GenericFactory_vmFinishingPackingListMasterDetail_GF = new vmFinishingPackingListDetail_GF(); List <vmFinishingPackingListMasterDetail> ListPMaster = null; string spQuery = string.Empty; recordsTotal = 0; try { using (_ctxCmn = new ERP_Entities()) { Hashtable ht = new Hashtable(); ht.Add("CompanyID", objcmnParam.loggedCompany); ht.Add("LoggedUser", objcmnParam.loggeduser); ht.Add("PageNo", objcmnParam.pageNumber); ht.Add("RowCountPerPage", objcmnParam.pageSize); ht.Add("IsPaging", objcmnParam.IsPaging); spQuery = "[Get_PackingMasterList]"; ListPMaster = GenericFactory_vmFinishingPackingListMasterDetail_GF.ExecuteQuery(spQuery, ht).ToList(); recordsTotal = _ctxCmn.PrdFinishingPackingLists.Where(x => x.CompanyID == objcmnParam.loggedCompany && x.IsDeleted == false).Count(); } } catch (Exception e) { e.ToString(); } return(ListPMaster); }
/// CompanyID Provided but Static public vmFinishGood GetRawMaterial(int id, int typeId, int companyId) { GenericFactoryFor_FabricDevelopment = new FabricDevelopment_EF(); vmFinishGood _objFinishGood = null; string spQuery = string.Empty; try { using (_ctxCmn = new ERP_Entities()) { Hashtable ht = new Hashtable(); ht.Add("CompanyID", companyId); ht.Add("LoggedUser", 0); ht.Add("PageNo", 0); ht.Add("RowCountPerPage", 0); ht.Add("IsPaging", 0); ht.Add("ItemTypeID", typeId); ht.Add("ItemGroupID", 0); ht.Add("ItemID", id); spQuery = "[SPGetItemDetail]"; _objFinishGood = GenericFactoryFor_FabricDevelopment.ExecuteQuery(spQuery, ht).FirstOrDefault(); } } catch (Exception e) { e.ToString(); } return(_objFinishGood); }
public List <vmFinishGood> GetAllRowMaterial(vmCmnParameters objcmnParam, out int recordsTotal) { GenericFactoryFor_FabricDevelopment = new FabricDevelopment_EF(); List <vmFinishGood> _objvmItemGroup = null; string spQuery = string.Empty; recordsTotal = 0; try { using (_ctxCmn = new ERP_Entities()) { Hashtable ht = new Hashtable(); ht.Add("CompanyID", objcmnParam.loggedCompany); ht.Add("LoggedUser", objcmnParam.loggeduser); ht.Add("PageNo", objcmnParam.pageNumber); ht.Add("RowCountPerPage", objcmnParam.pageSize); ht.Add("IsPaging", objcmnParam.IsPaging); ht.Add("ItemTypeID", objcmnParam.ItemType); spQuery = "[SPGetItemDetail]"; _objvmItemGroup = GenericFactoryFor_FabricDevelopment.ExecuteQuery(spQuery, ht).ToList(); recordsTotal = _ctxCmn.CmnItemMasters.Where(x => x.ItemTypeID == objcmnParam.ItemType).Count(); } } catch (Exception e) { e.ToString(); } return(_objvmItemGroup); }
public IEnumerable <vmGrr> GetMrrMasterList(vmCmnParameters objcmnParam, out int recordsTotal) { GenericFactory_GF_vmGrr = new vmGrr_GF(); string spQuery = ""; IEnumerable <vmGrr> lstMrrMaster = null; recordsTotal = 0; try { Hashtable ht = new Hashtable(); ht.Add("CompanyID", objcmnParam.loggedCompany); ht.Add("LoggedUser", objcmnParam.loggeduser); ht.Add("PageNo", objcmnParam.pageNumber); ht.Add("RowCountPerPage", objcmnParam.pageSize); ht.Add("IsPaging", objcmnParam.IsPaging); ht.Add("TransactionTypeID", objcmnParam.tTypeId); spQuery = "[Get_InvMrrMasterInfo]"; lstMrrMaster = GenericFactory_GF_vmGrr.ExecuteQuery(spQuery, ht); recordsTotal = (int)lstMrrMaster.FirstOrDefault().RecordTotal; } catch (Exception e) { e.ToString(); } return(lstMrrMaster); }
/// No CompanyID Provided /// <summary> /// Get Data From Database /// <para>Use it when to retive data through a stored procedure</para> /// </summary> public IEnumerable <vmCmnModule> GetModules(int?companyID, int?userID, int?pageNumber, int?pageSize, int?IsPaging) { GenericFactoryFor_Module = new vmCmnModule_GF(); IEnumerable <vmCmnModule> objModules = null; string spQuery = string.Empty; try { Hashtable ht = new Hashtable(); ht.Add("companyID", companyID); ht.Add("userID", userID); ht.Add("pageNumber", pageNumber); ht.Add("pageSize", pageSize); ht.Add("IsPaging", IsPaging); spQuery = "[Get_CmnModule]"; objModules = GenericFactoryFor_Module.ExecuteQuery(spQuery, ht); } catch (Exception e) { e.ToString(); } return(objModules); }
//public int SaveUpdateFebricInspection(PrdFinishingInspactionMaster _objFinishingInspactionMaster, List<vmFinishingInspactionDetail> _objNewInspactionDetails, List<vmFinishingInspactionDetail> _objDeleteInsPectiondetails, vmCmnParameters objcmnParam) //{ // Int64 InspactionID = 0; // Int64 InspactionDateilID = 0; // int status = 0; // try // { // if (_objFinishingInspactionMaster.InspactionID == 0) // { // InspactionID = SaveInspactionMaster(_objFinishingInspactionMaster, objcmnParam); // if (InspactionID > 0) // { // InspactionDateilID = SaveInspactionDetail(_objNewInspactionDetails, _objFinishingInspactionMaster, InspactionID, objcmnParam); // if (InspactionDateilID > 0) // { // status = 1; // } // } // } // else // { // status = UpdateFebricInspection(_objNewInspactionDetails, _objDeleteInsPectiondetails, _objFinishingInspactionMaster, objcmnParam); // } // } // catch(Exception e) // { // status = 0; // e.ToString(); // } // return status; //} //private int UpdateFebricInspection(List<vmFinishingInspactionDetail> _objInspactionDetailsList, List<vmFinishingInspactionDetail> _objDeleteInsPectiondetails, PrdFinishingInspactionMaster _objFinishingInspactionMaster, vmCmnParameters objcmnParam) //{ // int status = 0; // try // { // if (_objInspactionDetailsList.Count > 0) // { // SaveInspactionDetail(_objInspactionDetailsList, _objFinishingInspactionMaster, _objFinishingInspactionMaster.InspactionID, objcmnParam); // } // if (_objInspactionDetailsList.Count > 0) // { // UpdateInspactionDetail(_objInspactionDetailsList, _objFinishingInspactionMaster, objcmnParam); // } // if (_objDeleteInsPectiondetails.Count > 0) // { // DeleteInspactionDetail(_objDeleteInsPectiondetails, _objFinishingInspactionMaster, objcmnParam); // } // status = 1; // } // catch(Exception e) // { // status = 0; // e.ToString(); // } // return status; //} //private int DeleteInspactionDetail(List<vmFinishingInspactionDetail> _objDeleteInsPectiondetails, PrdFinishingInspactionMaster _objFinishingInspactionMaster, vmCmnParameters objcmnParam) //{ // int status = 0; // try // { // GenericFactory_EFFinishingInspactionDetails = new PrdFinishingInspactionDetail_EF(); // foreach (vmFinishingInspactionDetail aitem in _objDeleteInsPectiondetails) // { // PrdFinishingInspactionDetail _FabricInspactionDetail = GenericFactory_EFFinishingInspactionDetails.GetAll().Where(x => x.InspactionDateilID == aitem.InspactionDateilID).FirstOrDefault(); // _FabricInspactionDetail.DeleteBy = objcmnParam.loggeduser; // _FabricInspactionDetail.IsDeleted = true; // _FabricInspactionDetail.DeleteOn = DateTime.Now; // _FabricInspactionDetail.DeletePc = HostService.GetIP(); // GenericFactory_EFFinishingInspactionDetails.Update(_FabricInspactionDetail); // GenericFactory_EFFinishingInspactionDetails.Save(); // } // status = 1; // } // catch(Exception e) // { // e.ToString(); // } // return status; //} //private int UpdateInspactionDetail(List<vmFinishingInspactionDetail> _objUpdateInspectionDetails, PrdFinishingInspactionMaster _objFinishingInspactionMaster, vmCmnParameters objcmnParam) //{ // int status = 0; // try // { // GenericFactory_EFFinishingInspactionDetails = new PrdFinishingInspactionDetail_EF(); // foreach (vmFinishingInspactionDetail aitem in _objUpdateInspectionDetails.Where(x => x.ModelStatus == "Update")) // { // PrdFinishingInspactionDetail _FabricInspactionDetail = GenericFactory_EFFinishingInspactionDetails.GetAll().Where(x => x.InspactionDateilID == aitem.InspactionDateilID).FirstOrDefault(); // _FabricInspactionDetail.BeamNo = aitem.BeamNo; // _FabricInspactionDetail.RollNo = aitem.RollNo; // _FabricInspactionDetail.Length = aitem.GreigeLength; // _FabricInspactionDetail.Piece = aitem.Piece; // _FabricInspactionDetail.DefecetPointID = aitem.DefectPoint; // _FabricInspactionDetail.GrossWeight = aitem.GrossWt; // _FabricInspactionDetail.NetWeight = aitem.NetWt; // _FabricInspactionDetail.Remarks = aitem.Remarks; // _FabricInspactionDetail.UpdateBy = objcmnParam.loggeduser; // _FabricInspactionDetail.UpdateOn = DateTime.Now; // _FabricInspactionDetail.UpdatePc = HostService.GetIP(); // GenericFactory_EFFinishingInspactionDetails.Update(_FabricInspactionDetail); // GenericFactory_EFFinishingInspactionDetails.Save(); // } // status = 1; // } // catch(Exception e) // { // e.ToString(); // } // return status; //} //private Int64 SaveInspactionDetail(List<vmFinishingInspactionDetail> _objNewInspactionDetails, PrdFinishingInspactionMaster _objFinishingInspactionMaster, Int64 InspactionID, vmCmnParameters objcmnParam) //{ // GenericFactory_EFFinishingInspactionDetails = new PrdFinishingInspactionDetail_EF(); // Int64 NextId = 0; // NextId = GenericFactory_EFFinishingInspactionDetails.getMaxVal_int64("InspactionDateilID", "PrdFinishingInspactionDetail"); // foreach (vmFinishingInspactionDetail aitem in _objNewInspactionDetails.Where(x=>x.ModelStatus=="New")) // { // PrdFinishingInspactionDetail _objInspactionDetail = new PrdFinishingInspactionDetail(); // _objInspactionDetail.InspactionDateilID = NextId; // _objInspactionDetail.InspactionID = InspactionID; // _objInspactionDetail.BeamNo = aitem.BeamNo; // _objInspactionDetail.RollNo = aitem.RollNo; // _objInspactionDetail.Length = aitem.GreigeLength; // _objInspactionDetail.Piece = aitem.Piece; // _objInspactionDetail.DefecetPointID = aitem.DefectPoint; // _objInspactionDetail.GrossWeight = aitem.GrossWt; // _objInspactionDetail.NetWeight = aitem.NetWt; // _objInspactionDetail.Remarks = aitem.Remarks; // _objInspactionDetail.CompanyID = objcmnParam.loggedCompany; // _objInspactionDetail.CreateBy = objcmnParam.loggeduser; // _objInspactionDetail.CreateOn = DateTime.Now; // _objInspactionDetail.CreatePc = HostService.GetIP(); // _objInspactionDetail.IsDeleted = false; // GenericFactory_EFFinishingInspactionDetails.Insert(_objInspactionDetail); // GenericFactory_EFFinishingInspactionDetails.Save(); // NextId++; // } // return NextId; //} //private Int64 SaveInspactionMaster(PrdFinishingInspactionMaster _objFinishingInspactionMaster, vmCmnParameters objcmnParam) //{ // Int64 status = 0; // Int64 NextId = 0; // try // { // GenericFactory_EFFinishingInspactionMaster = new PrdFinishingInspactionMaster_EF(); // NextId = GenericFactory_EFFinishingInspactionMaster.getMaxVal_int64("InspactionID", "PrdFinishingInspactionMaster"); // _objFinishingInspactionMaster.InspactionID = NextId; // _objFinishingInspactionMaster.InspactionNo = NextId.ToString(); // _objFinishingInspactionMaster.CompanyID = objcmnParam.loggedCompany; // _objFinishingInspactionMaster.CreateBy = objcmnParam.loggeduser; // _objFinishingInspactionMaster.CreateOn = DateTime.Now; // _objFinishingInspactionMaster.CreatePc = HostService.GetIP(); // _objFinishingInspactionMaster.IsDeleted = false; // _objFinishingInspactionMaster.IsQAComplete = false; // GenericFactory_EFFinishingInspactionMaster.Insert(_objFinishingInspactionMaster); // GenericFactory_EFFinishingInspactionMaster.Save(); // status = NextId; // } // catch(Exception e) // { // e.ToString(); // } // return status; //} public List <vmFabricInspectionMaster> FabricInspectionDetails(vmCmnParameters objcmnParam, out int recordsTotal) { GenericFactory_FabricINspectionMaster = new PrdFabricInspectionMaster_VM(); List <vmFabricInspectionMaster> _objFabricInspectionMasters = null; string spQuery = string.Empty; recordsTotal = 0; try { using (_ctxCmn = new ERP_Entities()) { Hashtable ht = new Hashtable(); ht.Add("CompanyID", objcmnParam.loggedCompany); ht.Add("LoggedUser", objcmnParam.loggeduser); ht.Add("PageNo", objcmnParam.pageNumber); ht.Add("RowCountPerPage", objcmnParam.pageSize); ht.Add("IsPaging", objcmnParam.IsPaging); spQuery = "[Get_FabricInspectionDetails]"; _objFabricInspectionMasters = GenericFactory_FabricINspectionMaster.ExecuteQuery(spQuery, ht).ToList(); recordsTotal = _ctxCmn.PrdWeavingMachinConfigs.Where(x => x.CompanyID == objcmnParam.loggedCompany && x.IsDeleted == false).Count(); } } catch (Exception e) { e.ToString(); } return(_objFabricInspectionMasters); }
public IEnumerable <vmSetSetupMasterDetail> GetSetSetupDetailByID(vmCmnParameters objcmnParam, out int recordsTotal) { GFactory_VM_PrdSetSetupMasterDetail = new PrdSetSetupMasterDetail_VM(); IEnumerable <vmSetSetupMasterDetail> objSetDetail = null; recordsTotal = 0; string spQuery = string.Empty; try { using (_ctxCmn = new ERP_Entities()) { Hashtable ht = new Hashtable(); ht.Add("SetMasterID", objcmnParam.id); spQuery = "[Get_SetDetailByID]"; objSetDetail = GFactory_VM_PrdSetSetupMasterDetail.ExecuteQuery(spQuery, ht); } } catch (Exception e) { e.ToString(); } return(objSetDetail); }
public IEnumerable <vmWastageMasterDetail> GetWastageDetailByID(vmCmnParameters objcmnParam, out int recordsTotal) { GenericFactory_vmWastageMasterDetail_VM = new vmWastageMasterDetail_VM(); IEnumerable <vmWastageMasterDetail> WastageDetailByID = null; recordsTotal = 0; string spQuery = string.Empty; try { using (_ctxCmn = new ERP_Entities()) { Hashtable ht = new Hashtable(); ht.Add("CompanyID", objcmnParam.loggedCompany); ht.Add("LoggedUser", objcmnParam.loggeduser); ht.Add("PageNo", objcmnParam.pageNumber); ht.Add("RowCountPerPage", objcmnParam.pageSize); ht.Add("IsPaging", objcmnParam.IsPaging); ht.Add("WastageID", objcmnParam.id); spQuery = "[Get_WastageMRRDetailByID]"; WastageDetailByID = GenericFactory_vmWastageMasterDetail_VM.ExecuteQuery(spQuery, ht); recordsTotal = WastageDetailByID.Count(); } } catch (Exception e) { e.ToString(); } return(WastageDetailByID); }
public List <vmPrdWeavingMachineConfigMasterDetail> GetMntMachineMaintenanceOrde(vmCmnParameters objcmnParam, out int recordsTotal) { GenericFactory_vmPrdWeavingMachineConfigMasterDetail = new vmPrdWeavingMachineConfigMasterDetail_GF(); List <vmPrdWeavingMachineConfigMasterDetail> _objWeavingMachine = null; string spQuery = string.Empty; recordsTotal = 0; try { using (_ctxCmn = new ERP_Entities()) { Hashtable ht = new Hashtable(); ht.Add("CompanyID", objcmnParam.loggedCompany); ht.Add("LoggedUser", objcmnParam.loggeduser); ht.Add("PageNo", objcmnParam.pageNumber); ht.Add("RowCountPerPage", objcmnParam.pageSize); ht.Add("IsPaging", objcmnParam.IsPaging); ht.Add("IsTrue", objcmnParam.IsTrue); spQuery = "[Get_MntMachineMaintenanceOrder]"; _objWeavingMachine = GenericFactory_vmPrdWeavingMachineConfigMasterDetail.ExecuteQuery(spQuery, ht).ToList(); recordsTotal = _ctxCmn.MntMachineMaintenanceOrders.Count(); } } catch (Exception e) { e.ToString(); } return(_objWeavingMachine); }
public IEnumerable <vmQC> GetQCListByGrrNo(vmCmnParameters objcmnParam, Int64 grrID, out int recordsTotal) { GenericFactory_GF_vmQC = new vmQC_GF(); string spQuery = ""; IEnumerable <vmQC> lstQCByGrrNo = null; recordsTotal = 0; try { Hashtable ht = new Hashtable(); ht.Add("CompanyID", objcmnParam.loggedCompany); ht.Add("LoggedUser", objcmnParam.loggeduser); ht.Add("PageNo", objcmnParam.pageNumber); ht.Add("RowCountPerPage", objcmnParam.pageSize); ht.Add("IsPaging", objcmnParam.IsPaging); ht.Add("GrrID", grrID); spQuery = "[Get_InvQCByGrrPostType]"; lstQCByGrrNo = GenericFactory_GF_vmQC.ExecuteQuery(spQuery, ht); recordsTotal = lstQCByGrrNo.Count(); } catch (Exception e) { e.ToString(); } return(lstQCByGrrNo); }
public List <vmWeavingLine> GetWeavingMachineConfigurations(vmCmnParameters objcmnParam, out int recordsTotal) { GenericFactory_PrdWeavingLine_vm = new PrdWeavingLine_VM(); List <vmWeavingLine> _objWeavingMachine = null; string spQuery = string.Empty; recordsTotal = 0; try { using (_ctxCmn = new ERP_Entities()) { Hashtable ht = new Hashtable(); ht.Add("CompanyID", objcmnParam.loggedCompany); ht.Add("LoggedUser", objcmnParam.loggeduser); ht.Add("PageNo", objcmnParam.pageNumber); ht.Add("RowCountPerPage", objcmnParam.pageSize); ht.Add("IsPaging", objcmnParam.IsPaging); spQuery = "[Get_PrdWeavingMachingConfig]"; _objWeavingMachine = GenericFactory_PrdWeavingLine_vm.ExecuteQuery(spQuery, ht).ToList(); recordsTotal = _ctxCmn.PrdWeavingMachinConfigs.Count(); } } catch (Exception e) { e.ToString(); } return(_objWeavingMachine); }
public IEnumerable <vmQC> GetMrrDetailsListByMrrID(vmCmnParameters objcmnParam, Int64 mrrID, out int recordsTotal) { GenericFactory_GF_vmQC = new vmQC_GF(); string spQuery = ""; IEnumerable <vmQC> lstMrrDetailsByMrrID = null; recordsTotal = 0; try { Hashtable ht = new Hashtable(); ht.Add("CompanyID", objcmnParam.loggedCompany); ht.Add("LoggedUser", objcmnParam.loggeduser); ht.Add("PageNo", objcmnParam.pageNumber); ht.Add("RowCountPerPage", objcmnParam.pageSize); ht.Add("IsPaging", objcmnParam.IsPaging); ht.Add("MrrID", mrrID); spQuery = "[Get_InvMrrMasterDetailByMrrID]"; lstMrrDetailsByMrrID = GenericFactory_GF_vmQC.ExecuteQuery(spQuery, ht); recordsTotal = lstMrrDetailsByMrrID.Count(); } catch (Exception e) { e.ToString(); } return(lstMrrDetailsByMrrID); }
public IEnumerable <InvRequisitionMaster> GetRequisitionNo(int?pageNumber, int?pageSize, int?IsPaging, int CompanyID, int RequisitionTypeID) { GenericFactory_GF_Requisition = new InvRequisitionMaster_GF(); IEnumerable <InvRequisitionMaster> objRequisitionList = null; string spQuery = string.Empty; try { //objRequisitionList = GenericFactory_EF_RequisitionMaster.GetAll().Select(m => new InvRequisitionMaster { RequisitionID = m.RequisitionID, RequisitionNo = m.RequisitionNo, IsDeleted = m.IsDeleted }).Where(s => s.IsDeleted == false).ToList(); Hashtable ht = new Hashtable(); ht.Add("CompanyId", CompanyID); ht.Add("pageNumber", pageNumber); ht.Add("pageSize", pageSize); ht.Add("IsPaging", IsPaging); ht.Add("RequisitionTypeID", RequisitionTypeID); spQuery = "[dbo].[Get_InvRequisitionList]"; objRequisitionList = GenericFactory_GF_Requisition.ExecuteQuery(spQuery, ht); } catch (Exception e) { e.ToString(); } return(objRequisitionList); }
public IEnumerable <PurchaseQuotationMaster> GetStatementNo(vmCmnParameters objcmnParam, out int recordsTotal) { GFactory_GF_Quotation = new PurchaseQuotationMaster_GF(); IEnumerable <PurchaseQuotationMaster> objPurchaseCSMaster = null; // IEnumerable<PurchaseQuotationMaster> objPurchaseCSMasterWithoutPaging = null; string spQuery = ""; recordsTotal = 0; using (_ctxCmn = new ERP_Entities()) { try { //objPurchaseCSMasterWithoutPaging = (from stmnt in _ctxCmn.PurchaseQuotationMasters.Where(m => m.IsDeleted == false && m.CompanyID == objcmnParam.loggedCompany && m.IsConfirm == true) select stmnt).ToList().Select(m => new PurchaseQuotationMaster { QuotationID = m.QuotationID, QuotationNo = m.QuotationNo }).ToList(); //objPurchaseCSMaster = objPurchaseCSMasterWithoutPaging.OrderByDescending(x => x.QuotationID).Skip(objcmnParam.pageNumber).Take(objcmnParam.pageSize).ToList(); //recordsTotal = objPurchaseCSMasterWithoutPaging.Count(); Hashtable ht = new Hashtable(); ht.Add("pageNumber", objcmnParam.pageNumber); ht.Add("pageSize", objcmnParam.pageSize); ht.Add("IsPaging", objcmnParam.IsPaging); ht.Add("CompanyId", objcmnParam.loggedCompany); spQuery = "Get_PurchaseQuotation"; objPurchaseCSMaster = GFactory_GF_Quotation.ExecuteQuery(spQuery, ht); recordsTotal = objPurchaseCSMaster.Count(); } catch (Exception e) { e.ToString(); } } return(objPurchaseCSMaster); }
public List <vmItemGroup> GetAllItemGroups(vmCmnParameters objcmnParam, out int recordsTotal) { GenericFactoryFor_VmItemGroup = new vmItemGroup_GF(); List <vmItemGroup> _objvmItemGroups = null; string spQuery = string.Empty; recordsTotal = 0; try { using (_ctxCmn = new ERP_Entities()) { Hashtable ht = new Hashtable(); ht.Add("CompanyID", objcmnParam.loggedCompany); ht.Add("LoggedUser", objcmnParam.loggeduser); ht.Add("PageNo", objcmnParam.pageNumber); ht.Add("RowCountPerPage", objcmnParam.pageSize); ht.Add("IsPaging", objcmnParam.IsPaging); spQuery = "[SPGetItemGroupDetail]"; _objvmItemGroups = GenericFactoryFor_VmItemGroup.ExecuteQuery(spQuery, ht).ToList(); recordsTotal = _ctxCmn.CmnItemGroups.Count(); } } catch (Exception e) { e.ToString(); } return(_objvmItemGroups); }
public IEnumerable <vmChallan> GetPODetailByPOID(vmCmnParameters objcmnParam, Int64 poID, out int recordsTotal) { GenericFactory_GF_vmChallan = new vmChallan_GF(); string spQuery = ""; IEnumerable <vmChallan> lstItemDetailByPOID = null; recordsTotal = 0; try { Hashtable ht = new Hashtable(); ht.Add("CompanyID", objcmnParam.loggedCompany); ht.Add("LoggedUser", objcmnParam.loggeduser); ht.Add("PageNo", objcmnParam.pageNumber); ht.Add("RowCountPerPage", objcmnParam.pageSize); ht.Add("IsPaging", objcmnParam.IsPaging); ht.Add("POID", poID); spQuery = "[Get_PurPOListByPOID]"; lstItemDetailByPOID = GenericFactory_GF_vmChallan.ExecuteQuery(spQuery, ht); recordsTotal = lstItemDetailByPOID.Count(); } catch (Exception e) { e.ToString(); } return(lstItemDetailByPOID); }
public vmItemGroup GetItemGroupByID(int?GID, int?CompanyID) { GenericFactoryFor_VmItemGroup = new vmItemGroup_GF(); vmItemGroup _objvmItemGroup = null; string spQuery = string.Empty; try { using (_ctxCmn = new ERP_Entities()) { Hashtable ht = new Hashtable(); ht.Add("CompanyID", CompanyID); ht.Add("LoggedUser", 0); ht.Add("PageNo", 0); ht.Add("RowCountPerPage", 0); ht.Add("IsPaging", 0); ht.Add("ItemTypeID", 0); ht.Add("ItemGroupID", GID); spQuery = "[SPGetItemGroupDetail]"; _objvmItemGroup = GenericFactoryFor_VmItemGroup.ExecuteQuery(spQuery, ht).FirstOrDefault(); } } catch (Exception e) { e.ToString(); } return(_objvmItemGroup); }
public IEnumerable <vmChallan> GetItemMasterById(vmCmnParameters objcmnParam, out int recordsTotal) { GenericFactory_GF_vmChallan = new vmChallan_GF(); // int itemGroupId = Convert.ToInt32(groupId); string spQuery = ""; IEnumerable <vmChallan> objItemMaster = null; recordsTotal = 0; try { Hashtable ht = new Hashtable(); ht.Add("CompanyID", objcmnParam.loggedCompany); ht.Add("LoggedUser", objcmnParam.loggeduser); ht.Add("PageNo", objcmnParam.pageNumber); ht.Add("RowCountPerPage", objcmnParam.pageSize); ht.Add("IsPaging", objcmnParam.IsPaging); // ht.Add("ItemGroupID", itemGroupId); spQuery = "[Get_Item]"; objItemMaster = GenericFactory_GF_vmChallan.ExecuteQuery(spQuery, ht); recordsTotal = objItemMaster.Count(); } catch (Exception e) { e.ToString(); } return(objItemMaster); }
//public IEnumerable<vmChemicalSetupMasterDetail> GetFiniChemConsumptionByID(vmCmnParameters cmnParam) //{ // IEnumerable<vmChemicalSetupMasterDetail> objWeavingMachineSetup = null; // using (ERP_Entities _ctxCmn = new ERP_Entities()) // { // try // { // var PrdFinishingConsumptionMaster = _ctxCmn.PrdFinishingConsumptionMasters.ToList(); // var PrdFinishingConsumptionDetail = _ctxCmn.PrdFinishingConsumptionDetails.ToList(); // var CmnItemMaster = _ctxCmn.CmnItemMasters.ToList(); // var PrdFinishingType = _ctxCmn.PrdFinishingTypes.ToList(); // var CmnUOM = _ctxCmn.CmnUOMs.ToList(); // objWeavingMachineSetup = (from master in PrdFinishingConsumptionMaster // join detail in PrdFinishingConsumptionDetail on master.FinishingConsumptionID equals detail.FinishingConsumptionID // join item in CmnItemMaster on detail.ChemicalID equals item.ItemID // join uom in CmnUOM on detail.UnitID equals uom.UOMID // join pft in PrdFinishingType on master.FinishingTypeID equals pft.FInishTypeID // where master.FinishingConsumptionID == cmnParam.id && master.IsDeleted == false // select new vmChemicalSetupMasterDetail // { // FinishingConsumptionID = master.FinishingConsumptionID, // FinishingConsumptionDetailID = detail.FinishingConsumptionDetailID, // FinishingTypeID = master.FinishingTypeID, // FInishTypeName = pft.FInishTypeName, // Volume = master.Volume, // ConsumptionDate = master.ConsumptionDate, // Remarks = master.Remarks, // ChemicalID = detail.ChemicalID, // ItemName = item.ItemName, // RequiredQty = detail.RequiredQty, // AccQty = detail.AccQty, // UnitID = detail.UnitID, // UOMName = uom.UOMName // }).ToList(); // } // catch (Exception e) // { // e.ToString(); // } // } // return objWeavingMachineSetup; //} public IEnumerable <vmChemicalSetupMasterDetail> GetFiniChemConsumptionMaster(vmCmnParameters objcmnParam, out int recordsTotal) { GenericFactory_vmChemicalSetupMasterDetail_GF = new vmChemicalSetupMasterDetail_VM(); IEnumerable <vmChemicalSetupMasterDetail> FinishingConsumptionMaster = null; recordsTotal = 0; string spQuery = string.Empty; try { using (_ctxCmn = new ERP_Entities()) { Hashtable ht = new Hashtable(); ht.Add("CompanyID", objcmnParam.loggedCompany); ht.Add("LoggedUser", objcmnParam.loggeduser); ht.Add("PageNo", objcmnParam.pageNumber); ht.Add("RowCountPerPage", objcmnParam.pageSize); ht.Add("IsPaging", objcmnParam.IsPaging); spQuery = "[Get_FinishingConsumptionMaster]"; FinishingConsumptionMaster = GenericFactory_vmChemicalSetupMasterDetail_GF.ExecuteQuery(spQuery, ht); recordsTotal = _ctxCmn.PrdFinishingConsumptionMasters.Where(x => x.CompanyID == objcmnParam.loggedCompany && x.IsDeleted == false).Count(); } } catch (Exception e) { e.ToString(); } return(FinishingConsumptionMaster); }