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