public List <ServicesClass> GetAllServices(int id) { int ShowRecords = 20; int skip = id * ShowRecords; var DesiMasala = ""; var AllRecords = obj.Services.Count(); int max = (skip + ShowRecords); if (max > AllRecords) { max = AllRecords; } DesiMasala = (skip + 1).ToString() + "-" + max.ToString() + "/" + AllRecords.ToString(); List <ServicesClass> li = new List <ServicesClass>(); var AllServices = obj.Services.Skip(skip).Take(ShowRecords).Where(x => x.Status != 0).ToList(); var count = AllServices.Count(); foreach (var details in AllServices) { ServicesClass temp = new ServicesClass(); temp.Id = details.Id; temp.Name = details.Name; temp.Description = details.Description; temp.Count = count; temp.NumberOfShowing = DesiMasala; li.Add(temp); } return(li); }
public int UpdateService(ServicesClass SC) { int check = 0; try { Service service = obj.Services.First(x => x.Id.Equals(SC.Id)); service.Name = SC.Name; service.Description = SC.Description; service.Status = 1; obj.SubmitChanges(); check = service.Id; } catch (Exception e) { check = 0; } return(check); }
public int PostService(ServicesClass SC) { int check = 0; try { Service service = new Service(); service.Name = SC.Name; service.Description = SC.Description; service.Status = 1; service.AddDate = DateTime.Now.ToShortDateString(); obj.Services.InsertOnSubmit(service); obj.SubmitChanges(); check = service.Id; } catch (Exception e) { check = 0; } return(check); }
public List <ServicesClass> GetAllServicesById(int id) { List <ServicesClass> li = new List <ServicesClass>(); var AllServices = obj.Services.Where(x => x.Status != 0 && x.Id.Equals(id)).ToList(); var count = AllServices.Count(); foreach (var details in AllServices) { ServicesClass temp = new ServicesClass(); temp.Id = details.Id; temp.Name = details.Name; temp.Description = details.Description; temp.Count = count; li.Add(temp); } return(li); }
/// <summary> /// Initialise l'objet d'application de singleton. Il s'agit de la première ligne du code créé /// à être exécutée. Elle correspond donc à l'équivalent logique de main() ou WinMain(). /// </summary> /// public App() { this.InitializeComponent(); this.Suspending += OnSuspending; this.servicesClass = new ServicesClass(); }