public static List <Team> GetTeams(DataContextLocal dbLocal, Group group) { var teams = new List <Team>(); var teamsList = GetListTeam(group); //teams = dbLocal.Teams // .Except(teamsList) // .OrderBy(t => t.Name) // .ToList(); teams = dbLocal.Teams .OrderBy(t => t.Name) .ToList(); // CHEJ - Agrega un registro en blanco AddBlankTeam(teams); //teams.Add(new Team //{ // TeamId = 0, // Name = "[Select a team...!!!]", // ImagePath = string.Empty, //}); return(teams.OrderBy(t => t.Name).ToList()); }
void SumatoriaPrecios() { try { using (var db = new DataContextLocal()) { var Detalle = db.DetalleVentas.Where(q => q.VentaId == ventaId).ToList(); txtpangandoahora.Text = Detalle.Sum(q => q.Subtotal).ToString(); lblTotal.Text = Detalle.Sum(q => q.Subtotal).ToString(); var Venta = db.Ventas.Find(ventaId); Venta.TotalOrden = double.Parse(txtpangandoahora.Text); db.Entry(Venta).State = EntityState.Modified; db.SaveChanges(); var Subtotal = 0.0; var Descuento = 0.0; var ultimatarea = listaProductos.Last(); foreach (var item in Detalle) { var Cantidad = item.Cantidad; var Precio = item.Precio; Subtotal += (Cantidad * Precio); Descuento += ((Cantidad * Precio) * item.Descuento / 100); lblSubTotalabajo.Text = Subtotal.ToString(); lblDescuentoAbajo.Text = Descuento.ToString(); } } } catch (Exception) { } }
public async static Task <Response> SaveChanges(DataContextLocal db) { try { await db.SaveChangesAsync(); return(new Response { IsSuccess = true, }); } catch (Exception ex) { var response = new Response { IsSuccess = false, }; if (ex.InnerException != null && ex.InnerException.InnerException != null && ex.InnerException.InnerException.Message.Contains("_Index")) { response.Message = "There is a record with the same value"; } else if (ex.InnerException != null && ex.InnerException.InnerException != null && ex.InnerException.InnerException.Message.Contains("REFERENCE")) { response.Message = "The record can't be delete because it has related records"; } else { response.Message = ex.Message; } return(response); } }
public static async Task <Response> SaveChangeDB(DataContextLocal dbLocal) { try { await dbLocal.SaveChangesAsync(); return(new Response { IsSuccess = true, Message = "Save is ok...!!!", Result = null, }); } catch (Exception ex) { if (ex.InnerException != null && ex.InnerException.InnerException != null && !string.IsNullOrEmpty(ex.InnerException.InnerException.Message)) { if (ex.InnerException.InnerException.Message.Contains("REFERENCE")) { return(new Response { IsSuccess = false, Message = "The record can't be deleted, because it has related records...!!!", Result = null, }); } else if (ex.InnerException.InnerException.Message.ToUpper().Contains("INDEX")) { return(new Response { IsSuccess = false, Message = "There is already a record with the same name...!!!", Result = null, }); } else { return(new Response { IsSuccess = false, Message = ex.Message, Result = null, }); } } else { return(new Response { IsSuccess = false, Message = ex.Message, Result = null, }); } } }
public static List <Match> GetMatchs(DataContextLocal dbLocal) { var matchsList = new List <Match>(); matchsList = dbLocal.Matches.ToList(); matchsList.Add(new Match { MatchId = 0, }); return(matchsList.OrderBy(m => m.MatchId).ToList()); }
public static List <User> GetUsers(DataContextLocal dbLocal) { var userList = new List <User>(); userList = dbLocal.Users.ToList(); userList.Add(new User { UserId = 0, FirstName = "[Select a user...!!!]" }); return(userList.OrderBy(u => u.UserId).ToList()); }
public static List <UserType> GetUserType(DataContextLocal dbLocal) { var userTypeList = dbLocal.UserTypes .ToList(); userTypeList.Add(new UserType { Name = "[Select a type...!!!]", UserTypeId = 0, }); return(userTypeList.OrderBy(ut => ut.Name).ToList()); }
public static List <BoardStatus> GetBoradStatus(DataContextLocal dbLocal) { var boardStatusList = new List <BoardStatus>(); boardStatusList = dbLocal.BoardStatus.ToList(); boardStatusList.Add(new BoardStatus { BoardStatusId = 0, Name = "[Select a board status...!!!]", }); return(boardStatusList.OrderBy(bs => bs.Name).ToList()); }
public static List <Board> GetBorads(DataContextLocal dbLocal) { var boardsList = new List <Board>(); boardsList = dbLocal.Boards.ToList(); boardsList.Add( new Board { BoardId = 0, ImagePath = "[Select a board...!!!]", }); return(boardsList.OrderBy(b => b.BoardId).ToList()); }
protected override void Seed(DataContextLocal context) { // This method will be called after migrating to the latest version. // You can use the DbSet<T>.AddOrUpdate() helper extension method // to avoid creating duplicate seed data. E.g. // // context.People.AddOrUpdate( // p => p.FullName, // new Person { FullName = "Andrew Peters" }, // new Person { FullName = "Brice Lambson" }, // new Person { FullName = "Rowan Miller" } // ); // }
public static List <Nationality> GetNationalities(DataContextLocal dbLocal) { var nationality = dbLocal.Nationalities .OrderBy(n => n.NationalityId) .ToList(); nationality.Add(new Nationality { NationalityId = 0, Abbreviation = "S", Name = "[Select a nationality...!!!]", }); return(nationality.OrderBy(n => n.NationalityId).ToList()); }
public static int GetStatusMatchIdByName(string statusMatchName, DataContextLocal dbLocal) { var statusMatch = dbLocal.StatusMatches .Where(sm => sm.Name == statusMatchName) .FirstOrDefault(); if (statusMatch != null) { return(statusMatch.StatusMatchId); } else { // CHEJ - Invoca el metodo que crea el StatusMacth por nombre return(CreateStatusMatchByName(statusMatchName, dbLocal)); } }
public static List <Team> GetTeams(int groupId, int localId, DataContextLocal dbLocal) { // CHEJ - Hace el select de datos de los Teams que pertenecen al grupo var team = from Team in dbLocal.Teams join GroupTeam in dbLocal.GroupTeams on Team.TeamId equals GroupTeam.TeamId where GroupTeam.GroupId == groupId select Team; // CHEJ - Transforma el resultado de la consulta en un objeto List<> var teamList = new List <Team>(team); // CHEJ - Agrega un registro en blanco AddBlankTeam(teamList); return(teamList.OrderBy(t => t.Name).ToList()); }
public static List <User> GetUsersGetServicesVzLa(DataContextLocal dbLocal) { var appName = MethodsHelper.GetAppNameGetServices(); var userList = dbLocal.Users .Where(u => u.AppName == appName) .ToList(); userList.Add(new User { UserId = 0, FirstName = "[Select an user...!!!]", LastName = string.Empty, } ); return(userList.OrderBy(u => u.UserId).ToList()); }
public static bool FindByName(string nombre) { try { using (DataContextLocal db = new DataContextLocal()) { if (db.HorarioRubros.Where(e => e.Nombre == nombre).Count() > 0) { return(true); } return(false); } } catch { return(true); } }
public static bool FindByName(string nombre) { try { using (DataContextLocal db = new DataContextLocal()) { if (db.TipoPagos.Where(e => e.Nombre == nombre).Count() > 0) { return(true); } return(false); } } catch (Exception ex) { throw; } }
/// <summary> /// Metodo que busca el usuario logueado /// </summary> /// <returns></returns> public static User GetUserLogin(string userName, DataContextLocal dbLocal) { try { //return dbLocal.Users // .Where(u => u.UserName == userName) // .FirstOrDefault(); return(dbLocal.Users .Where(u => u.Email == userName) .FirstOrDefault()); } catch (Exception) { return(new User { }); } }
/// <summary> /// Metodo asincrono que busca el usuario logueado /// </summary> /// <returns></returns> public static async Task <User> GetAsyncUserLogin(string userName, DataContextLocal dbLocal) { try { //return await dbLocal.Users // .Where(u => u.UserName == userName) // .FirstOrDefaultAsync(); return(await dbLocal.Users .Where(u => u.Email == userName) .FirstOrDefaultAsync()); } catch (Exception) { return(new User { }); } }
private static int CreateStatusMatchByName(string statusMatchName, DataContextLocal dbLocal) { try { var statusMacth = new StatusMatch { Name = statusMatchName, }; dbLocal.Entry(statusMatchName); dbLocal.SaveChanges(); return(statusMacth.StatusMatchId); } catch (Exception) { return(-1); } }
public static void Add(int id, string nombre, bool activa) { try { using (DataContextLocal db = new DataContextLocal()) { var horario = new HorarioRubro { HorarioRubroId = id, Nombre = nombre, Activo = activa, }; db.HorarioRubros.Add(horario); db.SaveChanges(); } } catch { } }
public static void Add(int id, string nombre, bool activa) { try { using (DataContextLocal db = new DataContextLocal()) { var tipo = new TipoPago { TipoPagoId = id, Nombre = nombre, Activo = activa, }; db.TipoPagos.Add(tipo); db.SaveChanges(); } } catch (Exception) { throw; } }
public static void Add(int id, string nombre, Color color) { try { using (DataContextLocal db = new DataContextLocal()) { var estado = new Estados { EstadoId = id, Nombre = nombre, Color = color, }; db.Estados.Add(estado); db.SaveChanges(); } } catch (Exception) { throw; } }
public static void Add(int id, string nombre, bool activa) { try { using (DataContextLocal db = new DataContextLocal()) { var item = new EstadoMarca { EstadoMarcaId = id, Nombre = nombre, Activa = activa, }; db.EstadoMarcas.Add(item); db.SaveChanges(); } } catch (Exception) { throw; } }
public static void Add(int estadoCivilId, string nombre, bool activa) { try { using (DataContextLocal db = new DataContextLocal()) { var estadoCivil = new EstadoCivil { EstadoCivilId = estadoCivilId, Nombre = nombre, Activa = activa, }; db.EstadosCiviles.Add(estadoCivil); db.SaveChanges(); } } catch (Exception) { throw; } }
void GuardarCambiosProductos() { try { using (var db = new DataContextLocal()) { var ultimatarea = listaProductos.Last(); var consulta = db.DetalleVentas.Where(q => q.VentaId == ventaId).ToList(); var IdDetalle = consulta.LastOrDefault().DetalleVentasId; var CantidadArticulos = int.Parse(ultimatarea.txtPrecio.Text); DetalleVentas detalle = db.DetalleVentas.Find(IdDetalle); detalle.Cantidad = CantidadArticulos; detalle.Subtotal = double.Parse(ultimatarea.lblSubTotal.Text); detalle.Descuento = Descuento; try { db.Entry(detalle).State = EntityState.Modified; db.SaveChanges(); } catch (Exception ex) { } SumatoriaPrecios(); } } catch (Exception) { } }
public static async Task <Response> SaveChanges(DataContextLocal db) { try { await db.SaveChangesAsync(); return(new Response { Succeeded = true, }); } catch (Exception ex) { var response = new Response { Succeeded = false, }; if (ex.InnerException != null && ex.InnerException.InnerException != null && ex.InnerException.InnerException.Message.Contains("_Index")) { response.Message = "Hay un registro con el mismo valor."; } else if (ex.InnerException != null && ex.InnerException.InnerException != null && ex.InnerException.InnerException.Message.Contains("REFERENCE")) { response.Message = "El registro no se puede eliminar porque tiene registros relacionados"; } else { response.Message = ex.Message; } return(response); } }
private void pictureBox3_Click(object sender, EventArgs e) { try { using (var db = new DataContextLocal()) { var Mensaje = MessageBox.Show("Esta Seguro desea Salir Y Borrar Esa Venta Del Sistema", "Mensaje", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (Mensaje == DialogResult.Yes) { var detalle = db.DetalleVentas.Where(q => q.VentaId == ventaId).ToList(); if (detalle.Count > 0) { foreach (var item in detalle) { db.DetalleVentas.Remove(item); db.SaveChanges(); } } Ventas venta = db.Ventas.Find(ventaId); db.Ventas.Remove(venta); db.SaveChanges(); this.Close(); } } } catch (Exception) { } }
public List <Chef> GetChefs(DateTime afterDate) { DataContextLocal db = new DataContextLocal(); return(db.Chefs.ToList());; }
private void btnFacturar_Click(object sender, EventArgs e) { try { if (ClienteId == null) { if (txtEmail.Text.Trim() == "Correo Cliente") { txtEmail.Text = ""; } if (txttelefonodos.Text.Trim() == "Teléfono 2") { txttelefonodos.Text = ""; } if (txtDirecion.Text.Trim() == "Dirrecion") { txtDirecion.Text = ""; } if (txtCodigoPostal.Text.Trim() == "Cedula") { txtCodigoPostal.Text = ""; } if (txtDirecion.Text.Trim() == "Ciudad") { txtDirecion.Text = ""; } { Cliente cliente = new Cliente(); cliente.Nombre = txtNombre.Text; cliente.Email = txtEmail.Text; cliente.TelefonoPrincipal = txttelefonoprincipal.Text; cliente.Direcion = txttelefonodos.Text; cliente.TelefonoDos = txtDirecion.Text; cliente.numeroProvincia = int.Parse(cmbProvincia.SelectedValue.ToString()); cliente.numeroDistrito = int.Parse(cmbDistrito.SelectedValue.ToString()); cliente.numeroCanton = int.Parse(cmbCanton.SelectedValue.ToString()); cliente.Cedula = txtCodigoPostal.Text; if (cmbabreviatura.SelectedValue != null) { cliente.Abreviatura = cmbabreviatura.SelectedValue.ToString(); } db.Clientes.Add(cliente); db.SaveChanges(); var querys = db.Clientes.ToList(); var ultimoIdCliente = querys.LastOrDefault().ClienteId; var querydos = db.Ordenes.ToList(); var ultimaIdOrden = querydos.LastOrDefault().OrdenId; Ordenes orden = db.Ordenes.Find(ultimaIdOrden); orden.ClienteId = ultimoIdCliente; db.Entry(orden).State = EntityState.Modified; db.SaveChanges(); GuardarCambiosProductos(); frmPin pins = new frmPin(); this.Opacity = 0.80; pins.ShowDialog(); this.Opacity = 1; var querysr = db.Clientes.Where(q => q.TelefonoPrincipal == txttelefonoprincipal.Text).ToList(); if (querysr.Count > 0) { using (var db = new DataContextLocal()) { var Ventas = db.Ventas.Find(ventaId); var TotalVenta = int.Parse(Ventas.TotalOrden.ToString()); var CantidadPagada = int.Parse(txtpangandoahora.Text); var Resultado = TotalVenta - CantidadPagada; Ventas.CantidadRestante = Resultado; Ventas.EmpleadoRealizo = Program.Pin; Ventas.CantidadPagada = double.Parse(txtpangandoahora.Text); Ventas.ClienteId = ultimoIdCliente; db.Entry(Ventas).State = EntityState.Modified; db.SaveChanges(); } } this.Close(); } } else { GuardarCambiosProductos(); frmPin pin = new frmPin(); this.Opacity = 0.80; pin.ShowDialog(); this.Opacity = 1; var query = db.Clientes.Where(q => q.TelefonoPrincipal == txttelefonoprincipal.Text).ToList(); if (query.Count > 0) { var clienteid = db.Clientes.Where(q => q.TelefonoPrincipal == txttelefonoprincipal.Text).FirstOrDefault().ClienteId; using (var db = new DataContextLocal()) { var Ventas = db.Ventas.Find(ventaId); var TotalVenta = int.Parse(Ventas.TotalOrden.ToString()); var CantidadPagada = int.Parse(txtpangandoahora.Text); var Resultado = TotalVenta - CantidadPagada; Ventas.CantidadRestante = Resultado; Ventas.EmpleadoRealizo = Program.Pin; Ventas.CantidadPagada = double.Parse(txtpangandoahora.Text); Ventas.ClienteId = clienteid; db.Entry(Ventas).State = EntityState.Modified; db.SaveChanges(); } } this.Close(); } } catch (Exception) { } }