private void updateTicketMonth()
{
TicketMonthDTO ticketMonthDTO = new TicketMonthDTO();
ticketMonthDTO.Identify = Convert.ToInt32(tbTicketMonthIdentifyEdit.Text);
ticketMonthDTO.ProcessDate = DateTime.Now;
ticketMonthDTO.Digit = tbTicketMonthDigitEdit.Text;
ticketMonthDTO.CustomerName = tbTicketMonthCustomerNameEdit.Text;
ticketMonthDTO.Cmnd = tbTicketMonthCMNDEdit.Text;
ticketMonthDTO.Company = tbTicketMonthCompanyEdit.Text;
ticketMonthDTO.Email = tbTicketMonthEmailEdit.Text;
ticketMonthDTO.Address = tbTicketMonthAddressEdit.Text;
ticketMonthDTO.CarKind = tbTicketMonthCarKindEdit.Text;
DataRow dataRow = ((DataRowView)cbTicketMonthPartEdit.SelectedItem).Row;
ticketMonthDTO.IdPart = Convert.ToString(dataRow["PartID"]);
ticketMonthDTO.RegistrationDate = dateTimePickerTicketMonthRegistrationDateEdit.Value;
ticketMonthDTO.ExpirationDate = dateTimePickerTicketMonthExpirationDateEdit.Value;
ticketMonthDTO.ChargesAmount = tbTicketMonthChargesAmountEdit.Text;
ticketMonthDTO.Status = 0;
ticketMonthDTO.DayUnlimit = DateTime.Now;
TicketMonthDAO.Update(ticketMonthDTO);
loadTicketMonthData();
}
private void addTicketMonth()
{
TicketMonthDTO ticketMonthDTO = new TicketMonthDTO();
ticketMonthDTO.Id = tbTicketMonthIDCreate.Text;
ticketMonthDTO.ProcessDate = DateTime.Now;
ticketMonthDTO.Digit = tbTicketMonthDigitCreate.Text;
ticketMonthDTO.CustomerName = tbTicketMonthCustomerNameCreate.Text;
ticketMonthDTO.Cmnd = tbTicketMonthCMNDCreate.Text;
ticketMonthDTO.Company = tbTicketMonthCompanyCreate.Text;
ticketMonthDTO.Email = tbTicketMonthEmailCreate.Text;
ticketMonthDTO.Address = tbTicketMonthAddressCreate.Text;
ticketMonthDTO.CarKind = tbTicketMonthCarKindCreate.Text;
DataRow dataRow = ((DataRowView)cbTicketMonthPartCreate.SelectedItem).Row;
ticketMonthDTO.IdPart = Convert.ToString(dataRow["PartID"]);
ticketMonthDTO.RegistrationDate = dateTimePickerTicketMonthRegistrationDateCreate.Value;
ticketMonthDTO.ExpirationDate = dateTimePickerTicketMonthExpirationDateCreate.Value;
ticketMonthDTO.ChargesAmount = tbTicketMonthChargesAmountCreate.Text;
ticketMonthDTO.Status = 0;
ticketMonthDTO.DayUnlimit = DateTime.Now;
TicketMonthDAO.Insert(ticketMonthDTO);
loadTicketMonthData();
}
public static void Update(TicketMonthDTO ticketMonthDTO)
{
string sql = "update [TicketMonth] set ProcessDate ='" + ticketMonthDTO.ProcessDate + "', Digit ='" + ticketMonthDTO.Digit + "', CustomerName ='"
+ ticketMonthDTO.CustomerName + "', CMND ='" + ticketMonthDTO.Cmnd + "', Company ='" + ticketMonthDTO.Company + "', Email ='" + ticketMonthDTO.Email + "', Address ='" + ticketMonthDTO.Address + "', CarKind ='"
+ ticketMonthDTO.CarKind + "', RegistrationDate ='" + ticketMonthDTO.RegistrationDate + "', ExpirationDate ='" + ticketMonthDTO.ExpirationDate + "', IdPart ='" + ticketMonthDTO.IdPart + "', ChargesAmount ='" + ticketMonthDTO.ChargesAmount + "' where Identify =" + ticketMonthDTO.Identify;
Database.ExcuNonQuery(sql);
}
public static void Insert(TicketMonthDTO ticketMonthDTO)
{
string sql = "insert into TicketMonth(ID, ProcessDate, Digit, CustomerName, CMND, Company, Email, Address, CarKind, RegistrationDate, ExpirationDate" +
", ChargesAmount, IDPart) values ('" + ticketMonthDTO.Id + "', '" + ticketMonthDTO.ProcessDate + "', '" + ticketMonthDTO.Digit + "', '" +
ticketMonthDTO.CustomerName + "', '" + ticketMonthDTO.Cmnd + "', '" + ticketMonthDTO.Company + "', '" + ticketMonthDTO.Email + "', '" +
ticketMonthDTO.Address + "', '" + ticketMonthDTO.CarKind + "', '" + ticketMonthDTO.RegistrationDate + "', '" + ticketMonthDTO.ExpirationDate +
"', '" + ticketMonthDTO.ChargesAmount + "', '" + ticketMonthDTO.IdPart + "')";
Database.ExcuNonQuery(sql);
}
public static DataTable searchTicketMonthData(CarDTO carDTO, TicketMonthDTO ticketMonthDTO)
{
string sql = sqlGetAllTicketMonthData + sqlQueryTicketMonth;
sql += " and Car.TimeStart >= #" + carDTO.TimeStart + "# and Car.TimeEnd <= #" + carDTO.TimeEnd + "#";
if (!string.IsNullOrEmpty(ticketMonthDTO.CustomerName))
{
sql += " and TicketMonth.CustomerName like '%" + ticketMonthDTO.CustomerName + "%'";
}
if (!string.IsNullOrEmpty(ticketMonthDTO.Company))
{
sql += " and TicketMonth.Company like '%" + ticketMonthDTO.Company + "%'";
}
sql += sqlOrderByIdentify;
DataTable data = Database.ExcuQuery(sql);
return(data);
}
private void searchCarTicketMonth()
{
CarDTO carDTO = new CarDTO();
DateTime startDate = dateTimePickerCarTicketMonthDateIn.Value;
DateTime startTime = dateTimePickerCarTicketMonthTimeIn.Value;
startDate = new DateTime(startDate.Year, startDate.Month, startDate.Day, startTime.Hour, startTime.Minute, 0);
carDTO.TimeStart = startDate;
DateTime endDate = dateTimePickerCarTicketMonthDateOut.Value;
DateTime endTime = dateTimePickerCarTicketMonthTimeOut.Value;
endDate = new DateTime(endDate.Year, endDate.Month, endDate.Day, endTime.Hour, endTime.Minute, 0);
carDTO.TimeEnd = endDate;
TicketMonthDTO ticketMonthDTO = new TicketMonthDTO();
ticketMonthDTO.CustomerName = tbCustomerName.Text;
ticketMonthDTO.Company = tbCompany.Text;
DataTable data = CarDAO.searchTicketMonthData(carDTO, ticketMonthDTO);
dgvCarTicketMonthList.DataSource = data;
}
