public bool Add(DtoReader dtoReader)
{
using (SqlConnection sqlConnection = data.GetConnect()) {
try {
sqlConnection.Open();
string sql = @"INSERT INTO READER VALUES(@ReaderID, @ReaderName, @Gender, @DateOfBirth, @Phone, @Address, @CardID, @Status, @Avatar)";
SqlCommand cmd = new SqlCommand(sql, sqlConnection);
cmd.Parameters.Add("@ReaderID", SqlDbType.NChar).Value = dtoReader.ReaderID;
cmd.Parameters.Add("@ReaderName", SqlDbType.NVarChar).Value = dtoReader.ReaderName;
cmd.Parameters.Add("@Gender", SqlDbType.NVarChar).Value = dtoReader.Gender;
cmd.Parameters.Add("@DateOfBirth", SqlDbType.Date).Value = dtoReader.DateOfBirth;
cmd.Parameters.Add("@Phone", SqlDbType.NVarChar).Value = dtoReader.Phone;
cmd.Parameters.Add("@Address", SqlDbType.NVarChar).Value = dtoReader.Address;
cmd.Parameters.Add("@CardID", SqlDbType.NChar).Value = dtoReader.CardID;
cmd.Parameters.Add("@Status", SqlDbType.NVarChar).Value = StringHelper.ActionStatus.Active.Key;
if (dtoReader.Avatar == null)
{
cmd.Parameters.Add("@Avatar", SqlDbType.Image).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add("@Avatar", SqlDbType.Image).Value = dtoReader.Avatar;
}
cmd.ExecuteNonQuery();
}
catch {
return(false);
}
}
return(true);
}
public bool Update(DtoReader dtoReader)
{
using (SqlConnection sqlConnection = data.GetConnect()) {
try {
sqlConnection.Open();
string sql = @"UPDATE READER SET ReaderName = @ReaderName, Gender = @Gender, DateOfBirth = @DateOfBirth, Phone = @Phone, Address = @Address, CardID = @CardID, Status = @Status, Avatar = @Avatar WHERE ReaderID = @ReaderID";
SqlCommand cmd = new SqlCommand(sql, sqlConnection);
cmd.Parameters.Add("@ReaderID", SqlDbType.NChar).Value = dtoReader.ReaderID;
cmd.Parameters.Add("@ReaderName", SqlDbType.NVarChar).Value = dtoReader.ReaderName;
cmd.Parameters.Add("@Gender", SqlDbType.NVarChar).Value = dtoReader.Gender;
cmd.Parameters.Add("@DateOfBirth", SqlDbType.Date).Value = dtoReader.DateOfBirth;
cmd.Parameters.Add("@Phone", SqlDbType.NVarChar).Value = dtoReader.Phone;
cmd.Parameters.Add("@Address", SqlDbType.NVarChar).Value = dtoReader.Address;
cmd.Parameters.Add("@CardID", SqlDbType.NChar).Value = dtoReader.CardID;
cmd.Parameters.Add("@Status", SqlDbType.NVarChar).Value = dtoReader.Status;
if (dtoReader.Avatar == null)
{
cmd.Parameters.Add("@Avatar", SqlDbType.Image).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add("@Avatar", SqlDbType.Image).Value = dtoReader.Avatar;
}
cmd.ExecuteNonQuery();
}
catch {
return(false);
}
}
return(true);
}
private void DgwReaderInfo_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (dgwReaderInfo.Rows.Count.Equals(0))
{
return;
}
// reader
string readerID = dgwReaderInfo.CurrentRow.Cells["ReaderID"].Value.ToString();
dtoReader = bllReader.GetByID(readerID);
txtReaderID.Text = dtoReader.ReaderID;
txtDateOfBirth.Text = dtoReader.DateOfBirth.ToString("dd/MM/yyyy");
txtAddress.Text = dtoReader.Address;
txtEnable.Text = StringHelper.ActionStatus.GetByKey(dtoReader.Status).Display;
txtReaderName.Text = dtoReader.ReaderName;
txtGender.Text = StringHelper.Gender.GetByKey(dtoReader.Gender).Display;
txtPhone.Text = dtoReader.Phone;
// card
string cardID = dgwReaderInfo.CurrentRow.Cells["CardID"].Value.ToString();
dtoCard = bllCard.GetByID(cardID);
txtCardID.Text = dtoCard.CardID;
txtIssueDate.Text = dtoCard.IssueDate.ToString("dd/MM/yyyy");
txtExpiration.Text = dtoCard.Expiration.ToString("dd/MM/yyyy");
txtNotes.Text = dtoCard.Notes;
//
btnUpdateReader.Enabled = true;
LoadImage();
}
private void DgwReaderList_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (dgwReaderList.Rows.Count.Equals(0))
{
return;
}
//reader
string ReaderID = dgwReaderList.CurrentRow.Cells["ReaderID"].Value.ToString();
dtoReader = bllReader.GetByID(ReaderID);
txtReaderName.Text = dtoReader.ReaderName;
txtGender.Text = StringHelper.Gender.GetByKey(dtoReader.Gender).Display;
txtPhone.Text = dtoReader.Phone;
//card
string CardID = dgwReaderList.CurrentRow.Cells["CardID"].Value.ToString();
dtoCard = bllCard.GetByID(CardID);
txtCardID.Text = dtoCard.CardID;
txtCardIssueDate.Text = dtoCard.IssueDate.ToString("dd / MM / yyyy");
txtCardExpiration.Text = dtoCard.Expiration.ToString("dd / MM / yyyy");
txtCardNotes.Text = dtoCard.Notes;
//
LoadDGWIssueBook();
LoadDGWHistoryReturn();
txtNoBookIssue.Text = dgwIssueBook.Rows.Count.ToString();
//
btnLending.Enabled = true;
foreach (TextBox textBox in gboIssueInfo.Controls.OfType <TextBox>())
{
textBox.ResetText();
}
btnLost.Enabled = false;
btnReturn.Enabled = false;
btnReturnDetails.Enabled = false;
GetImage();
}
public Update(DtoReader dtoReader, DtoCard dtoCard)
{
InitializeComponent();
this.dtoReader = dtoReader;
this.dtoCard = dtoCard;
}
public bool Update(DtoReader dtoReader)
{
return(dalReader.Update(dtoReader));
}
public bool Add(DtoReader dtoReader)
{
return(dalReader.Add(dtoReader));
}
