internal List <YarnDeterminationShowRepo> GetAllInformationOfGridView(string OCODE)
{
try
{
using (var _context = new ERPSSL_MerchandisingEntities())
{
var _OCode = new SqlParameter("@OCODE", OCODE);
string SP_SQL = "LC_YarnCostShow @OCODE";
return((_context.ExecuteStoreQuery <YarnDeterminationShowRepo>(SP_SQL, _OCode)).ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
internal List <YarnDeterminationReportRepo> GetAllInformationOfYD(string OCODE, Guid userIdEccess)
{
try
{
using (var _context = new ERPSSL_MerchandisingEntities())
{
var _OCode = new SqlParameter("@OCODE", OCODE);
var _CreateUser = new SqlParameter("@CreateUser", userIdEccess);
string SP_SQL = "LC_RPT_YarnDetermination @OCODE, @CreateUser";
return((_context.ExecuteStoreQuery <YarnDeterminationReportRepo>(SP_SQL, _OCode, _CreateUser)).ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
internal List <YarnDeterminationShowRepo> GetAllInformationOfGridViewByComposition(string OCODE, int compositionId, Guid createUser)
{
try
{
using (var _context = new ERPSSL_MerchandisingEntities())
{
var _OCode = new SqlParameter("@OCODE", OCODE);
var _ConstructionId = new SqlParameter("@CompositionId", compositionId);
var _CreateUser = new SqlParameter("@CreateUser", createUser);
string SP_SQL = "LC_YarnCostShowByComposition @OCODE, @CompositionId, @CreateUser";
return((_context.ExecuteStoreQuery <YarnDeterminationShowRepo>(SP_SQL, _OCode, _ConstructionId, _CreateUser)).ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}