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