public void AgregarTarima()
{
tarimas tarimas = new tarimas();
logisticainversa logisticaTemp = db.logisticainversa.Where(x => x.Folio.Equals(this.lblStatusLogistica.Text)).FirstOrDefault();
int conteotarima = db.tarimas.Where(x => x.logisticainversa_Id.Equals(logisticaTemp.id)).Count() + 1;
string foliotarima = this.lblStatusLogistica.Text.Trim() + "-P" + conteotarima;
tarimas.Folio = foliotarima;
tarimas.logisticainversa_Id = logisticaTemp.id;
tarimas.statustarimas_Id = 1;
if (ctrl.AgregarTarimas(tarimas))
{
this.lblStatusTarima.Text = foliotarima;
txtSKU.Text = string.Empty;
txtSKU.Focus();
listaGrid = new List <CantidadesTarima>();
Printing();
}
else
{
Error("HA OCURRIDO UN ERROR:" + " \n\n CONTINUAR -> (OK)", "ERROR AGREGAR TARIMA");
}
}
public int OrigenLogistica(string folio)
{
try
{
logisticainversa logistica = db.logisticainversa.Where(x => x.Folio.Equals(folio)).FirstOrDefault();
return(logistica.origenlogistica_id);
}
catch (Exception)
{
return(0);
}
}
public bool AgregarLogistica(logisticainversa model)
{
try
{
db.logisticainversa.Add(model);
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
Console.WriteLine("Error: " + ex.Message.ToString());
return(false);
}
}
public bool Cerrar(string foliologistica)
{
try
{
logisticainversa logisticainversa = db.logisticainversa.Where(x => x.Folio.Equals(foliologistica)).FirstOrDefault();
logisticainversa.statuslogisticasinversas_Id = 2;
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
private void btnCerrarTarima_Click(object sender, EventArgs e)
{
if (lblStatusLogistica.Text.Equals("LOGISTICA ACTUAL"))
{
MessageBox.Show("NO HA SELECCIONADO NINGUNA LOGISTICA");
}
else
{
string respuesta = Microsoft.VisualBasic.Interaction.InputBox("DESEA AGREGAR UNA NUEVA TARIMA \n\n SI -> (Y) \n\n NO -> (N)", "CERRANDO TARIMA");
if (respuesta.ToUpper().Equals("Y"))
{
AgregarDetTarimaSku();
AgregarTarima();
listaGrid = new List <CantidadesTarima>();
dgvItems.DataSource = null;
this.txtSKU.Focus();
}
else if (respuesta.ToUpper().Equals("N"))
{
AgregarDetTarimaSku();
MessageBox.Show("INFORMACION DE TARIMA GUARDADA CORRECTAMENTE");
string respuestalogistica = Microsoft.VisualBasic.Interaction.InputBox("DESEA CERRAR LA LOGISTICA INVERSA \n\n SI -> (Y) \n\n NO -> (N)", "CERRAR LOGISTICA INVERSA");
if (respuestalogistica.ToUpper().Equals("Y"))
{
logisticainversa logistica = db.logisticainversa.Where(x => x.Folio.Equals(this.lblStatusLogistica.Text)).FirstOrDefault();
logistica.statuslogisticasinversas_Id = 2;
db.SaveChanges();
}
else if (respuestalogistica.ToUpper().Equals("N"))
{
MessageBox.Show("ESTA LOGISTICA INVERSA CONTINUA ABIERTA");
}
else if (respuestalogistica.Equals(string.Empty))
{
MessageBox.Show("NO SE REALIZO NINGUNA ACCION");
}
Limpiar();
}
else if (respuesta.Equals(string.Empty))
{
MessageBox.Show("NO SE REALIZO NINGUNA ACCION");
}
}
}
public bool Crear(string folio, string origen)
{
try
{
logisticainversa logisticainversa = new logisticainversa();
logisticainversa.FechaAlta = DateTime.Now;
logisticainversa.statuslogisticasinversas_Id = 1;
logisticainversa.Folio = folio;
logisticainversa.origenlogistica_id = db.li_origen.Where(x => x.descripcion.Equals(origen)).FirstOrDefault().id;
db.logisticainversa.Add(logisticainversa);
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool BusquedaStatus(string folio)
{
try
{
logisticainversa logistica = db.logisticainversa.Where(x => x.Folio.Equals(folio)).FirstOrDefault();
if (logistica.statuslogisticasinversas_Id == 1)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
return(false);
}
}
public void AgregarLogistica()
{
try
{
int idorigen = Convert.ToInt32(this.cbOrigen.SelectedValue);
this.lblOrigen.Text = db.origenlogistica.Find(idorigen).descripcion;
int conteologistica = db.logisticainversa.Count() + 1;
string foliologistica = "OGLI-" + this.lblOrigen.Text.Replace(" ", "").Trim() + "-" + conteologistica;
logisticainversa logistica = new logisticainversa();
logistica.FechaAlta = this.dtpFechaAlta.Value;
logistica.Folio = foliologistica;
logistica.statuslogisticasinversas_Id = 1;
logistica.origenlogistica_id = idorigen;
if (ctrl.AgregarLogistica(logistica))
{
this.lblStatusLogistica.Text = foliologistica;
this.cbOrigen.Enabled = false;
this.dtpFechaAlta.Enabled = false;
this.txtSKU.Enabled = true;
AgregarTarima();
}
else
{
Error("HA OCURRIDO UN ERROR:" + " \n\n CONTINUAR -> (OK)", "ERROR AGREGAR LOGISTICA");
}
}
catch (Exception ex)
{
Error("Error:" + ex.Message.ToString() + " \n\n CONTINUAR -> (OK)", "ERROR AGREGAR LOGISTICA");
}
}
public ActionResult VistaDetalles(int id)
{
logisticainversa logisticainversa = db.logisticainversa.Find(id);
return(View(logisticainversa));
}
public ActionResult ObtenerLogisticas()
{
var Draw = Request.Form.GetValues("draw").FirstOrDefault();
var Start = Request.Form.GetValues("start").FirstOrDefault();
var Length = Request.Form.GetValues("length").FirstOrDefault();
var SortColumn = Request.Form.GetValues("columns[" + Request.Form.GetValues("order[0][column]").FirstOrDefault() + "][data]").FirstOrDefault();
var SortColumnDir = Request.Form.GetValues("order[0][dir]").FirstOrDefault();
var logistica = Request.Form.GetValues("columns[0][search][value]").FirstOrDefault();
int PageSize = Length != null?Convert.ToInt32(Length) : 0;
int Skip = Start != null?Convert.ToInt32(Start) : 0;
int TotalRecords = 0;
List <logisticainversa> lista = new List <logisticainversa>();
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionGlobal"].ToString()))
{
con.Open();
string sql = "exec SP_Logisticas_Index_ParametrosOpcionales @folio";
var query = new SqlCommand(sql, con);
if (logistica != "")
{
query.Parameters.AddWithValue("@folio", logistica);
}
else
{
query.Parameters.AddWithValue("@folio", DBNull.Value);
}
using (var dr = query.ExecuteReader())
{
while (dr.Read())
{
// facturas
var logisticasTemp = new logisticainversa();
logisticasTemp.id = Convert.ToInt32(dr["id"]);
logisticasTemp.Folio = dr["Folio"].ToString();
logisticasTemp.FechaAlta = Convert.ToDateTime(dr["FechaAlta"]);
logisticasTemp.status = dr["Estado"].ToString();
logisticasTemp.origen = dr["Origen"].ToString();
lista.Add(logisticasTemp);
}
}
}
if (!(string.IsNullOrEmpty(SortColumn) && string.IsNullOrEmpty(SortColumnDir)))
{
lista = lista.OrderBy(SortColumn + " " + SortColumnDir).ToList();
}
TotalRecords = lista.ToList().Count();
var NewItems = lista.Skip(Skip).Take(PageSize == -1 ? TotalRecords : PageSize).ToList();
return(Json(new { draw = Draw, recordsFiltered = TotalRecords, recordsTotal = TotalRecords, data = NewItems }, JsonRequestBehavior.AllowGet));
}
