public SelectCompletedCoursesViewModel(ISqlData sqlData, IEventAggregator eventAggregator)
{
_sqlData = sqlData;
_eventAggregator = eventAggregator;
_allCourses = new BindableCollection <CourseModel>(_sqlData.GetAllCourses());
_completedCourses = new List <CompletedCourseModel>(_sqlData.GetAllCompletedCourses(UserName));
}
public ShellViewModel(ISqlData sqlData, IEventAggregator eventAggregator)
{
_sqlData = sqlData;
_eventAggregator = eventAggregator;
_eventAggregator.Subscribe(this);
SelectedPage = "0";
LoadPage();
}
public SelectFutureCoursesViewModel(ISqlData sqlData, IEventAggregator eventAggregator)
{
_sqlData = sqlData;
_eventAggregator = eventAggregator;
_yearOneCourses = new BindableCollection <CourseModel>(_sqlData.GetCoursesByYear(1));
_yearTwoCourses = new BindableCollection <CourseModel>(_sqlData.GetCoursesByYear(2));
_yearThreeCourses = new BindableCollection <CourseModel>(_sqlData.GetCoursesByYear(3));
_completedCourses = new List <CompletedCourseModel>(_sqlData.GetAllCompletedCourses(UserName));
Majors = new BindableCollection <MajorModel>(_sqlData.GetAllMajors());
}
public void Delete(ISqlData data)
{
if (data != null)
{
SqlCommand deleteCommand = new SqlCommand($"Delete Cars where CarName = {data.Name}", SqlConnection);
deleteCommand.ExecuteNonQuery();
}
else
{
throw new Exception("Query is empty");
}
}
private void BtnAddSqlConnectionClick(object sender, EventArgs e)
{
try
{
ISqlData sqlData = Factory.CreateSqlData(this.txtSqlConnectionName.Text, this.txtSqlConnectionString.Text);
this.ClearInputFields();
ConfigHelper.AddConnectionString(sqlData.Name, sqlData.ConnectionString);
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
}
}
public bool RemoveData(ISqlData data)
{
try
{
SQLiteCommand command = new SQLiteCommand(data.GetRemoveCommand(), m_dbConnection);
command.ExecuteNonQuery();
}
catch (Exception e)
{
Trace.WriteLine(e);
return(false);
}
return(true);
}
public PrintPlanViewModel(ISqlData sqlData, MajorModel major)
{
_sqlData = sqlData;
_major = major;
if (major != null)
{
PrintYearOne = new BindableCollection <CourseModel>(_sqlData.GetPrintCourses(UserName, major.MajorId, 1));
PrintYearTwo = new BindableCollection <CourseModel>(_sqlData.GetPrintCourses(UserName, major.MajorId, 2));
PrintYearThree = new BindableCollection <CourseModel>(_sqlData.GetPrintCourses(UserName, major.MajorId, 3));
MajorName = _major.Name;
}
}
public SelectElectivesViewModel(ISqlData sqlData, IEventAggregator eventAggregator, MajorModel major)
{
_sqlData = sqlData;
_eventAggregator = eventAggregator;
_major = major;
if (major != null)
{
_electiveCourses = new BindableCollection <CourseModel>(_sqlData.GetAllElectiveCourses(UserName, major.MajorId));
_completedCourses = new List <CompletedCourseModel>(_sqlData.GetAllCompletedCourses(UserName));
_creditsCompleted = _sqlData.GetCreditsCompleted(UserName, major.MajorId).FirstOrDefault();
_creditsDue = 360;
MajorName = _major.Name;
}
}
public DataTable ReadData(ISqlData data)
{
SQLiteDataAdapter ad = null;
DataTable dt = new DataTable();
try
{
SQLiteCommand command = new SQLiteCommand(data.GetQueryCommand(), m_dbConnection);
ad = new SQLiteDataAdapter(command);
ad.Fill(dt); //fill the datasource
}
catch (Exception e)
{
Trace.WriteLine(e);
}
return(dt);
}
public void Insert(ISqlData data)
{
if (data != null)
{
SqlCommand insertCommand = new SqlCommand($"INSERT INTO Cars (CarName, Mark, Color, Price) VALUES (@carname, @mark, @color, @price)", SqlConnection);
SqlParameter carNameParam = new SqlParameter("@carname", data.Name);
SqlParameter carMarkParam = new SqlParameter("@mark", data.Mark);
SqlParameter carColorParam = new SqlParameter("@color", data.Color);
SqlParameter carPriceParam = new SqlParameter("@price", data.Price);
insertCommand.Parameters.AddRange(new[] { carNameParam, carMarkParam, carColorParam, carPriceParam });
insertCommand.ExecuteNonQuery();
}
else
{
throw new Exception("Query is empty");
}
}
public void Update(ISqlData data)
{
if (data != null)
{
SqlCommand updateCommand = new SqlCommand("Update Cars SET Color='Black' WHERE Color='Red'", SqlConnection);
SqlParameter carNameParam = new SqlParameter("@carname", data.Name);
SqlParameter carMarkParam = new SqlParameter("@mark", data.Mark);
SqlParameter carColorParam = new SqlParameter("@color", data.Color);
SqlParameter carPriceParam = new SqlParameter("@price", data.Price);
updateCommand.Parameters.AddRange(new[] { carNameParam, carMarkParam, carColorParam, carPriceParam });
updateCommand.ExecuteNonQuery();
}
else
{
throw new Exception("Query is empty");
}
}
public SuppliersController(ISqlData data)
{
this.data = data;
}
public UsersController(ISqlData data)
{
this.data = data;
}
public SqlHelper(ISqlData sqlData, IConverter converter)
{
_sqlData = sqlData;
_converter = converter;
}
public ReturnsController(ISqlData data)
{
this.data = data;
}
public AccountController(ISqlData data)
{
this.data = data;
}
public ProductTypeController(ISqlData data)
{
this.data = data;
}
public AdminController()
{
data = new SqlGenerator();
}
public ArchiveController(ISqlData data, Config config)
{
sql = data;
Configuration = config;
}
public CustomerController(ISqlData data)
{
this.data = data;
}
public HomeController()
{
data = new SqlGenerator();
}
public HomeController(ISqlData data)
{
this.data = data;
}
public UnitController(ISqlData data)
{
this.data = data;
}
public CheckIn(ISqlData db)
{
InitializeComponent();
_db = db;
}
public AccountController(ISqlData sql, ILogger <AccountController> logger)
{
this.sql = sql;
this.logger = logger;
}
public ActiveController(ISqlData sql, ILogger <ActiveController> logger)
{
Sql = sql;
Logger = logger;
}
public BookRoomModel(ISqlData db)
{
_db = db;
}
public ResultsModel(ISqlData db)
{
_db = db;
}
public ProductIncomsController(ISqlData data)
{
this.data = data;
}
public IndexModel(ISqlData db)
{
_db = db;
}
