public static bool Exist(DateTime fecha, TipoIngresoCaja tipoIngresoCaja)
{
using (ClinicaMerced.Common.Entities.Caja.ClinicaCajaDataContext dc = new ClinicaMerced.Common.Entities.Caja.ClinicaCajaDataContext(CommonDAC.clinica_cnnstring_value))
{
return(dc.CierreCajaDiarios.Any <ClinicaMerced.Common.Entities.Caja.CierreCajaDiario>(
s => s.Fecha.Value.Day.Equals(fecha.Day) &&
s.IdTipoIngreso == (int)tipoIngresoCaja));
}
}
/// <summary>
///
/// </summary>
/// <param name="fecha"></param>
/// <returns></returns>
public static bool Exist(DateTime fecha, int idProfecional)
{
using (ClinicaMerced.Common.Entities.Caja.ClinicaCajaDataContext dc = new ClinicaMerced.Common.Entities.Caja.ClinicaCajaDataContext(CommonDAC.clinica_cnnstring_value))
{
return(dc.CierreCajaDiarios.Any <ClinicaMerced.Common.Entities.Caja.CierreCajaDiario>(
s => s.Fecha.Value.Day.Equals(fecha.Day) &&
s.IdProfecional.Equals(idProfecional)));
}
}
public static ClinicaMerced.Common.Entities.Caja.CierreCajaDiario Get(DateTime fecha, int idProfecional)
{
using (ClinicaMerced.Common.Entities.Caja.ClinicaCajaDataContext dc = new ClinicaMerced.Common.Entities.Caja.ClinicaCajaDataContext())
{
var x = from s in dc.CierreCajaDiarios where
s.Fecha.Value.ToShortDateString().Equals(fecha.ToShortDateString()) &&
s.IdProfecional.Equals(idProfecional) select s;
return(x.FirstOrDefault <ClinicaMerced.Common.Entities.Caja.CierreCajaDiario>());
}
}
public static List <ClinicaMerced.Common.Entities.Caja.vw_ConsultaToCierreCajaDetail> Retrive_Details(DateTime f)
{
using (ClinicaMerced.Common.Entities.Caja.ClinicaCajaDataContext dc = new ClinicaMerced.Common.Entities.Caja.ClinicaCajaDataContext(CommonDAC.clinica_cnnstring_value))
{
return(dc.vw_ConsultaToCierreCajaDetails.Where(
p => p.Fecha.Day.Equals(f.Day) &&
p.Fecha.Month.Equals(f.Month) &&
p.Fecha.Year.Equals(f.Year)).ToList <ClinicaMerced.Common.Entities.Caja.vw_ConsultaToCierreCajaDetail>());
}
}
public static void Create(List <ClinicaMerced.Common.Entities.Caja.CierreCajaDiario> list)
{
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.RequiresNew))
{
using (ClinicaMerced.Common.Entities.Caja.ClinicaCajaDataContext dc =
new ClinicaMerced.Common.Entities.Caja.ClinicaCajaDataContext(CommonDAC.clinica_cnnstring_value))
{
foreach (ClinicaMerced.Common.Entities.Caja.CierreCajaDiario c in list)
{
dc.CierreCajaDiarios.InsertOnSubmit(c);
}
dc.SubmitChanges();
}
scope.Complete();
}
}
