public IActionResult Index(int filter, string pNam, string pNam1, string actionType)
{
if (actionType == "Cancel")
{
filter = 0;
}
ViewData["Title"] = "All Items";
ViewData["Filter"] = filter;
ViewData["Fil1"] = pNam;
ViewData["Fil2"] = pNam1;
var dbContext = new MyErpDBContext();
try{
var model = _dbContext.TCustomers.OrderBy(p => p.CustRasoc).ToList();
if (filter == 2)
{
var queryc = from p in _dbContext.TCustomers
where (p.CustRasoc.Contains(pNam) || pNam == null) && (p.CustNif.Contains(pNam1) || pNam1 == null)
orderby p.CustRasoc, p.CustNif
select p;
var qList = queryc.ToList();
model = qList;
}
return(View(model));
}
catch { return(View("Error")); }
}
public IActionResult Index(int filter, string pNam, string pNam1, string actionType)
{
if (actionType == "Cancel")
{
filter = 0;
}
//string variable =_localizer["Indexmessage"];
//ViewData["Title"] = _localizer["Indexmessage"];
ViewData["Filter"] = filter;
ViewData["Fil1"] = pNam;
ViewData["Fil2"] = pNam1;
var dbContext = new MyErpDBContext();
try{
var model = _dbContext.TPersons.OrderBy(p => p.PerName1).ThenBy(p => p.PerName).ToList();
if (filter == 2)
{
var queryc = from p in _dbContext.TPersons
where (p.PerName.Contains(pNam) || pNam == null) && (p.PerName1.Contains(pNam1) || pNam1 == null)
orderby p.PerName1, p.PerName
select p;
var qList = queryc.ToList();
model = qList;
}
return(View(model));
}
catch (Exception ex)
{
string mensaje = ex.Message;
return(View("Error"));
}
}
public IActionResult Capacity(DateTime?F1, DateTime?F2, int panel, int panel1, string actionType)
{
if (panel == 0)
{
panel = 1;
}
if (F1 == null)
{
F1 = System.DateTime.Now;
}
if (F2 == null)
{
F2 = System.DateTime.Now;
}
ViewData["panel"] = panel;
ViewData["panel1"] = panel1;
ViewData["Title"] = "MRP Data";
var dbContext = new MyErpDBContext();
try{
CreateVB_LCP();
CreateVB_cMRP(F1, F2); //ListCustPlan
return(View());
}
catch (Exception Ex) {
string mensaje = Ex.Message;
return(View("Error"));
}
}
public IActionResult ScTrView(DateTime datp, int ver, int panel, int panel1, string actionType)
{
if (panel == 0)
{
panel = 2;
}
ViewData["panel"] = panel;
ViewData["panel1"] = panel1;
ViewData["Title"] = "MRP Data";
var dbContext = new MyErpDBContext();
try{
Guid g = Guid.NewGuid();
string Table = g.ToString();
var pVer = new SqlParameter("@p0", ver);
var table = new SqlParameter("@p2", Table);
_dbContext.Database.ExecuteSqlRaw("[Xs_Explosion_End] {0},{1}", pVer, table);
//esta tabla (Table) ha sido creada como resyltado de la quere Xs_Explosion
//que se ejecuto en PlanCreate [Post]
//Ahora la cargamos en ViewBag
var sqlo = "SELECT * FROM [" + Table + "] ";
//var explosiop = _dbContext.Database.ExecuteSqlRaw(sqlo).ToList();
string constr = Configuration.GetConnectionString("MyProjectConnectionString");
DataTable dt = new DataTable(); //used to store the store procedure result.
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("SELECT * FROM [" + Table + "] WHERE nRow IN (2,5,9,10,11,12,13,17) ", con))
{
con.Open();
cmd.CommandType = CommandType.Text;
SqlDataAdapter ada = new SqlDataAdapter();
ada.SelectCommand = cmd;
ada.Fill(dt);
_dbContext.Database.ExecuteSqlRaw("[Xz_Explosion] {0}", table);
return(View(dt));
}
}
}
catch (Exception Ex) {
string mensaje = Ex.Message;
return(View("Error"));
}
}
/*
* private Microsoft.AspNetCore.Http.IRequestCookieCollection getCookies()
* {
* Microsoft.AspNetCore.Http.IRequestCookieCollection ret =Request.Cookies;
* return ret;
* }
*/
public IActionResult Index(int filter, string pNam, string pNam1, string actionType)
{
//esto solo testimonial -------------------------------
string curpag = "";
try{
curpag = Request.Cookies["_1-currentpage"].ToString().TrimStart().TrimEnd();
}
catch {}
//lo anterior solo testimonial --------------------------
if (actionType == "Cancel")
{
filter = 0;
}
//string variable =_localizer["Indexmessage"];
//ViewData["Title"] = _localizer["Indexmessage"];
ViewData["Filter"] = filter;
ViewData["Fil1"] = pNam;
ViewData["Fil2"] = pNam1;
var dbContext = new MyErpDBContext();
try{
var model = _dbContext.TPersons.OrderBy(p => p.PerId).ToList();
/*
* var model = _dbContext.TPersons.OrderBy(p => p.PerName1).ThenBy(p=> p.PerName).ToList();
* if (filter ==2){
* var queryc = from p in _dbContext.TPersons
* where (p.PerName.Contains(pNam) || pNam ==null ) && (p.PerName1.Contains(pNam1) ||pNam1==null)
* orderby p.PerName1, p.PerName
* select p;
* var qList=queryc.ToList();
* model = qList;
*
* }
*/
//ViewData["CookiesGrid"]=getCookies();
return(View(model));
}
catch (Exception ex)
{
string mensaje = ex.Message;
return(View("Error"));
}
}
public IActionResult ScView(DateTime datp, int ver, int panel, int panel1, string actionType)
{
if (panel == 0)
{
panel = 2;
}
ViewData["panel"] = panel;
ViewData["panel1"] = panel1;
ViewData["Title"] = "MRP Data";
var dbContext = new MyErpDBContext();
try{
CreateViewBags(ver);
return(View());
}
catch (Exception Ex) {
string mensaje = Ex.Message;
return(View("Error"));
}
}
public IActionResult Capacity(VCCplanning model, int panel, int panel1, string actionType)
{
if (panel == 0)
{
panel = 1;
}
ViewData["panel"] = panel;
ViewData["Title"] = "MRP Data";
DateTime?F1 = System.DateTime.Now;
DateTime?F2 = System.DateTime.Now;
if (ModelState.IsValid)
{
try{
F1 = model.CplanDateFrom;
F2 = model.CplanDateTo;
}
catch {}
}
else
{
panel1 = 1;
} //solo valida en panel 1
ViewData["panel1"] = panel1;
var dbContext = new MyErpDBContext();
try{
CreateVB_LCP();
CreateVB_cMRP(F1, F2); //ListCustPlan
return(View());
}
catch (Exception Ex) {
string mensaje = Ex.Message;
return(View("Error"));
}
}
public TCustomerController(MyErpDBContext dbContext)
{
_dbContext = dbContext;
}
public Account(MyErpDBContext dbContext, ILogger <Account> logger)
{
_dbContext = dbContext;
_logger = (ILogger <Account>)logger;
}
public TOrganizaController(MyErpDBContext dbContext, ILogger <TPersonController> logger)
{
_dbContext = dbContext;
_logger = (ILogger <TPersonController>)logger;
}
public TMRPController(MyErpDBContext dbContext, IConfiguration _configuration, IWebHostEnvironment env)
{
_dbContext = dbContext;
Configuration = _configuration;
_env = env;
}
public TMRPController(MyErpDBContext dbContext, IConfiguration _configuration)
{
_dbContext = dbContext;
Configuration = _configuration;
}
public TSuplierController(MyErpDBContext dbContext)
{
_dbContext = dbContext;
}
public TLogController(MyErpDBContext dbContext)
{
_dbContext = dbContext;
}
