public List <Services> GetServiceByTypeId(int id)
{
ServicesQuery serviceQuery = new ServicesQuery(language);
System.Data.DataTable dataTable = conn_db.ReadTable(serviceQuery.GetServiceByTypeId(id));
if (dataTable.Rows.Count == 0)
{
throw new EmptyViewException(language);
}
List <Services> listServices = new List <Services>();
foreach (System.Data.DataRow row in dataTable.Rows)
{
Services service = new Services();
service.id = Convert.ToInt32(row["ID"].ToString());
service.SERVICENAME_AR = row["SERVICENAME_AR"].ToString();
service.SERVICENAME_EN = row["SERVICENAME_EN"].ToString();
service.SERVICEPRICE = Convert.ToDouble(row["SERVICEPRICE"].ToString());
service.SERVICETIME = Convert.ToInt32(row["SERVICETIME"].ToString());
service.SERVICETYPE_ID = Convert.ToInt32(row["SERVICETYPE_ID"].ToString());
service.IMAGE = row["IMAGE"].ToString();
listServices.Add(service);
}
return(listServices);
}
public List <UserBill> GetWorkshopBills(int workshop_id)
{
ServicesQuery serviceQuery = new ServicesQuery(language);
System.Data.DataTable dataTable = conn_db.ReadTable(serviceQuery.GetWorkshopBill(workshop_id));
if (dataTable.Rows.Count == 0)
{
throw new EmptyViewException(language);
}
List <UserBill> UserBills = new List <UserBill>();
foreach (System.Data.DataRow row in dataTable.Rows)
{
UserBill userBill = new UserBill();
userBill.id = Convert.ToInt32(row["ID"].ToString());
userBill.PLATENUMBER = row["PLATENUMBER"].ToString();
userBill.ACCIDENTDATE = Convert.ToDateTime(row["ACCIDENTDATE"].ToString()).ToString("yyyy-mm-dd");
userBill.USER_ID = Convert.ToInt32(row["USER_ID"].ToString());
userBill.FIX_PRICE = Convert.ToDouble(row["FIX_PRICE"].ToString());
userBill.SPARE_PRICE = Convert.ToDouble(row["SPARE_PRICE"].ToString());
userBill.RENT_PRICE = Convert.ToDouble(row["RENT_PRICE"].ToString());
userBill.TRANSCAR_PRICE = Convert.ToDouble(row["TRANSCAR_PRICE"].ToString());
userBill.note = row["NOTE"].ToString();
userBill.workshop_id = Convert.ToInt32(row["workshop_id"].ToString());
UserBills.Add(userBill);
}
return(UserBills);
}
public UserServiceDetailsViewModel(Services service)
{
Service = service;
Tags = new ServicesQuery().GetTags();
DeleteService = new DelegateCommand <object>(ServiceDelete);
CancelCom = new DelegateCommand <string>(Cancel);
DeleteOrder = new DelegateCommand <object>(Delete);
Orders = new ObservableCollection <Orders>();
Orders.FromListToObservableCollection(Service.Orders);
EditService = new DelegateCommand <string>(Edit);
}
public string ComparePassword(string oldPassword, int user_id)
{
ServicesQuery serviceQuery = new ServicesQuery(language);
System.Data.DataTable dataTable = conn_db.ReadTable(serviceQuery.ComparePassword(oldPassword, user_id));
if (dataTable.Rows.Count == 0)
{
throw new EmptyViewException(language);
}
return(dataTable.Rows[0]["Password"].ToString());
}
public List <ServiceTypes> GetServiceTypes()
{
ServicesQuery serviceQuery = new ServicesQuery(language);
System.Data.DataTable dataTable = conn_db.ReadTable(serviceQuery.GetMasterTranslated("servicetypes", language));
if (dataTable.Rows.Count == 0)
{
throw new EmptyViewException(language);
}
List <ServiceTypes> listServiceTypes = new List <ServiceTypes>();
foreach (System.Data.DataRow row in dataTable.Rows)
{
ServiceTypes serviceTypes = new ServiceTypes();
serviceTypes.serviceTypeId = Convert.ToInt32(row["ID"].ToString());
serviceTypes.serviceType_Name = row["SERVICETYPES_NAME"].ToString();
serviceTypes.serviceType_icon = row["serviceType_icon"].ToString();
listServiceTypes.Add(serviceTypes);
}
return(listServiceTypes);
}
public ServicesController(ServicesQuery svcQuery)
{
_svcQuery = svcQuery;
}
public UserServicesViewModel()
{
ChangeViewModel = new DelegateCommand <object>(Details);
Services = new ServicesQuery().GetUserServices(Changer.CurrentUserID);
}
public ServicesController(ServicesQuery servicesQuery)
{
_servicesQuery = servicesQuery;
}
public AddServiceViewModel()
{
AddNewService = new DelegateCommand <object>(ServiceAdd, CanExecute);
Service = new Services();
Tags = new ServicesQuery().GetTags();
}
