//edit
public bool UpdateData(SaleRecordModel newData)
{
SaleRecordDBModel datas = new SaleRecordDBModel();
datas.GetConnectionString(connection.server(),
connection.database(), connection.username(), connection.password());
return(datas.GetUpdateValue(newData));
}
public bool DeleteValue(SaleRecordModel deletData)
{
SaleRecordDBModel datas = new SaleRecordDBModel();
datas.GetConnectionString(connection.server(),
connection.database(), connection.username(), connection.password()); //1
return(datas.GetDeleteData(deletData));
}
public SaleRecordModel GetValueByID(string id)
{
SaleRecordDBModel datas = new SaleRecordDBModel();
datas.GetConnectionString(connection.server(),
connection.database(), connection.username(), connection.password()); //1
return(datas.GetSaleRecordByID(id));
}
public List <SaleRecordModel> GetALlSaleRecordByMonthAndYear(monthInYear choosing, int year)
{
SaleRecordDBModel datas = new SaleRecordDBModel();
datas.GetConnectionString(connection.server(),
connection.database(), connection.username(), connection.password()); //1
return(datas.GetSaleByMonthInYear(choosing, year));
}
public List <SaleRecordModel> GetAllSaleRecord()
{
SaleRecordDBModel datas = new SaleRecordDBModel();
datas.GetConnectionString(connection.server(),
connection.database(), connection.username(), connection.password()); //1
return(datas.GetALLSaleRecord());
}
//it basically to send the request to Model, then model will get all value that controller ask about
// weekly
public List <SaleRecordModel> GetAllSaleRecordByWeekAndYear(int week, int year)
{
//we have to make the connection between controller and model first
SaleRecordDBModel datas = new SaleRecordDBModel();
//then we can make the connection of Model to database
datas.GetConnectionString(connection.server(),
connection.database(), connection.username(), connection.password()); //1
//get the response from Model about the week in year
return(datas.GetSaleByWeekInYear(week, year));
}
