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