public static EBorrowedBooks GetIdOnly(int borrowedBookID)
{
SqlCommand cmd = new SqlCommand("spBorrowedBooks_GetIdOnly", Baglanti.conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BorrowedBookID", borrowedBookID);
Baglanti.conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
EBorrowedBooks b = new EBorrowedBooks();
while (dr.Read())
{
b.Employee = new EEmployees();
b.Member = new EMembers();
b.Book = new EBooks();
b.ID = Convert.ToInt32(dr["ID"]);
b.Employee.ID = Convert.ToInt32(dr["EmployeeID"]);
b.Member.ID = Convert.ToInt32(dr["MemberID"]);
b.DateOfBorrow = Convert.ToDateTime(dr["DateOfBorrow"]);
b.ExpireDate = Convert.ToDateTime(dr["ExpireDate"]);
b.Book.ID = Convert.ToInt32(dr["BookID"]);
}
dr.Close();
Baglanti.conn.Close();
return(b);
}
private void btnTeslimAl_Click(object sender, EventArgs e)
{
EBorrowedBooks returnBook = new EBorrowedBooks();
returnBook = (EBorrowedBooks)dataGridView1.SelectedRows[0].DataBoundItem;
DialogResult result = MessageBox.Show("'" + returnBook.bookName + "'" + " " + "isimli kitabı teslim almak istediğinizden emin misiniz?", "Uyarı", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (result == DialogResult.Yes)
{
returnBook.IsReturned = false;
returnBook.DateOfReturn = DateTime.Now;
bool sonuc = BLLBorrowedBooks.Update(returnBook);
if (sonuc)
{
MessageBox.Show("Harika! Kitap Teslim Alındı!");
txtIsbnNo.Clear();
}
else
{
MessageBox.Show("Bir hata oluştu!");
}
}
List <EBorrowedBooks> kiralist = BLLBorrowedBooks.GetAll();
kiralist = (from k in kiralist
where k.IsReturned == true
select k).ToList <EBorrowedBooks>();
dataGridView1.DataSource = kiralist;
}
public static bool InsertBorrowedBook(EBorrowedBooks borrowedBook)
{
if (borrowedBook.Book.ID < 1 || borrowedBook.DateOfBorrow == null || borrowedBook.Employee.ID < 1 || borrowedBook.ExpireDate == null || borrowedBook.Member.ID < 1)
{
return(false);
}
else
{
DALBorrowedBooks.InsertBorrowedBook(borrowedBook);
return(true);
}
}
public static void Update(EBorrowedBooks borrowedBook)
{
SqlCommand cmd = new SqlCommand("spBorrowedBooks_Update", Baglanti.conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@DateOfReturn", borrowedBook.DateOfReturn);
cmd.Parameters.AddWithValue("@BorrowedBookID", borrowedBook.ID);
cmd.Parameters.AddWithValue("@IsReturned", borrowedBook.IsReturned);
cmd.Parameters.AddWithValue("@BookID", borrowedBook.Book.ID);
Baglanti.conn.Open();
cmd.ExecuteNonQuery();
Baglanti.conn.Close();
}
public static void InsertBorrowedBook(EBorrowedBooks borrowedBook)
{
SqlCommand cmd = new SqlCommand("spBorrowedBooks_Insert", Baglanti.conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BookID", borrowedBook.Book.ID);
cmd.Parameters.AddWithValue("@EmployeeID", borrowedBook.Employee.ID);
cmd.Parameters.AddWithValue("@MemberID", borrowedBook.Member.ID);
cmd.Parameters.AddWithValue("@ExpireDate", borrowedBook.ExpireDate);
cmd.Parameters.AddWithValue("@DateOfBorrow", borrowedBook.DateOfBorrow);
Baglanti.conn.Open();
cmd.ExecuteNonQuery();
Baglanti.conn.Close();
}
private void btnKaydet_Click(object sender, EventArgs e)
{
if (cmbEmployees.SelectedIndex != -1 & cmbMembers.SelectedIndex != -1 & cmbVerilenKitap.SelectedIndex != -1)
{
EBorrowedBooks borrowedBook = new EBorrowedBooks();
borrowedBook.Book = new EBooks();
borrowedBook.Member = new EMembers();
borrowedBook.Employee = new EEmployees();
borrowedBook.Book.ID = Convert.ToInt32(cmbVerilenKitap.SelectedValue);
borrowedBook.Employee.ID = Convert.ToInt32(cmbEmployees.SelectedValue);
borrowedBook.Member.ID = Convert.ToInt32(cmbMembers.SelectedValue);
borrowedBook.DateOfBorrow = DateTime.Now;
borrowedBook.ExpireDate = dtpExpireDate.Value;
if (borrowedBook.DateOfBorrow <= borrowedBook.ExpireDate)
{
if (BLLBorrowedBooks.InsertBorrowedBook(borrowedBook))
{
MessageBox.Show("Kayıt işleminiz başarıyla gerçekleşmiştir.");
List <EBooks> bookList = BLLBooks.GetBookNames();
if (bookList != null && bookList.Count > 0)
{
bookList = (from l in bookList
where l.IsReturned == false
select l).ToList <EBooks>();
}
cmbVerilenKitap.DataSource = bookList;
}
else
{
MessageBox.Show("Hata Oluştu!");
}
}
else
{
MessageBox.Show("Kitap Teslim Tarihi, alınan tarihten eski olamaz!");
}
cmbEmployees.SelectedIndex = -1;
cmbMembers.SelectedIndex = -1;
cmbVerilenKitap.SelectedIndex = -1;
}
else
{
MessageBox.Show("Eksik bilgi girdiniz. Lütfen kontrol ediniz!");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
if (Request.QueryString["ID"] != null)
{
EBorrowedBooks returnBook = new EBorrowedBooks();
returnBook.ID = int.Parse(Request.QueryString["ID"]);
returnBook = BLLBorrowedBooks.GetIdOnly(returnBook.ID);
returnBook.DateOfReturn = DateTime.Now;
returnBook.IsReturned = false;
bool sonuc = BLLBorrowedBooks.Update(returnBook);
if (sonuc)
{
Response.Write("<script>alert('Harika! Kitap Teslim Alındı!')</script>");
}
else
{
Response.Write("<script>alert('Bir hata oluştu!')</script>");
}
}
List <EBorrowedBooks> bookList = BLLBorrowedBooks.GetAll();
if (bookList != null && bookList.Count > 0)
{
bookList = (from l in bookList
where l.IsReturned == true
select l).ToList <EBorrowedBooks>();
}
else
{
Response.Write("<script>alert('Teslim alınacak kitap bulunamadı!')</script>");
}
rptKitaplar.DataSource = bookList;
rptKitaplar.DataBind();
}
protected void btnKaydet_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(dtpExpireDate.Text))
{
EBorrowedBooks borrowedBook = new EBorrowedBooks();
borrowedBook.Book = new EBooks();
borrowedBook.Member = new EMembers();
borrowedBook.Employee = new EEmployees();
borrowedBook.Book.ID = Convert.ToInt32(cmbVerilenKitap.SelectedValue);
borrowedBook.Employee.ID = Convert.ToInt32(cmbEmployees.SelectedValue);
borrowedBook.Member.ID = Convert.ToInt32(cmbMembers.SelectedValue);
borrowedBook.DateOfBorrow = DateTime.Now;
string[] alinacakTarArr = dtpExpireDate.Text.Split(new string[] { "." }, StringSplitOptions.None);
borrowedBook.ExpireDate = new DateTime(int.Parse(alinacakTarArr[2]), int.Parse(alinacakTarArr[1]), int.Parse(alinacakTarArr[0]));
if (borrowedBook.ExpireDate > DateTime.Now)
{
if (BLLBorrowedBooks.InsertBorrowedBook(borrowedBook))
{
Response.Write("<script>alert('Kayıt işleminiz başarıyla gerçekleşmiştir.')</script>");
}
else
{
Response.Write("<script>alert('Hata Oluştu!')</script>");
}
}
else
{
Response.Write("<script>alert('Kitap Teslim Tarihi, alınan tarihten eski olamaz!')</script>");
}
dtpExpireDate.Text = String.Empty;
cmbEmployees.ClearSelection();
cmbMembers.ClearSelection();
cmbVerilenKitap.ClearSelection();
}
else
{
Response.Write("<script>alert('Eksik bilgi girdiniz. Lütfen kontrol ediniz!')</script>");
}
}
private void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
EBorrowedBooks borrowedBook = ((List <EBorrowedBooks>)(dataGridView1.DataSource))[e.RowIndex];
if (borrowedBook.DateOfReturn < borrowedBook.ExpireDate && borrowedBook.DateOfReturn != null)
{
dataGridView1.Rows[e.RowIndex].DefaultCellStyle.BackColor = Color.Yellow;
dataGridView1.Rows[e.RowIndex].DefaultCellStyle.ForeColor = Color.White;
}
else if (borrowedBook.ExpireDate == DateTime.Now && borrowedBook.DateOfReturn == null)
{
dataGridView1.Rows[e.RowIndex].DefaultCellStyle.BackColor = Color.Orange;
dataGridView1.Rows[e.RowIndex].DefaultCellStyle.ForeColor = Color.White;
}
else if (borrowedBook.ExpireDate < borrowedBook.DateOfReturn && borrowedBook.DateOfReturn != null)
{
dataGridView1.Rows[e.RowIndex].DefaultCellStyle.BackColor = Color.Purple;
dataGridView1.Rows[e.RowIndex].DefaultCellStyle.ForeColor = Color.White;
}
else if (borrowedBook.ExpireDate <= DateTime.Now && borrowedBook.DateOfReturn == null)
{
dataGridView1.Rows[e.RowIndex].DefaultCellStyle.BackColor = Color.Red;
dataGridView1.Rows[e.RowIndex].DefaultCellStyle.ForeColor = Color.White;
}
else if (borrowedBook.ExpireDate > DateTime.Now && borrowedBook.DateOfReturn == null)
{
dataGridView1.Rows[e.RowIndex].DefaultCellStyle.BackColor = Color.Green;
dataGridView1.Rows[e.RowIndex].DefaultCellStyle.ForeColor = Color.White;
}
else
{
dataGridView1.Rows[e.RowIndex].DefaultCellStyle.BackColor = Color.White;
dataGridView1.Rows[e.RowIndex].DefaultCellStyle.ForeColor = Color.Black;
}
}
public static List <EBorrowedBooks> GetAll()
{
SqlCommand cmd = new SqlCommand("spBorrowedBooks_GetAll", Baglanti.conn);
Baglanti.conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
List <EBorrowedBooks> bliste = new List <EBorrowedBooks>();
while (dr.Read())
{
EBorrowedBooks b = new EBorrowedBooks();
b.Employee = new EEmployees();
b.Member = new EMembers();
b.Book = new EBooks();
b.ID = Convert.ToInt32(dr["ID"]);
b.Book.Name = dr["Name"].ToString();
b.Employee.ID = Convert.ToInt32(dr["EmployeeID"]);
b.Employee.FullName = dr["EmployeeName"].ToString();
b.Member.ID = Convert.ToInt32(dr["MemberID"]);
b.Member.FullName = dr["MemberName"].ToString();
b.DateOfBorrow = Convert.ToDateTime(dr["DateOfBorrow"]);
b.ExpireDate = Convert.ToDateTime(dr["ExpireDate"]);
b.Book.ID = Convert.ToInt32(dr["BookID"]);
b.Book.ISBNNO = dr["ISBN No"].ToString();
b.IsReturned = Convert.ToBoolean(dr["IsReturned"]);
if (dr["DateOfReturn"] == DBNull.Value)
{
b.DateOfReturn = null;
}
else
{
b.DateOfReturn = Convert.ToDateTime(dr["DateOfReturn"]);
}
bliste.Add(b);
}
dr.Close();
Baglanti.conn.Close();
return(bliste);
}
public static bool Update(EBorrowedBooks borrowedbook)
{
DALBorrowedBooks.Update(borrowedbook);
return(true);
}