public Boolean c_SaveScheduleHealth(ScheduleHealth scheduleHealth) { Boolean res = false; //using (TransactionScope ts = new TransactionScope()) //{ // try // { // using (var Context = new Cubicle_EntityEntities()) // { // var a = Context.ScheduleHealths.Where(p => p.ScheduleType == scheduleHealth.ScheduleType); // foreach (var s in a) // Context.ScheduleHealths.Remove(s); // Context.SaveChanges(); // Context.ScheduleHealths.Add(scheduleHealth); // Context.SaveChanges(); // } // ts.Complete(); // res = true; // } // catch (Exception ex) // { // ts.Dispose(); // res = false; // //bool false = BusinessLogicExceptionHandler.HandleException(ref ex); // if (false) // { // throw ex; // } // } //} return(res); }
//public Boolean CheckDuplicate(ScheduleHealth scheduleHealth, Boolean IsInsert) //{ // Boolean Result = true; // var c = _scheduleHealthRepository.GetSingle(p => p.ScheduleHealthName == scheduleHealth.ScheduleHealthName && p.ScheduleHealthCode == scheduleHealth.ScheduleHealthCode && p.ClientID==scheduleHealth.ClientID); // if(!IsInsert) // { // if (c == null) // Result = true; // else if (c.ScheduleHealthID == scheduleHealth.ScheduleHealthID) // Result=true; // else // Result=false; // } // else // { // if (c == null) // Result = true; // else // Result = false; // } // return Result; //} //public IList<Client_ScheduleHealth_View> GetScheduleHealthList(ScheduleHealth scheduleHealth) //{ // IList<Client_ScheduleHealth_View> fetchedClient = new List<Client_ScheduleHealth_View>(); // using (var Context = new Cubicle_EntityEntities()) // { // IQueryable<Client_ScheduleHealth_View> query = Context.Client_ScheduleHealth_View; // if (scheduleHealth.ScheduleHealthName != string.Empty) // query = query.Where(p => p.ScheduleHealthName.ToUpper().Contains(scheduleHealth.ScheduleHealthName.ToUpper())); // if (scheduleHealth.ScheduleHealthCode != string.Empty) // query = query.Where(p => p.ScheduleHealthCode.ToUpper().Contains(scheduleHealth.ScheduleHealthCode.ToUpper())); // if(scheduleHealth.ClientID!=0) // query = query.Where(p => p.ClientID==scheduleHealth.ClientID); // fetchedClient = query.ToList(); // } // return fetchedClient; //} public ScheduleHealth GetScheduleHealthByType(string ScheduleType) { ScheduleHealth list = null; try { //using (var context = new Cubicle_EntityEntities()) //{ // list = context.ScheduleHealths.SingleOrDefault(d => d.ScheduleType == ScheduleType); //} } catch (Exception ex) { //bool false = BusinessLogicExceptionHandler.HandleException(ref ex); if (false) { throw ex; } } return(list); }
public ScheduleHealth GetTSH(string ScheduleType) { ScheduleHealth scheduleHealth = null; try { //using (var context = new Cubicle_EntityEntities()) //{ // scheduleHealth = context.ScheduleHealths.FirstOrDefault(p => p.ScheduleType == ScheduleType); //} } catch (Exception ex) { //bool false = BusinessLogicExceptionHandler.HandleException(ref ex); if (false) { throw ex; } } return(scheduleHealth); }