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