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