public List <Prenda> ListaPrenda()
{
using (AlmacenEntities context = new AlmacenEntities())
{
return(context.Prendas.ToList());
}
}
public List <Bordado> ListaBordados()
{
using (AlmacenEntities context = new AlmacenEntities())
{
return(context.Bordadoes.Include("IdBordado").OrderBy(e => e.IdBordado).ToList());
}
}
public List <Solicitud_Requisiciones> GetAllGruposLigero(int page, int pageSize)
{
try
{
using (var bd = new AlmacenEntities())
{
int pageIndex = Convert.ToInt32(page);
/*var query = bd.Solicitud_Requisiciones.Where(s=>s.requisicion!="n/a").Select(store => new SolicitudLite {
* preRequisicion = store.preRequisicion,
* requisicion = store.requisicion,
* uso=store.uso,
* departamento=store.departamento,
* ciclo=store.ciclo,
* area=store.area,
* ejercicio=store.ejercicio,
* observaciones=store.observaciones,
* fechaNecesitar=store.fechaNecesitar,
* fechaRequisicion=store.fechaRequisicion
* });*/
IEnumerable <Solicitud_Requisiciones> query = bd.Solicitud_Requisiciones.Where(s => s.requisicion != "n/a");
var Results = query.OrderByDescending(s => s.preRequisicion).Skip(pageIndex * pageSize).Take(pageSize).ToList();
return(Results);
//var list = bd.GpoMateriales.Select(store => new GpoMateriales { numGpo = store.numGpo, descripcion= store.descripcion});
//return query.ToList();
}
}
catch (SqlException odbcEx)
{
var error = odbcEx;
return(null);
}
}
public List <LugarEntrega> ListaLugarEntregas()
{
using (AlmacenEntities context = new AlmacenEntities())
{
return(context.LugarEntregas.OrderBy(e => e.Nombre).ToList());
}
}
public Detalle ObtenerDetalle(short id)
{
using (AlmacenEntities context = new AlmacenEntities())
{
return(context.Detalles.Where(e => e.Id == id).FirstOrDefault());
}
}
public Object guardarGrupo(GpoMateriales grupo)
{
try
{
Object result = "";
using (var db = new AlmacenEntities())
{
var us = db.GpoMateriales.Where(u => u.numGpo == grupo.numGpo).FirstOrDefault();
if (us == null)
{
db.GpoMateriales.Add(grupo);
db.SaveChanges();
result = new { message = "Se guardo correctamente", code = 1 };
}
else
{
result = new { message = "Ya existe este grupo: " + grupo.numGpo, code = 2 };
}
return(result);
}
}
catch (SqlException odbcEx)
{
Object result = new { message = "Error: " + odbcEx.Message.ToString(), code = 2 };
return(result);
}
catch (Exception ex)
{
Object result = new { message = "Error: " + ex.Message.ToString(), code = 2 };
return(result);
}
}
public Object borrarGrupo(GpoMateriales grupo)
{
try
{
string s;
var context = new AlmacenEntities();
var connection = context.Database.Connection;
using (SqlConnection con = new SqlConnection(connection.ConnectionString))
{
string query = "DELETE FROM GpoMateriales WHERE numGpo=@numGpo";
query += " SELECT SCOPE_IDENTITY()";
using (SqlCommand cmd = new SqlCommand(query))
{
cmd.Connection = con;
con.Open();
cmd.Parameters.AddWithValue("@numGpo", grupo.numGpo);
s = cmd.ExecuteScalar().ToString();
con.Close();
}
}
Object result = new { message = "Se borro correctamente", code = 1 };
return(result);
}
catch (SqlException odbcEx)
{
Object result = new { message = "Error: " + odbcEx.Message.ToString(), code = 2 };
return(result);
}
catch (Exception ex)
{
Object result = new { message = "Error: " + ex.Message.ToString(), code = 2 };
return(result);
}
}
public int numeroSol()
{
try {
var context = new AlmacenEntities();
var connection = context.Database.Connection;
int cont = 0;
using (SqlConnection con = new SqlConnection(connection.ConnectionString))
{
string query = "SELECT COUNT(*) FROM Solicitud_Requisiciones WHERE liberaLocal='A' AND liberaCapitalHumano='A' " +
"AND liberaElectrico='A' AND liberaSeguridad='A' AND liberaAlmacen='P' AND requisicion='n/a'";
using (SqlCommand cmd = new SqlCommand(query))
{
cmd.Connection = con;
con.Open();
cont = Convert.ToInt32(cmd.ExecuteScalar());
con.Close();
}
}
return(cont);
}
catch (SqlException odbcEx)
{
var error = odbcEx;
return(0);
}
}
public List <Solicitud_Requisiciones> GetSolicitudesAll(string depa)
{
try
{
AlmacenEntities DB = new AlmacenEntities();
if (depa == "")
{
var Results = DB.Solicitud_Requisiciones.Where(s => s.liberaLocal == "A" && s.liberaCapitalHumano == "A" &&
s.liberaElectrico == "A" && s.liberaSeguridad == "A" && s.liberaAlmacen == "P" && s.requisicion == "n/a")
.OrderBy(s => s.preRequisicion).ToList();
return(Results);
}
else
{
var dep = DB.Departamentos.Where(s => s.descripcion == depa).FirstOrDefault();
var Results = DB.Solicitud_Requisiciones.Where(s => s.liberaLocal == "A" && s.liberaCapitalHumano == "A" &&
s.liberaElectrico == "A" && s.liberaSeguridad == "A" && s.liberaAlmacen == "P" && s.requisicion == "n/a" && s.departamento == dep.idDepartamento)
.OrderBy(s => s.preRequisicion).ToList();
return(Results);
}
}
catch (SqlException odbcEx)
{
var error = odbcEx;
return(null);
}
}
public List <dynamic> GetSolicitudDet(int preReq, int dep, int ejercicio)
{
try
{
AlmacenEntities DB = new AlmacenEntities();
var Results = (from pd in DB.DetalleRequisicion
orderby pd.partida
select new
{
pd.partida,
pd.preRequisicion,
pd.departamento,
pd.material,
pd.cantidad,
pd.detalle,
pd.ejercicio,
pd.costoU,
pd.costoTotal,
pd.FechaUltimaEntrada,
pd.descripcion,
existencia = (DB.Materiales.Where(s => s.idMaterial == pd.material).FirstOrDefault().existencia == null)?pd.existencia: DB.Materiales.Where(s => s.idMaterial == pd.material).FirstOrDefault().existencia
}).Where(s => s.preRequisicion == preReq && s.departamento == dep && s.ejercicio == ejercicio).ToList();
return(Results.ToList <dynamic>());
}
catch (SqlException odbcEx)
{
var error = odbcEx;
return(null);
}
}
public int getConsecutivo(string ciclo, string departamento, int ejercicio)
{
List <listaS> c = new List <listaS>();
using (var bd = new AlmacenEntities())
{
foreach (var x in bd.Solicitud_Requisiciones)
{
if (x.requisicion != "n/a")
{
string[] sp = x.requisicion.Split('/');
string ci = "" + sp[0].ToString()[0];
string dep = "" + sp[0].ToString()[1] + sp[0].ToString()[2];
string ej = sp[2].ToString();
string ej2 = "" + ejercicio.ToString()[2] + ejercicio.ToString()[3];
if (ci.Equals(ciclo) && dep.Equals(departamento) && ej.Equals(ej2))
{
int conse = Int32.Parse(sp[1]);
c.Add(new listaS
{
id = conse
});
}
}
}
}
int max = 0;
if (c.Count != 0)
{
max = c.Max(t => t.id);
}
return(max + 1);
}
public Diseño ObtenerDiseño(short id)
{
using (AlmacenEntities context = new AlmacenEntities())
{
return(context.Diseño.Where(e => e.Id == id).FirstOrDefault());
}
}
public List <Diseño> ListaDiseñosActivos()
{
using (AlmacenEntities context = new AlmacenEntities())
{
return(context.Diseño.OrderBy(e => e.Codigo).Where(q => q.Activo == true).ToList());
}
}
public List <Diseño> ListaDiseños()
{
using (AlmacenEntities context = new AlmacenEntities())
{
return(context.Diseño.Include("Usuario").OrderBy(e => e.Codigo).ToList());
}
}
public List <Corte> ListaCortes()
{
using (AlmacenEntities context = new AlmacenEntities())
{
return(context.Cortes.Include("Prenda").OrderBy(e => e.IdCorte).ToList());
}
}
public List <Talla> ListaTallas()
{
using (AlmacenEntities context = new AlmacenEntities())
{
return(context.Tallas.OrderBy(e => e.Talla1).ToList());
}
}
protected void btn_save_Click(object sender, EventArgs e)
{
string pass = txtpassword.Value.ToString();
string conf = txtconfirm.Value.ToString();
if (pass == conf)
{
using (AlmacenEntities modelo = new AlmacenEntities())
{
Usuario detail = new Usuario()
{
contrasenia = txtpassword.Value,
correo = txtemail.Value,
idRol = 2,
usuario1 = txtuser.Value,
nombre = txtname.Value
};
modelo.Usuario.Add(detail);
modelo.SaveChanges();
string script = "alert(\"Usuario creado exitosamente.\");";
ScriptManager.RegisterStartupScript(this, GetType(),
"ServerControlScript", script, true);
}
Response.Redirect("Login.aspx");
}
else
{
string script = "alert(\"Contraseñas no coinciden.\");";
ScriptManager.RegisterStartupScript(this, GetType(),
"ServerControlScript", script, true);
}
}
public List <Talla> ListaTallasActivas()
{
using (AlmacenEntities context = new AlmacenEntities())
{
return(context.Tallas.OrderBy(e => e.Talla1).Where(q => q.activo == true).ToList());
}
}
public Object editarGrupo(GpoMateriales grupo, int numGpo)
{
try
{
Object result = "";
grupo.numGpo = (Int16)numGpo;
using (var bd = new AlmacenEntities())
{
bd.Entry(grupo).State = System.Data.Entity.EntityState.Modified;
bd.SaveChanges();
result = new { message = "Se edito correctamente", code = 1 };
return(result);
}
}
catch (SqlException odbcEx)
{
Object result = new { message = "Error: " + odbcEx.Message.ToString(), code = 2 };
return(result);
}
catch (Exception ex)
{
Object result = new { message = "Error: " + ex.Message.ToString(), code = 2 };
return(result);
}
}
public Talla ObtenerTalla(short id)
{
using (AlmacenEntities context = new AlmacenEntities())
{
return(context.Tallas.Where(e => e.Id == id).FirstOrDefault());
}
}
public List <GpoMateriales> GetGruposFiltros(int noGpo, string desc)
{
try
{
using (var bd = new AlmacenEntities())
{
IEnumerable <GpoMateriales> query = bd.GpoMateriales;
if (desc != "")
{
query = query.Where(s => s.descripcion.ToUpper().Contains(desc.ToUpper()));
}
if (noGpo > -1)
{
query = query.Where(s => s.numGpo.ToString().Contains(noGpo.ToString()));
}
var Results = query.OrderBy(s => s.numGpo).ToList();
return(Results);
}
}
catch (SqlException odbcEx)
{
var error = odbcEx;
return(null);
}
}
public ActionResult RechazarSolicitud(int preRequisicion)
{
try
{
var context = new AlmacenEntities();
var connection = context.Database.Connection;
string s = "";
using (SqlConnection con = new SqlConnection(connection.ConnectionString))
{
string query = "UPDATE Solicitud_Requisiciones SET liberaLocal = 'N' WHERE preRequisicion =" + preRequisicion;
using (SqlCommand cmd = new SqlCommand(query))
{
cmd.Connection = con;
con.Open();
s += cmd.ExecuteScalar();
con.Close();
}
}
return(RedirectToAction("Revision"));
}
catch (SqlException odbcEx)
{
return(RedirectToAction("Revision"));
}
catch (Exception ex)
{
return(RedirectToAction("Revision"));
}
}
public LugarEntrega ObtenerLugarEntrega(short id)
{
using (AlmacenEntities context = new AlmacenEntities())
{
return(context.LugarEntregas.Where(e => e.Id == id).FirstOrDefault());
}
}
public Usuario ObtenerUsuario(short id)
{
using (AlmacenEntities context = new AlmacenEntities())
{
return(context.Usuarios.Where(e => e.Id == id).FirstOrDefault());
}
}
public List <Bodega> ListaBodegas()
{
using (AlmacenEntities context = new AlmacenEntities())
{
return(context.Bodegas.Include("Usuario").OrderBy(e => e.Nombre).ToList());
}
}
public List <Proceso> ListaProcesos()
{
using (AlmacenEntities context = new AlmacenEntities())
{
return(context.Procesoes.OrderBy(e => e.Descripcion).ToList());
}
}
public Bordado ObtenerBordado(short id)
{
using (AlmacenEntities context = new AlmacenEntities())
{
return(context.Bordadoes.Where(e => e.Id == id).FirstOrDefault());
}
}
public Proceso ObtenerProceso(short id)
{
using (AlmacenEntities context = new AlmacenEntities())
{
return(context.Procesoes.Where(e => e.Id == id).FirstOrDefault());
}
}
public int numeroSol()
{
try
{
var context = new AlmacenEntities();
var connection = context.Database.Connection;
int cont = 0;
using (SqlConnection con = new SqlConnection(connection.ConnectionString))
{
string query = "SELECT COUNT(*) FROM Solicitud_Requisiciones";
using (SqlCommand cmd = new SqlCommand(query))
{
cmd.Connection = con;
con.Open();
cont = Convert.ToInt32(cmd.ExecuteScalar());
con.Close();
}
}
return(cont);
}
catch (SqlException odbcEx)
{
var error = odbcEx;
return(0);
}
}
public Object editarMaterial(Materiales material, MaterialesContable materialesContable)
{
try
{
using (var bd = new AlmacenEntities())
{
Object result = "";
var idMC = bd.MaterialesContable.AsNoTracking().Where(s => s.idMaterial == material.idMaterial).FirstOrDefault().idMaterialesCont;
materialesContable.idMaterialesCont = idMC;
bd.Entry(material).State = System.Data.Entity.EntityState.Modified;
bd.Entry(materialesContable).State = System.Data.Entity.EntityState.Modified;
bd.SaveChanges();
result = new { message = "Se edito correctamente", code = 1 };
return(result);
}
}
catch (SqlException odbcEx)
{
Object result = new { message = "Error: " + odbcEx.Message.ToString(), code = 2 };
return(result);
}
catch (Exception ex)
{
Object result = new { message = "Error: " + ex.Message.ToString(), code = 2 };
return(result);
}
}
