public IEnumerable <CmnOrganogram> GetDeptByCompanyID(vmCmnParameters objcmnParam, int companyID)
{
IEnumerable <CmnOrganogram> lstOrganogram = null;
using (_ctxCmn = new ERP_Entities())
{
try
{
lstOrganogram = (from org in _ctxCmn.CmnOrganograms.Where(m => m.IsDeleted == false && (m.CompanyID == companyID)) select org).ToList().Select(m => new CmnOrganogram {
OrganogramID = m.OrganogramID, OrganogramName = m.OrganogramName
}).ToList();
}
catch (Exception e)
{
e.ToString();
}
}
return(lstOrganogram);
}
public IEnumerable <AccCurrencyInfo> GetCurrency(int?pageNumber, int?pageSize, int?IsPaging)
{
IEnumerable <AccCurrencyInfo> lstCurrency = null;
using (_ctxCmn = new ERP_Entities())
{
try
{
lstCurrency = (from grp in _ctxCmn.AccCurrencyInfoes select grp).ToList().Select(m => new AccCurrencyInfo {
Id = m.Id, CurrencyName = m.CurrencyName, ConversionRate = m.ConversionRate
}).ToList();
}
catch (Exception e)
{
e.ToString();
}
}
return(lstCurrency);
}
/// No CompanyID Provided
public IEnumerable <vmItemGroup> GetPISampleNo(int companyID, int?pageNumber, int?pageSize, int?IsPaging) // Getting all item groups
{
//GenericFactory_EF_ItemGroup = new CmnItemGroup_EF();
//GenericFactory_EF_CmnItemMaster = new CmnItemMaster_EF();
IEnumerable <vmItemGroup> objPISampleNo = null;
//IEnumerable<CmnItemMaster> cmnGroupIDOfItemMaster = null;
IEnumerable <CmnItemGroup> ItemGroup = null;
using (ERP_Entities _ctxCmn = new ERP_Entities())
{
try
{
//cmnGroupIDOfItemMaster = _ctxCmn.CmnItemMasters.Where(x => x.ItemTypeID == 1 && x.IsDeleted == false).ToList()
// .GroupBy(x => x.ItemGroupID).Select(o => new CmnItemMaster { ItemGroupID = o.Key }).ToList();
ItemGroup = _ctxCmn.CmnItemGroups.Where(x => x.ItemTypeID == 1 && x.IsDeleted == false &&
x.CompanyID == companyID).ToList()
.Select(m => new CmnItemGroup {
ItemGroupID = m.ItemGroupID, ItemGroupName = m.ItemGroupName
}).ToList();
objPISampleNo = (from groupItm in ItemGroup
// join itemMasterGroup in cmnGroupIDOfItemMaster on groupItm.ItemGroupID equals itemMasterGroup.ItemGroupID
select new
{
ItemGroupID = groupItm.ItemGroupID,
ItemGroupName = groupItm.ItemGroupName
}).Select(m => new vmItemGroup
{
ItemGroupID = m.ItemGroupID,
ItemGroupName = m.ItemGroupName
}).ToList().OrderBy(m => m.ItemGroupName);
}
catch (Exception e)
{
e.ToString();
}
}
return(objPISampleNo);
}
public IEnumerable <vmQuotation> GetQuotationList()
{
IEnumerable <vmQuotation> lstQuotationMaster = null;
try
{
using (_ctxCmn = new ERP_Entities())
{
lstQuotationMaster = _ctxCmn.PurchaseQuotationMasters.Where(m => m.IsDeleted == false).Select(m => new vmQuotation {
QuotationID = m.QuotationID, QuotationNo = m.QuotationNo, CompanyID = m.CompanyID
}).ToList();
lstQuotationMaster = lstQuotationMaster.OrderBy(m => m.QuotationID);
}
}
catch (Exception e)
{
e.ToString();
}
return(lstQuotationMaster);
}
/// No CompanyID Provided
///
public IEnumerable <vmRequisition> GetIssueList()
{
IEnumerable <vmRequisition> lstIssueMaster = null;
try
{
using (_ctxCmn = new ERP_Entities())
{
lstIssueMaster = _ctxCmn.InvIssueMasters.Where(m => m.IsDeleted == false).Select(m => new vmRequisition {
IssueID = m.IssueID, IssueNo = m.IssueNo, CompanyID = m.CompanyID, CreateBy = m.CreateBy
}).ToList();
lstIssueMaster = lstIssueMaster.OrderBy(m => m.IssueID);
}
}
catch (Exception e)
{
e.ToString();
}
return(lstIssueMaster);
}
public JsonResult GetAllCompanyList()
{
using (var db = new ERP_Entities())
{
var userId = Convert.ToInt32(Session["UserID"].ToString());
var result = (from p in db.CmnCompanies
join a in db.CmnUserWiseCompanies
on p.CompanyID equals a.CompanyID
where a.UserID == userId && p.IsDeleted == false
select new
{
Text = p.CompanyName,
value = p.CompanyID
}).Distinct().ToList();
return(Json(new SelectList(result, "Value", "Text"), JsonRequestBehavior.AllowGet));
}
}
public List <vmPrdDyingMRRDetail> GetProcessDetailsByID(int?companyID, int?loggedUser, int?pageNumber, int?pageSize, int?IsPaging, int?DyingMRRID)
{
List <vmPrdDyingMRRDetail> returnList = new List <vmPrdDyingMRRDetail>();
try
{
using (ERP_Entities context = new ERP_Entities())
{
returnList = (from process in context.PrdDyingMRRDetails
where process.CompanyID == companyID && process.IsDeleted == false &&
process.DyingMRRID == DyingMRRID
select new vmPrdDyingMRRDetail
{
DyingMRRDetailID = process.DyingMRRDetailID,
DyingMRRID = process.DyingMRRID,
DyingProcessID = process.DyingProcessID,
Time = process.Time,
OperationID = process.OperationID,
Quantity = process.Quantity,
UnitID = process.UnitID,
CompanyID = process.CompanyID,
CreateBy = process.CreateBy,
CreateOn = process.CreateOn,
CreatePc = process.CreatePc,
UpdateBy = process.UpdateBy,
UpdateOn = process.UpdateOn,
UpdatePc = process.UpdatePc,
IsDeleted = process.IsDeleted,
DeleteBy = process.DeleteBy,
DeleteOn = process.DeleteOn,
DeletePc = process.DeletePc,
EntityState = "Update",
}).ToList();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
return(returnList);
}
public List <PrdFinishingProcess> GetFinishingProcess(vmCmnParameters objcmnParam)
{
List <PrdFinishingProcess> lstPrdFinishingProcess = null;
using (ERP_Entities _ctxCmn = new ERP_Entities())
{
try
{
lstPrdFinishingProcess = (from spl in _ctxCmn.PrdFinishingProcesses.Where(m => m.IsActive == true && m.CompanyID == objcmnParam.loggedCompany && m.IsDeleted == false)
select spl).ToList().Select(m => new PrdFinishingProcess {
FinishingProcessID = m.FinishingProcessID, FinishingProcessName = m.FinishingProcessName
}).ToList();
}
catch (Exception e)
{
e.ToString();
}
}
return(lstPrdFinishingProcess);
}
public List <InvGrrMaster> GetGRRList(int?pageNumber, int?pageSize, int?IsPaging)
{
_ctxCmn = new ERP_Entities();
List <InvGrrMaster> lstInvGRRMaster = null;
try
{
using (_ctxCmn = new ERP_Entities())
{
lstInvGRRMaster = _ctxCmn.InvGrrMasters.Where(x => x.IsDeleted == false).OrderBy(s => s.CHID)
.ToList().Select(m => new InvGrrMaster {
GrrID = m.GrrID, GrrNo = m.GrrNo
}).ToList();
}
}
catch (Exception ex)
{
ex.ToString();
}
return(lstInvGRRMaster);
}
public List <InvIssueMaster> GetIssueNo(vmCmnParameters objcmnParam)
{
List <InvIssueMaster> lstIssue = null;
using (ERP_Entities _ctxCmn = new ERP_Entities())
{
try
{
lstIssue = (from spl in _ctxCmn.InvIssueMasters.Where(m => m.IssueTypeID == objcmnParam.tTypeId && m.CompanyID == objcmnParam.loggedCompany && m.IsDeleted == false)
select spl).ToList().Select(m => new InvIssueMaster {
IssueID = m.IssueID, IssueNo = m.IssueNo
}).ToList();
}
catch (Exception e)
{
e.ToString();
}
}
return(lstIssue);
}
public List <vmQC> GetSprLoanList(vmCmnParameters objcmnParam, Int32 loanTransTypeSpr)
{
List <vmQC> lstLoanSpr = null;
using (ERP_Entities _ctxCmn = new ERP_Entities())
{
try
{
lstLoanSpr = (from spl in _ctxCmn.InvRequisitionMasters.Where(m => m.RequisitionTypeID == loanTransTypeSpr && m.CompanyID == objcmnParam.loggedCompany && m.IsDeleted == false)
select spl).Select(m => new vmQC {
RequisitionID = m.RequisitionID, SprNo = m.RequisitionNo, CompanyID = m.CompanyID, CompanyName = m.CmnCompany.CompanyName, SPRDate = m.RequisitionDate
}).ToList();
}
catch (Exception e)
{
e.ToString();
}
}
return(lstLoanSpr);
}
public List <vmGrr> GetSuppliers(vmCmnParameters objcmnParam)
{
List <vmGrr> lstSuppliers = null;
using (ERP_Entities _ctxCmn = new ERP_Entities())
{
try
{
lstSuppliers = (from spl in _ctxCmn.CmnUsers.Where(m => m.CompanyID == objcmnParam.loggedCompany && m.IsDeleted == false && m.UserTypeID == 3)
select spl).Select(m => new vmGrr {
SupplierID = m.UserID, SupplierName = m.UserFullName
}).ToList();
}
catch (Exception e)
{
e.ToString();
}
}
return(lstSuppliers);
}
private void BindPV(int companyId)
{
try
{
using (var db = new ERP_Entities())
{
var source = db.AccVoucherMasters.Where(r => r.VoucherTypeId == 2 && r.CompanyId == companyId).ToList();
cbPVNO.DataSource = source;
cbPVNO.DataValueField = "VoucherNo";
cbPVNO.DataTextField = "VoucherNo";
cbPVNO.DataBind();
cbPVNO.Items.Insert(0, "");
cbPVNO.Items[0].Value = "";
}
}
catch (Exception ex)
{
throw ex;
}
//var companyId = Session["CompanyId"].ToString();
}
public IEnumerable <vmCmnUser> GetParty(int pageNumber, int pageSize, int IsPaging)
{
List <vmCmnUser> lstParty = null;
using (_ctxCmn = new ERP_Entities())
{
try
{
//**************************Paging Implemented******************************
using (_ctxCmn = new ERP_Entities())
{
lstParty = (from x in _ctxCmn.CmnUsers
select new
{
UserID = x.UserID,
UserFullName = x.UserFullName,
UserTypeID = x.UserTypeID,
IsDeleted = x.IsDeleted
}).ToList().Select(m => new vmCmnUser
{
UserID = m.UserID,
UserFullName = m.UserFullName,
UserTypeID = m.UserTypeID,
IsDeleted = m.IsDeleted
})
.Where(m => m.UserTypeID == 3 && m.IsDeleted == false && m.UserFullName != null)
.OrderBy(p => p.UserID)
.Skip(pageNumber)
.Take(pageSize).ToList();
}
}
catch (Exception e)
{
e.ToString();
}
}
return(lstParty);
}
public List <vmCmnWorkFlowMaster> GetWorkFlowMasterListByMenu(UserCommonEntity ent)
{
List <vmCmnWorkFlowMaster> list = new List <vmCmnWorkFlowMaster>();
try
{
using (ERP_Entities dbContext = new ERP_Entities())
{
list = (from WFM in dbContext.CmnWorkFlowMasters
where WFM.MenuID == ent.currentMenuID && WFM.CompanyID == ent.loggedCompnyID && WFM.IsActive == true && WFM.IsDeleted == false
select new vmCmnWorkFlowMaster
{
WorkFlowID = WFM.WorkFlowID,
MenuID = WFM.MenuID,
BranchID = WFM.BranchID,
UserTeamID = WFM.UserTeamID,
IsActive = WFM.IsActive,
CompanyID = WFM.CompanyID,
DBID = WFM.DBID,
CreateBy = WFM.CreateBy,
CreateOn = WFM.CreateOn,
CreatePc = WFM.CreatePc,
UpdateBy = WFM.UpdateBy,
UpdateOn = WFM.UpdateOn,
UpdatePc = WFM.UpdatePc,
IsDeleted = WFM.IsDeleted,
DeleteBy = WFM.DeleteBy,
DeleteOn = WFM.DeleteOn,
DeletePc = WFM.DeletePc,
Transfer = WFM.Transfer
}).ToList();
}
}
catch (Exception ex)
{
throw new Exception("PleaseCheckMethod:GetWorkFlowMasterListByMenu" + ex.Message.ToString());
}
return(list);
}
//private iGenericFactory<vmStockMaster> GenericFactory_EF_Stock = null;
/// No CompanyID Provided
public IEnumerable <CmnItemMaster> GetFinishItemDescription(int?pageNumber, int?pageSize, int?IsPaging)
{
IEnumerable <CmnItemMaster> objItems = null;
try
{
using (_ctxCmn = new ERP_Entities())
{
objItems = _ctxCmn.CmnItemMasters.Where(m => m.ItemTypeID == 1).ToList().
Select(m => new CmnItemMaster
{
ItemID = m.ItemID,
ItemName = m.ArticleNo + " - " + m.Description
}).ToList();
}
}
catch (Exception e)
{
e.ToString();
}
return(objItems);
}
public IEnumerable <vmUser> GetUser(vmCmnParameters objcmnParam, out int recordsTotal)
{
IEnumerable <vmUser> objUser = null;
string spQuery = string.Empty;
recordsTotal = 0;
try
{
if (objcmnParam != null)
{
using (_ctxCmn = new ERP_Entities())
{
Hashtable ht = new Hashtable();
ht.Add("CompanyID", objcmnParam.loggedCompany);
ht.Add("LoggedUser", objcmnParam.loggeduser);
ht.Add("UserType", objcmnParam.UserType);
ht.Add("PageNo", objcmnParam.pageNumber);
ht.Add("RowCountPerPage", objcmnParam.pageSize);
ht.Add("IsPaging", objcmnParam.IsPaging);
spQuery = "[Get_CmnUser]";
using (GenericFactoryFor_User = new vmUser_GF())
{
objUser = GenericFactoryFor_User.ExecuteQuery(spQuery, ht);
}
recordsTotal = _ctxCmn.CmnUsers.Where(x => x.CompanyID == objcmnParam.loggedCompany && x.UserTypeID == objcmnParam.UserType).Count();
}
}
}
catch (Exception e)
{
e.ToString();
}
return(objUser);
}
public List <vmChemicalSetup> GetChemicalSetupList(vmCmnParameters objcmnParam, out int recordsTotal)
{
List <vmChemicalSetup> list = new List <vmChemicalSetup>();
recordsTotal = 0;
try
{
#region Convert It Into Sp
ERP_Entities dbContext = new ERP_Entities();
list = (from master in dbContext.PrdDyingChemicalSetups
join details in dbContext.PrdDyingChemicalSetupDetails on master.ChemicalSetupID equals details.ChemicalSetupID
join color in dbContext.CmnItemColors on master.ColorID equals color.ItemColorID into leftColorGroup
from lcg in leftColorGroup.DefaultIfEmpty()
join unit in dbContext.CmnUOMs on master.UnitID equals unit.UOMID into leftUnitGroup
from lug in leftUnitGroup.DefaultIfEmpty()
where master.IsDeleted == false
select new vmChemicalSetup
{
ChemicalSetupID = master.ChemicalSetupID,
ColorID = lcg.ItemColorID,
Qty = master.Qty,
ColorName = lcg.ColorName,
UnitID = lug.UOMID,
UnitName = lug.UOMName,
IsDeleted = master.IsDeleted
}).Distinct().ToList();
recordsTotal = list.Count();
list = list.OrderByDescending(x => x.ChemicalSetupID).Skip(objcmnParam.pageNumber).Take(objcmnParam.pageSize).ToList();
#endregion Convert It Into Sp
}
catch (Exception ex)
{
ex.Message.ToString();
}
return(list);
}
public IEnumerable <CmnUOM> GetWeightUnit(vmCmnParameters objcmnParam, out int recordsTotal)
{
IEnumerable <CmnUOM> lstWeightUnit = null;
IEnumerable <CmnUOM> lstWeightUnitWithoutPaging = null;
recordsTotal = 0;
using (_ctxCmn = new ERP_Entities())
{
try
{
lstWeightUnitWithoutPaging = (from wu in _ctxCmn.CmnUOMs.Where(m => m.IsDeleted == false && m.UOMGroupID == 4) select wu).ToList().Select(m => new CmnUOM {
UOMID = m.UOMID, UOMName = m.UOMName
}).ToList();
lstWeightUnit = lstWeightUnitWithoutPaging.OrderBy(x => x.UOMID).Skip(objcmnParam.pageNumber).Take(objcmnParam.pageSize).ToList();
recordsTotal = lstWeightUnitWithoutPaging.Count();
}
catch (Exception e)
{
e.ToString();
}
}
return(lstWeightUnit);
}
public List <InvRequisitionMaster> GetRequisitionMaster(vmCmnParameters objcmnParam, out int recordsTotal)
{
_ctxCmn = new ERP_Entities();
List <InvRequisitionMaster> _vmRequisition = null;
recordsTotal = 0;
try
{
using (_ctxCmn = new ERP_Entities())
{
_vmRequisition = _ctxCmn.InvRequisitionMasters.Where(x => x.IsDeleted == false).OrderBy(s => s.RequisitionID)
.Skip(objcmnParam.pageNumber)
.Take(objcmnParam.pageSize)
.ToList();
recordsTotal = _vmRequisition.Count();
}
}
catch (Exception ex)
{
ex.ToString();
}
return(_vmRequisition);
}
public IEnumerable <InvRequisitionMaster> GetSPRNo(vmCmnParameters objcmnParam, out int recordsTotal)
{
IEnumerable <InvRequisitionMaster> objSPRNo = null;
IEnumerable <InvRequisitionMaster> objSPRNoWithoutPaging = null;
recordsTotal = 0;
using (_ctxCmn = new ERP_Entities())
{
try
{
objSPRNoWithoutPaging = (from spr in _ctxCmn.InvRequisitionMasters.Where(m => m.IsDeleted == false) select spr).ToList().Select(m => new InvRequisitionMaster {
RequisitionID = m.RequisitionID, RequisitionNo = m.RequisitionNo
}).ToList();
objSPRNo = objSPRNoWithoutPaging.OrderBy(x => x.RequisitionID).Skip(objcmnParam.pageNumber).Take(objcmnParam.pageSize).ToList();
recordsTotal = objSPRNoWithoutPaging.Count();
}
catch (Exception e)
{
e.ToString();
}
}
return(objSPRNo);
}
public IEnumerable <CmnAddressCountry> GetLocation(vmCmnParameters objcmnParam, out int recordsTotal)
{
IEnumerable <CmnAddressCountry> objCountry = null;
IEnumerable <CmnAddressCountry> objCountryWithoutPaging = null;
recordsTotal = 0;
using (_ctxCmn = new ERP_Entities())
{
try
{
objCountryWithoutPaging = (from spr in _ctxCmn.CmnAddressCountries.Where(m => m.IsDeleted == false) select spr).ToList().Select(m => new CmnAddressCountry {
CountryID = m.CountryID, CountryName = m.CountryName
}).ToList();
objCountry = objCountryWithoutPaging.OrderBy(x => x.CountryID).Skip(objcmnParam.pageNumber).Take(objcmnParam.pageSize).ToList();
recordsTotal = objCountryWithoutPaging.Count();
}
catch (Exception e)
{
e.ToString();
}
}
return(objCountry);
}
public List <InvGrrMaster> GetGRRNo(int?pageNumber, int?pageSize, int?IsPaging)
{
List <InvGrrMaster> lstInvGrrMaster = null;
using (ERP_Entities _ctxCmn = new ERP_Entities())
{
try
{
lstInvGrrMaster = (from grr in _ctxCmn.InvGrrMasters
select new { GrrID = grr.GrrID, GrrNo = grr.GrrNo, IsDeleted = grr.IsDeleted }).ToList()
.Select(m => new InvGrrMaster {
GrrID = m.GrrID, GrrNo = m.GrrNo, IsDeleted = m.IsDeleted
})
.Where(m => m.IsDeleted == false && m.IsMrrCompleted == false).ToList();
}
catch (Exception e)
{
e.ToString();
}
}
return(lstInvGrrMaster);
}
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 List <vmChemicalSetup> GetAllList(int?companyID, int?loggedUser, int?pageNumber, int?pageSize, int?IsPaging)
{
List <vmChemicalSetup> list = new List <vmChemicalSetup>();
#region Convert It Into Sp
ERP_Entities dbContext = new ERP_Entities();
var recordList = (from master in dbContext.PrdDyingChemicalSetups
join details in dbContext.PrdDyingChemicalSetupDetails on master.ChemicalSetupID equals details.ChemicalSetupID
join color in dbContext.CmnItemColors on master.ColorID equals color.ItemColorID into leftColorGroup
from lcg in leftColorGroup.DefaultIfEmpty()
where master.IsDeleted == false
select new vmChemicalSetup
{
ChemicalSetupID = master.ChemicalSetupID
,
ColorID = lcg.ItemColorID
}).Distinct().ToList();
list = recordList.ToList();
#endregion Convert It Into Sp
return(list);
}
public IEnumerable <PurchaseQuotationMaster> GetStatementNo(vmCmnParameters objcmnParam, out int recordsTotal)
{
IEnumerable <PurchaseQuotationMaster> objPurchaseCSMaster = null;
IEnumerable <PurchaseQuotationMaster> objPurchaseCSMasterWithoutPaging = null;
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.OrderBy(x => x.QuotationID).Skip(objcmnParam.pageNumber).Take(objcmnParam.pageSize).ToList();
recordsTotal = objPurchaseCSMasterWithoutPaging.Count();
}
catch (Exception e)
{
e.ToString();
}
}
return(objPurchaseCSMaster);
}
public IEnumerable <vmChemicalSetupMasterDetail> GetSizingChemicalSetupDetailByID(vmCmnParameters objcmnParam, out int recordsTotal)
{
IEnumerable <vmChemicalSetupMasterDetail> objChemicalDetailByID = null;
recordsTotal = 0;
try
{
using (_ctxCmn = new ERP_Entities())
{
objChemicalDetailByID = (from MP in _ctxCmn.PrdSizingChemicalSetupDetails
join CM in _ctxCmn.CmnItemMasters on MP.ChemicalID equals CM.ItemID
join UM in _ctxCmn.CmnUOMs on MP.UnitID equals UM.UOMID
where MP.CompanyID == objcmnParam.loggedCompany && MP.IsDeleted == false &&
MP.ChemicalSetupID == objcmnParam.id
//&& objcmnParam.id == 0 ? true : IM.ItemID == objcmnParam.id
orderby MP.ChemicalSetupID
select new vmChemicalSetupMasterDetail
{
ChemicalSetupDetailID = MP.ChemicalSetupDetailID,
ChemicalSetupID = MP.ChemicalSetupID,
ChemicalID = MP.ChemicalID,
ItemName = CM.ItemName,
MinQty = MP.MinQty,
MaxQty = (decimal)MP.MaxQty,
UnitID = MP.UnitID,
UOMName = UM.UOMName
}).ToList();
recordsTotal = objChemicalDetailByID.Count();
}
}
catch (Exception e)
{
e.ToString();
}
return(objChemicalDetailByID);
}
public List <vmIssueMaster> GetIssueMasterList(vmCmnParameters objcmnParam, out int recordsTotal)
{
_ctxCmn = new ERP_Entities();
List <vmIssueMaster> lstIssue = null;
List <vmIssueMaster> lstIssueWOPaging = null;
recordsTotal = 0;
try
{
lstIssueWOPaging = (from qcm in _ctxCmn.InvIssueMasters.Where(s => s.IsDeleted == false && s.IssueTypeID == objcmnParam.tTypeId)
// join com in _ctxCmn.CmnCompanies on qcm.ToCompanyID equals com.CompanyID
join org in _ctxCmn.CmnOrganograms on qcm.ToDepartmentID equals org.OrganogramID
join usr in _ctxCmn.CmnUsers on qcm.IssueBy equals usr.UserID
select new vmIssueMaster
{
IssueID = qcm.IssueID,
IssueNo = qcm.IssueNo,
IssueDate = qcm.IssueDate,
RequisitionNo = qcm.RequisitionNo,
IssueBy = qcm.IssueBy,
IssueByName = usr.UserFullName,
ToDepartmentID = qcm.ToDepartmentID,
ToDepartment = org.OrganogramName,
//ToCompanyID = qcm.ToCompanyID,
// ToCompany = com.CompanyName,
Comments = qcm.Comments,
}).ToList();
lstIssue = lstIssueWOPaging.OrderByDescending(x => x.IssueID).Skip(objcmnParam.pageNumber).Take(objcmnParam.pageSize).ToList();
recordsTotal = lstIssueWOPaging.Count();
}
catch (Exception e)
{
e.ToString();
}
return(lstIssue);
}
public int ExecuteWorkFlowTransactionProcess(Hashtable ht)
{
string spQuery = "[SPInsertCmnWorkFlowTRAN]";
ERP_Entities _dbctx = new ERP_Entities();
int result = 0;
try
{
using (_dbctx.Database.Connection)
{
_dbctx.Database.Connection.Open();
DbCommand cmd = _dbctx.Database.Connection.CreateCommand();
cmd.CommandText = spQuery;
cmd.CommandType = CommandType.StoredProcedure;
foreach (object obj in ht.Keys)
{
string str = Convert.ToString(obj);
SqlParameter parameter = new SqlParameter("@" + str, ht[obj]);
cmd.Parameters.Add(parameter);
}
IDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
result = dr.GetInt32(0);
}
cmd.Parameters.Clear();
}
}
catch (Exception e)
{
e.Message.ToString();
e.StackTrace.ToString();
}
return(result);
}
public dynamic GetMachineSetupDetails(int?companyID, int?loggedUser, int?pageNumber, int?pageSize, int?IsPaging, int?MasterID, int?DetailsID)
{
dynamic result = null;
try
{
string spQuery = string.Empty;
using (_ctxObj = new ERP_Entities())
{
var itemID = MasterID;
var machineID = DetailsID;
PrdDyingMachineSetup ent = (from machineSetup in _ctxObj.PrdDyingMachineSetups
where machineSetup.ItemID == itemID &&
machineSetup.MechineID == ((machineID == 0) ? machineSetup.MechineID : (long)machineID)
select machineSetup).FirstOrDefault();
Hashtable ht = new Hashtable();
ht.Add("CompanyID", companyID);
ht.Add("LoggedUser", loggedUser);
ht.Add("MASTERID", MasterID);
ht.Add("DETAILSID", ent.SetupID.ToString());
spQuery = "[GET_DYINGMACHINESETUP]";
using (objectMachineSetupDetails = new dynamic_EF())
{
result = objectMachineSetupDetails.ExecuteQueryObjectType(spQuery, ht);
}
return(result);
}
}
catch (Exception ex)
{
result = ex.Message.ToString();
ex.ToString();
}
return(0);
}
