private void btnMod_Click(object sender, EventArgs e)
{
DialogResult warning = new DialogResult();
warning = MessageBox.Show("Bạn có chắc chắn muốn sửa độc giả này?", "Cảnh báo!", MessageBoxButtons.YesNo);
if (warning == DialogResult.Yes)
{
int rowIndex = dgvDocGia.CurrentCell.RowIndex;
ReaderDTO rd = new ReaderDTO();
rd.IdReader = int.Parse(dgvDocGia.Rows[rowIndex].Cells[0].Value.ToString());
rd.IdReader = int.Parse(dgvDocGia.Rows[rowIndex].Cells[0].Value.ToString());
rd.NameReader = dgvDocGia.Rows[rowIndex].Cells[1].Value.ToString();
rd.DateOfBirth = DateTime.Parse(dgvDocGia.Rows[rowIndex].Cells[2].Value.ToString());
rd.AddressReader = dgvDocGia.Rows[rowIndex].Cells[3].Value.ToString();
rd.Email = dgvDocGia.Rows[rowIndex].Cells[4].Value.ToString();
rd.DateCreateReader = DateTime.Parse(dgvDocGia.Rows[rowIndex].Cells[5].Value.ToString());
rd.TypeOfReader = dgvDocGia.Rows[rowIndex].Cells[6].Value.ToString();
frmAddNewReaders frmAddNewReaders = new frmAddNewReaders();
frmAddNewReaders.edit(rd);
frmAddNewReaders.ShowDialog();
}
else
{
return;
}
LoadDataInto_DataGridViewOfreader();
}
private void btnDel_Click(object sender, EventArgs e)
{
DialogResult warning = new DialogResult();
warning = MessageBox.Show("Bạn có chắc chắn muốn xóa độc giả này?", "Cảnh báo!", MessageBoxButtons.YesNo);
if (warning == DialogResult.Yes)
{
int rowIndex = dgvDocGia.CurrentCell.RowIndex;
ReaderDTO rd = new ReaderDTO();
rd.IdReader = int.Parse(dgvDocGia.Rows[rowIndex].Cells[0].Value.ToString());
bool kq = dgBus.delete(rd);
if (kq == false)
{
MessageBox.Show("Xóa thất bại. Vui lòng kiểm tra lại dũ liệu");
}
else
{
MessageBox.Show("Xóa thành công");
}
}
else
{
return;
}
LoadDataInto_DataGridViewOfreader();
}
private void btnAdd_Click(object sender, EventArgs e)
{
Random rd = new Random();
ReaderDTO dg = new ReaderDTO();
dg.IdReader = rd.Next(1, 100);
dg.NameReader = tbName.Text;
dg.DateOfBirth = dtpDob.Value.Date;
DateTimePicker myPicker = new DateTimePicker();
myPicker.Value = DateTime.Now;
int k = myPicker.Value.Year - dtpDob.Value.Year;
if ((k > dgbus.getMaxAgeofReader()) || (k < dgbus.getMinAgeofReader()))
{
MessageBox.Show("Tuổi chưa phù hợp , vui lòng nhập lại");
}
else
{
dg.AddressReader = tbAddress.Text;
dg.Email = tbEmail.Text;
dg.TypeOfReader = cbTypeofReaders.GetItemText(cbTypeofReaders.SelectedItem);
dg.DateCreateReader = dtpDateCreateCard.Value.Date;
bool kq = dgbus.add(dg);
if (kq == false)
{
MessageBox.Show("Thêm thất bại. Vui lòng kiểm tra lại dũ liệu");
}
else
{
MessageBox.Show("Thêm thành công");
}
}
}
private void btnBorrow_Click(object sender, EventArgs e)
{
QLTVDTO.borrowbook borrowDTO = new QLTVDTO.borrowbook();
bookDTO book = new bookDTO();
ReaderDTO reader = new ReaderDTO();
book.MaSach = tbBookCode.Text;
reader.IdReader = int.Parse(tbReaderCode.Text);
string temp1 = tbReaderCode.Text;
borrowDTO.NgayTraSachThuc = dtpReturnBookDate.Value;
borrowDTO.Idborrowbook = tbReturnBook.Text;
//add into db
bool result = returnBUS.Tra(borrowDTO, book, reader);
if (result == true)
{
MessageBox.Show("Trả thành công");
}
else
{
MessageBox.Show("Trả sách thất bại");
}
}
public bool delete(ReaderDTO dg)
{
string query = string.Empty;
query += "DELETE FROM THEDOCGIA WHERE [MaThe] = @MaThe";
using (SqlConnection con = new SqlConnection(@"server=" + Dns.GetHostName() + ";Trusted_Connection=yes;database=LIBMANAGEMENT;")) //Init connection to host
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@MaThe", dg.IdReader);
try
{
con.Open();
cmd.ExecuteNonQuery();
con.Close();
con.Dispose();
}
catch (Exception ex)
{
con.Close();
return(false);
}
}
}
return(true);
}
public string SaveReader(ReaderModels readerModel)
{
ReaderDTO reader = new ReaderDTO();
MessageDTO message = new MessageDTO();
reader.Company = new CompanyDTO {
CompanyId = Convert.ToInt32(readerModel.CompanyId)
};
reader.User = new UserDTO {
UserId = Convert.ToInt32(readerModel.UserId)
};
reader.ReaderId = Convert.ToInt32(readerModel.Id);
reader.ReaderName = readerModel.ReaderDescription;
reader.ReaderSerialNumber = readerModel.ReaderSerialNumber;
reader.ReaderStatus = readerModel.ReaderStatus;
reader.ReaderStatusComm = readerModel.ReaderStatusComm;
if (String.Compare(readerModel.Operation, "add", StringComparison.Ordinal) == 0)
{
message = business.SaveReader(reader, "I");
}
else if (String.Compare(readerModel.Operation, "edit", StringComparison.Ordinal) == 0)
{
message = business.SaveReader(reader, "U");
}
JavaScriptSerializer oSerializer = new JavaScriptSerializer();
string sJSON = oSerializer.Serialize(message);
return(sJSON);
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (gvReaders.SelectedRows.Count > 0)
{
ReaderDTO reader = new ReaderDTO();
reader.MaNV = (string)gvReaders.SelectedRows[0].Cells["madocgia"].Value;
reader.HoTen = (string)gvReaders.SelectedRows[0].Cells["hoten"].Value;
reader.DiaChi = (string)gvReaders.SelectedRows[0].Cells["diachi"].Value;
reader.DOB = (DateTime)gvReaders.SelectedRows[0].Cells["dob"].Value;
reader.SDT = (string)gvReaders.SelectedRows[0].Cells["sdt"].Value;
reader.CMND = (string)gvReaders.SelectedRows[0].Cells["cmnd"].Value;
reader.Email = (string)gvReaders.SelectedRows[0].Cells["email"].Value;
reader.NLT = (DateTime)gvReaders.SelectedRows[0].Cells["ngaylapthe"].Value;
reader.NVLapThe = (string)gvReaders.SelectedRows[0].Cells["nvlapthe"].Value;
reader.UserName = (string)gvReaders.SelectedRows[0].Cells["username"].Value;
reader.Password = (string)gvReaders.SelectedRows[0].Cells["password"].Value;
var updateFrm = new AddReaderForm();
updateFrm.librabrianid = librarianid;
updateFrm.update = true;
updateFrm.reader = reader;
updateFrm.UpdateReader += UpdateFrm_UpdateReader;
updateFrm.ShowDialog();
}
else
{
MessageBox.Show("[!] Select a row to update\n" +
"[*] No rows has been selected yet or," +
"[*] you selected a cell only");
}
}
public void TestReaderDTOs()
{
ReaderDTO dto = serv.GetReader(2);
Assert.AreEqual(serv.GetReader(2).name, dto.name);
Assert.AreEqual(serv.GetReader(2).surname, dto.surname);
Assert.AreEqual(serv.GetReader(2).ID, dto.ID);
}
public void TestIfDTOandJustReaderAreTheSame()
{
ReaderDTO dto = serv.GetReader(2);
Assert.AreEqual(serv.FindReaderByID(2).reader_firstName, dto.name);
Assert.AreEqual(serv.FindReaderByID(2).reader_surname, dto.surname);
Assert.AreEqual(serv.FindReaderByID(2).reader_ID, dto.ID);
}
public async void CreateReader(ReaderDTO readerDTO)
{
var jsonString = JsonSerializer.Serialize(readerDTO);
var httpContent = new StringContent(jsonString, Encoding.UTF8, "application/json");
using var response = await httpClient.PutAsync("https://localhost:44333/Lib/CreateReader", httpContent);
response.EnsureSuccessStatusCode();
}
public void CreateReader(ReaderDTO readerDTO)
{
var mapper = new MapperConfiguration(cfg => cfg.CreateMap <ReaderDTO, Reader>()).CreateMapper();
Reader reader = mapper.Map <Reader>(readerDTO);
reader.Id = readerIdCounter;
readerIdCounter++;
Database.Readers.Create(reader);
Database.Save();
}
/// <summary>
///
/// </summary>
/// <param name="whereClause"></param>
/// <param name="dataTable"></param>
/// <returns></returns>
public List <ReaderDTO> GetReadersByEmployee(Dictionary <string, string> whereClause, ref DataTable dataTable)
{
DataSet dataSet = new DataSet();
IUniversalConnector connector = new UniversalConnectorImpl(ServerEnumType.SqlServer, connectionString);
var readers = new List <ReaderDTO>();
int companyId = Convert.ToInt32(whereClause["companyId"]);
int scheduleId = Convert.ToInt32(whereClause["scheduleId"]);
int employeeId = Convert.ToInt32(whereClause["employeeId"]);
int pageSize = Convert.ToInt32(whereClause["pageSize"]);
int pageNumber = Convert.ToInt32(whereClause["pageNumber"]);
string sortColumn = whereClause["sortColumn"].ToString();
string sortOrder = whereClause["sortOrder"].ToString();
try
{
//Todos los registros
object[] parameters = new object[] { companyId, employeeId, scheduleId, pageSize, pageNumber, sortColumn, sortOrder };
connector.FillDataSet(dataSet, CommandType.StoredProcedure, "GetReadersByEmployee", parameters);
if (dataSet.Tables[1].Rows.Count > 0)
{
dataTable = dataSet.Tables[0];
foreach (DataRow row in dataSet.Tables[1].Rows)
{
ReaderDTO reader = new ReaderDTO
{
Company = new CompanyDTO {
CompanyId = Convert.ToInt32(row["COMPANY_ID"])
},
ReaderId = Convert.ToInt32(row["READER_ID"]),
ReaderName = row["READER_NAME"].ToString(),
ReaderSerialNumber = row["READER_SERIAL_NUMBER"].ToString(),
ReaderStatus = row["READER_STATUS"].ToString(),
ReaderStatusComm = row["READER_STATUS_COMM"].ToString(),
ReaderType = row["READER_TYPE"].ToString()
};
readers.Add(reader);
}
}
else
{
readers = null;
}
}
catch (Exception exception)
{
readers = null;
}
finally
{
connector.Dispose();
}
return(readers);
}
public bool Return(borrowbook SachMuon, bookDTO book, ReaderDTO reader)
{
string query2 = string.Empty;
query2 += "IF NOT EXISTS(SELECT TOP 1 MaThe FROM THEDOCGIA WHERE MaThe= @MaThe) " + Environment.NewLine;
query2 += "INSERT INTO MUONSACH (MaThe, MaSach) " + Environment.NewLine;
query2 += "VALUES (@MaThe, @MaSach) ";
query2 += "else " + Environment.NewLine;
query2 += "begin " + Environment.NewLine;
query2 += "DECLARE @dk INT " + Environment.NewLine;
query2 += "DECLARE cursorProduct CURSOR FOR " + Environment.NewLine;
query2 += "select DaMuon from SACH where MaSach = @MaSach " + Environment.NewLine;
query2 += "Open cursorProduct FETCH NEXT FROM cursorProduct INTO @dk " + Environment.NewLine;
query2 += "if @dk = 1 " + Environment.NewLine;
query2 += "begin" + Environment.NewLine;
query2 += "update SACH set DaMuon = 0 where MaSach = @MaSach " + Environment.NewLine;
query2 += "UPDATE MUONSACH SET ";
query2 += "NgayTraThucTe = @NgayTraThucTe ";
query2 += "WHERE MaThe=@MaThe and MaSach = @MaSach " + Environment.NewLine;
query2 += "end " + Environment.NewLine;
query2 += "else " + Environment.NewLine;
query2 += "INSERT INTO MUONSACH (MaThe, MaSach, NgayTraThucTe,MaMuonSach) " + Environment.NewLine;
query2 += "VALUES (@MaThe, @MaSach, @NgayTraThucTe,@MaMuonSach) ";
query2 += "end " + Environment.NewLine;
using (SqlConnection con = new SqlConnection(@"server=" + Dns.GetHostName() + ";Trusted_Connection=yes;database=LIBMANAGEMENT;")) //Init connection to host
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query2;
cmd.Parameters.AddWithValue("@MaSach", book.MaSach);
cmd.Parameters.AddWithValue("@MaThe", reader.IdReader);
cmd.Parameters.AddWithValue("@MaMuonSach", SachMuon.Idborrowbook);
cmd.Parameters.AddWithValue("@NgayTraThucTe", SachMuon.NgayTraSachThuc);
try
{
con.Open();
cmd.ExecuteNonQuery();
con.Close();
con.Dispose();
}
catch (Exception ex)
{
con.Close();
return(false);
}
}
}
return(true);
}
public void edit(ReaderDTO dg)
{
tbName.Text = dg.NameReader;
idreaderedit = dg.IdReader;
dtpDob.Value = dg.DateOfBirth.Date;
tbAddress.Text = dg.AddressReader;
tbEmail.Text = dg.Email;
dtpDateCreateCard.Value = dg.DateCreateReader.Date;
cbTypeofReaders.Text = dg.TypeOfReader;
btnAdd.Visible = false;
btnEdit.Visible = true;
}
public IActionResult GetReader(int?readerId)
{
try
{
ReaderDTO reader = service.GetReader(readerId).Result;
return(View("~/Views/GetReader.cshtml", reader));
}
catch (Exception ex)
{
return(Content(ex.Message));
}
}
public IActionResult UpdateReader([FromBody] JObject data)
{
try
{
ReaderDTO reader = data.ToObject <ReaderDTO>();
this._readerRepository.Update(reader);
return(NoContent());
}
catch (Exception ex)
{
return(StatusCode(500, "Internal Server Error message: " + ex.Message));
}
}
public List <ReaderDTO> select()
{
string query = string.Empty;
query += "SELECT * ";
query += "FROM THEDOCGIA";
List <ReaderDTO> lsreader = new List <ReaderDTO>();
using (SqlConnection con = new SqlConnection(@"server=" + Dns.GetHostName() + ";Trusted_Connection=yes;database=LIBMANAGEMENT;")) //Init connection to host
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
try
{
con.Open();
SqlDataReader reader = null;
reader = cmd.ExecuteReader();
if (reader.HasRows == true)
{
while (reader.Read())
{
ReaderDTO rd = new ReaderDTO();
rd.IdReader = int.Parse(reader["MaThe"].ToString());
rd.NameReader = reader["HoTen"].ToString();
rd.DateOfBirth = reader.GetFieldValue <DateTime>(reader.GetOrdinal("NgaySinh"));
rd.AddressReader = reader["DiaChi"].ToString();
rd.Email = reader["Email"].ToString();
rd.DateCreateReader = reader.GetFieldValue <DateTime>(reader.GetOrdinal("NgayLapThe"));
rd.TypeOfReader = reader["LoaiDocGia"].ToString();
lsreader.Add(rd);
}
}
con.Close();
con.Dispose();
}
catch (Exception ex)
{
con.Close();
return(null);
}
}
}
return(lsreader);
}
private void btnAdd_Click(object sender, EventArgs e)
{
ReaderDTO reader = GetReaderInfo();
if (AddReader != null)
{
AddReader(reader);
}
if (UpdateReader != null)
{
UpdateReader(reader);
}
this.Close();
}
private ReaderDTO GetReaderInfo()
{
ReaderDTO reader = new ReaderDTO();
reader.MaNV = txtReaderID.Text;
reader.HoTen = txtName.Text;
reader.DiaChi = txtAdrr.Text;
reader.SDT = txtPhone.Text;
reader.DOB = pkrDOB.Value;
reader.Email = txtEmail.Text;
reader.CMND = txtPassport.Text;
reader.NLT = DateTime.Now;
reader.NVLapThe = librabrianid;
reader.UserName = txtUsername.Text;
reader.Password = txtPassword.Text;
return(reader);
}
public IActionResult CreateReader(String name, String surname)
{
try
{
ReaderDTO rDTO = new ReaderDTO
{
Name = name,
Surname = surname,
};
service.CreateReader(rDTO);
return(Content("Читатель добавлен"));
}
catch (Exception ex)
{
return(Content(ex.Message));
}
}
//string connectionString = ConfigurationManager.ConnectionStrings["ConnectionTA"].ToString();
#endregion
#region Reader
/// <summary>
///
/// </summary>
/// <param name="employee"></param>
/// <param name="operation"></param>
/// <returns></returns>
public MessageDTO SaveReader(ReaderDTO reader, string operation)
{
DataTable dataTable = new DataTable();
IUniversalConnector connector = new UniversalConnectorImpl(ServerEnumType.SqlServer, connectionString);
MessageDTO message = new MessageDTO();
try
{
connector.BeginTransaction();
//Todos los registros
object[] parameters = new object[] { reader.Company.CompanyId, reader.ReaderId, reader.User.UserId.ToString(),
reader.ReaderSerialNumber, reader.ReaderName, reader.ReaderType,
reader.ReaderStatusComm, reader.ReaderStatus, operation };
//connector.ExecuteNonQuery(CommandType.StoredProcedure, "SaveReader", parameters);
dataTable = connector.ExecuteDataTable(CommandType.StoredProcedure, "SaveReader", parameters);
foreach (DataRow row in dataTable.Rows)
{
message.ErrorCode = row["ERROR_NUMBER"].ToString();
message.ErrorMessage = row["ERROR_DESCRIPTION"].ToString();
}
if (message.ErrorCode == "0")
{
connector.Commit();
}
else
{
connector.RollBack();
}
}
catch (Exception exception)
{
message.ErrorCode = "-1";
message.ErrorMessage = exception.ToString();
connector.RollBack();
}
finally
{
connector.Dispose();
}
return(message);
}
public int SoluongSachDangMuon(ReaderDTO rd)
{
string query = string.Empty;
query += "SELECT COUNT (MUONSACH.MaSach) AS SOSACHMUON ";
query += "FROM MUONSACH INNER JOIN THEDOCGIA ON MUONSACH.MaThe = THEDOCGIA.MaThe ";
query += "where THEDOCGIA.MaThe = @MaThe ";
int res = 0;
using (SqlConnection con = new SqlConnection(@"server=" + Dns.GetHostName() + ";Trusted_Connection=yes;database=LIBMANAGEMENT;")) //Init connection to host
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@MaThe", rd.IdReader);
try
{
con.Open();
SqlDataReader reader = null;
reader = cmd.ExecuteReader();
if (reader.HasRows == true)
{
while (reader.Read())
{
res = int.Parse(reader["SOSACHMUON"].ToString());
}
}
con.Close();
con.Dispose();
}
catch (Exception ex)
{
con.Close();
return(0);
}
}
}
return(res);
}
public bool edit(ReaderDTO rd)
{
string query = string.Empty;
query += "UPDATE THEDOCGIA ";
query += "SET HoTen = @HoTen,NgaySinh = @NgaySinh,DiaChi = @DiaChi,Email = @Email,NgayLapThe = @NgayLapThe,LoaiDocGia = @LoaiDocGia ";
query += "WHERE MaThe = @MaThe";
using (SqlConnection con = new SqlConnection(@"server=" + Dns.GetHostName() + ";Trusted_Connection=yes;database=LIBMANAGEMENT;")) //Init connection to host
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@MaThe", rd.IdReader);
cmd.Parameters.AddWithValue("@HoTen", rd.NameReader);
cmd.Parameters.AddWithValue("@NgaySinh", rd.DateOfBirth);
cmd.Parameters.AddWithValue("@DiaChi", rd.AddressReader);
cmd.Parameters.AddWithValue("@Email", rd.Email);
cmd.Parameters.AddWithValue("@NgayLapThe", rd.DateCreateReader);
cmd.Parameters.AddWithValue("@LoaiDocGia", rd.TypeOfReader);
try
{
con.Open();
cmd.ExecuteNonQuery();
con.Close();
con.Dispose();
}
catch (Exception ex)
{
con.Close();
return(false);
}
}
}
return(true);
}
private void btnEdit_Click(object sender, EventArgs e)
{
ReaderDTO dg = new ReaderDTO();
dg.IdReader = idreaderedit;
dg.NameReader = tbName.Text;
dg.DateOfBirth = dtpDob.Value.Date;
dg.AddressReader = tbAddress.Text;
dg.Email = tbEmail.Text;
dg.TypeOfReader = cbTypeofReaders.GetItemText(cbTypeofReaders.SelectedItem);
dg.DateCreateReader = dtpDateCreateCard.Value.Date;
bool kq = dgbus.edit(dg);
if (kq == false)
{
MessageBox.Show("Sửa thất bại. Vui lòng kiểm tra lại dũ liệu");
}
else
{
MessageBox.Show("Sửa thành công");
}
}
private void btnBorrow_Click(object sender, EventArgs e)
{
QLTVDTO.borrowbook borrowDTO = new QLTVDTO.borrowbook();
bookDTO book = new bookDTO();
ReaderDTO reader = new ReaderDTO();
DateTimePicker myPicker = new DateTimePicker();
myPicker.Value = DateTime.Now;
int k = myPicker.Value.Month - reader.DateCreateReader.Month;
int SoSachMuon = ReaderBUS.SoSachMuon(reader);
int SoSachMax = ReaderBUS.getMaxofBorrowBook();
reader.IdReader = int.Parse(tbReaderCode.Text);
string temp = tbReaderCode.Text;
if ((k > ReaderBUS.getTimeofReader()) && (SoSachMuon > SoSachMax))
{
MessageBox.Show("Đã Hết hạn mượn Thẻ ");
}
else
{
book.MaSach = tbBookCode.Text;
borrowDTO.NgayMuonSach = DateBorrowdtp.Value;
borrowDTO.Idborrowbook = tbIdBorrowBook.Text;
borrowDTO.NgayTraSach = DateBorrowdtp.Value.AddDays(borrowBUS.SoNgayMuonToiDa());
//add into db
bool result = borrowBUS.add(borrowDTO, book, reader);
if (result == true)
{
MessageBox.Show("Mượn thành công");
}
else
{
MessageBox.Show("Mượn thất bại");
}
}
}
public bool add(ReaderDTO rd)
{
string query = string.Empty;
query += "INSERT INTO [THEDOCGIA] ([MaThe], [HoTen], [NgaySinh], [DiaChi], [Email], [NgayLapThe], [LoaiDocGia])";
query += "VALUES (@MaThe,@HoTen,@NgaySinh,@DiaChi,@Email,@NgayLapThe,@LoaiDocGia)";
using (SqlConnection con = new SqlConnection(@"server=" + Dns.GetHostName() + ";Trusted_Connection=yes;database=LIBMANAGEMENT;")) //Init connection to host
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@MaThe", rd.IdReader);
cmd.Parameters.AddWithValue("@HoTen", rd.NameReader);
cmd.Parameters.AddWithValue("@NgaySinh", rd.DateOfBirth);
cmd.Parameters.AddWithValue("@DiaChi", rd.AddressReader);
cmd.Parameters.AddWithValue("@Email", rd.Email);
cmd.Parameters.AddWithValue("@NgayLapThe", rd.DateCreateReader);
cmd.Parameters.AddWithValue("@LoaiDocGia", rd.TypeOfReader);
try
{
con.Open();
cmd.ExecuteNonQuery();
con.Close();
con.Dispose();
}
catch (Exception ex)
{
con.Close();
return(false);
}
}
}
return(true);
}
public void Update(ReaderDTO reader)
{
string sqlQuery = "UPDATE Reader SET Reading = @NewReading, Date = @Date WHERE ReaderNumber = @ReaderNumber";
try
{
conn.Open();
cmd = new MySqlCommand(sqlQuery, conn);
DateTime dt = DateTime.Now;
string formatForMySql = dt.ToString("yyyy-MM-dd");
cmd.Parameters.AddWithValue("@NewReading", reader.Reading);
cmd.Parameters.AddWithValue("@ReaderNumber", reader.ReaderNumber);
cmd.Parameters.AddWithValue("@Date", formatForMySql);
cmd.ExecuteNonQuery();
}
catch (MySqlException ex)
{
throw ex;
}
finally
{
conn.Close();
}
}
public string DeleteReader(int readerId, int companyId, int userId)
{
ReaderDTO reader = new ReaderDTO();
MessageDTO message = new MessageDTO();
reader.Company = new CompanyDTO {
CompanyId = companyId
};
reader.User = new UserDTO {
UserId = userId
};
reader.ReaderId = readerId;
reader.ReaderName = "";
reader.ReaderSerialNumber = "";
reader.ReaderStatus = "";
reader.ReaderStatusComm = "";
message = business.SaveReader(reader, "D");
JavaScriptSerializer oSerializer = new JavaScriptSerializer();
string sJSON = oSerializer.Serialize(message);
return(sJSON);
}
public int SoSachMuon(ReaderDTO dg)
{
int re = dgDal.SoluongSachDangMuon(dg);
return(re);
}
public bool edit(ReaderDTO dg)
{
bool re = dgDal.edit(dg);
return(re);
}
