private void txtSearchBooks_TextChanged(object sender, EventArgs e)
{
using (ControlerDB db = new ControlerDB())
{
dgvBooks.DataSource = db.BookRepository.get(tb => tb.BookName.Contains(txtSearchBooks.Text) || tb.Publishare.Contains(txtSearchBooks.Text) || tb.Writer.Contains(txtSearchBooks.Text));
}
}
private void txtSearchCustomer_TextChanged(object sender, EventArgs e)
{
using (ControlerDB db = new ControlerDB())
{
dgvCustomers.DataSource = db.CustomersRepository.GetCustomersByFilter(txtSearchCustomer.Text);
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
if (BaseValidator.IsFormValid(this.components))
{
BookTB book = new BookTB()
{
BookName = txtBookName.Text,
Code = txtBookCode.Text,
Publishare = txtPublishare.Text,
Writer = txtWriter.Text
};
using (ControlerDB db = new ControlerDB())
{
if (BookId == 0)
{
db.BookRepository.Insert(book);
db.Save();
}
else
{
book.BookID = BookId;
db.BookRepository.Updatae(book);
db.Save();
}
}
DialogResult = DialogResult.OK;
}
}
void FromBimd()
{
using (ControlerDB db = new ControlerDB())
{
DGV_Customize.DGV_Customize.DGV_Columns(dgvFrom, 0, "ID", "ID", "code", false);
DGV_Customize.DGV_Customize.DGV_Columns(dgvFrom, 1, "User", "UserName", "کاربر");
DGV_Customize.DGV_Customize.DGV_Columns(dgvFrom, 2, "Book", "BookName", "کتاب");
DGV_Customize.DGV_Customize.DGV_Columns(dgvFrom, 3, "Date", "DateTime", "تاریخ");
DGV_Customize.DGV_Customize.DGV_Columns(dgvFrom, 4, "Type", "Type", "نوع");
dgvFrom.AutoGenerateColumns = false;
List <FromViewModel> fromViewModels = new List <FromViewModel>();
var froms = db.FromRepository.get();
foreach (var fromTb in froms)
{
FromViewModel from = new FromViewModel()
{
Type = (fromTb.Type) ? "تحویل" : "دریافت",
BookName = fromTb.BookTB.BookName,
UserName = fromTb.CustomerTB.FullName,
FromId = fromTb.ID,
DateTime = fromTb.Date.Toshamsi()
};
fromViewModels.Add(from);
}
dgvFrom.DataSource = fromViewModels.ToList();
}
}
private void dgvCustomers_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (dgvCustomers.CurrentRow != null)
{
int userid = int.Parse(dgvCustomers.CurrentRow.Cells[0].Value.ToString());
using (ControlerDB db = new ControlerDB())
{
string imagename = Application.StartupPath + "/Images/" + db.CustomersRepository.GetCustomerpictourById(userid);
pcCustomers.ImageLocation = imagename;
}
}
}
private void AddOrEditAction_Load(object sender, EventArgs e)
{
DGV_Customize.DGV_Customize.dgvdesign(dgvBook, 2);
BooksBind();
if (userId != 0)
{
using (ControlerDB db = new ControlerDB())
{
var user = db.CustomersRepository.GetCustomerByID(userId);
this.Text = user.FullName;
}
}
}
void BooksBind()
{
using (ControlerDB db = new ControlerDB())
{
DGV_Customize.DGV_Customize.DGV_Columns(dgvBooks, 0, "ID", "BookID", "Cod", false);
DGV_Customize.DGV_Customize.DGV_Columns(dgvBooks, 1, "name", "BookName", "نام کتاب");
DGV_Customize.DGV_Customize.DGV_Columns(dgvBooks, 2, "Writer", "Writer", "نویسنده");
DGV_Customize.DGV_Customize.DGV_Columns(dgvBooks, 3, "Publishare", "Publishare", "انتشارات");
DGV_Customize.DGV_Customize.DGV_Columns(dgvBooks, 4, "Code", "Code", "کد");
dgvBooks.AutoGenerateColumns = false;
dgvBooks.DataSource = db.BookRepository.get();
db.Dispose();
}
}
void UsersBind()
{
using (ControlerDB db = new ControlerDB())
{
DGV_Customize.DGV_Customize.DGV_Columns(dgvCustomers, 0, "ID", "CustomerID", "Code", false);
DGV_Customize.DGV_Customize.DGV_Columns(dgvCustomers, 1, "FullName", "FullName", "نام");
DGV_Customize.DGV_Customize.DGV_Columns(dgvCustomers, 2, "Phone", "Phone", "تلفن");
DGV_Customize.DGV_Customize.DGV_Columns(dgvCustomers, 3, "Email", "Email", "ایمیل");
DGV_Customize.DGV_Customize.DGV_Columns(dgvCustomers, 4, "Address", "Address", "آدرس");
//Data Grid View Source And InforMation
dgvCustomers.AutoGenerateColumns = false;
dgvCustomers.DataSource = db.CustomersRepository.GetAllCustomer();
db.Dispose();
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
using (ControlerDB db = new ControlerDB())
{
FromTb from = new FromTb()
{
BookID = bookId,
Date = DateTime.Now,
Type = (rdbPay.Checked)? true : false,
UserID = userId
};
db.FromRepository.Insert(from);
db.Save();
}
DialogResult = DialogResult.OK;
}
private void AddOrEditeBooks_Load(object sender, EventArgs e)
{
if (BookId != 0)
{
using (ControlerDB db = new ControlerDB())
{
var book = db.BookRepository.GetByID(BookId);
this.Text = "ویرایش " + book.BookName;
this.txtBookName.Text = book.BookName;
this.txtBookCode.Text = book.Code;
this.txtPublishare.Text = book.Publishare;
this.txtWriter.Text = book.Writer;
this.btnSubmit.Text = "ویرایش";
}
}
}
private void AddOREditeCustomers_Load(object sender, EventArgs e)
{
if (userId != 0)
{
using (ControlerDB db = new ControlerDB())
{
var user = db.CustomersRepository.GetCustomerByID(userId);
this.Text = $"ویرایش {user.FullName}";
this.pcCustomer.ImageLocation = Application.StartupPath + "/Images/" + user.CustomerIMG;
this.txtFullName.Text = user.FullName;
this.txtPhone.Text = user.Phone;
this.txtEmail.Text = user.Email;
this.txtAddress.Text = user.Address;
this.btnSubmit.Text = "ویرایش";
}
}
}
private void txtSearchBook_TextChanged(object sender, EventArgs e)
{
using (ControlerDB db = new ControlerDB())
{
var books = db.BookRepository.get(tb => tb.BookName.Contains(txtSearchBook.Text));
List <BooksViewModel> book = new List <BooksViewModel>();
foreach (var booktb in books)
{
book.Add(new BooksViewModel {
BookId = booktb.BookID, BookName = booktb.BookName
});
}
DGV_Customize.DGV_Customize.DGV_Columns(dgvBook, 0, "ID", "BookID", "code", false);
DGV_Customize.DGV_Customize.DGV_Columns(dgvBook, 1, "User", "BookName", "کتاب");
dgvBook.AutoGenerateColumns = false;
dgvBook.DataSource = book.ToList();
}
}
void BooksBind()
{
using (ControlerDB db = new ControlerDB())
{
var books = db.BookRepository.get();
List <BooksViewModel> book = new List <BooksViewModel>();
foreach (var booktb in books)
{
book.Add(new BooksViewModel {
BookId = booktb.BookID, BookName = booktb.BookName
});
}
DGV_Customize.DGV_Customize.DGV_Columns(dgvBook, 0, "ID", "BookID", "code", false);
DGV_Customize.DGV_Customize.DGV_Columns(dgvBook, 1, "User", "BookName", "کتاب");
dgvBook.AutoGenerateColumns = false;
dgvBook.DataSource = book.ToList();
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
using (ControlerDB db = new ControlerDB())
{
string path = Application.StartupPath + "/Images/";
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
string imagename = Guid.NewGuid().ToString() +
Path.GetExtension(pcCustomer.ImageLocation);
pcCustomer.Image.Save(path + imagename);
if (BaseValidator.IsFormValid(this.components))
{
CustomerTB customer = new CustomerTB()
{
FullName = txtFullName.Text,
Address = txtAddress.Text,
Email = txtEmail.Text,
Phone = txtPhone.Text,
CustomerIMG = imagename
};
if (userId == 0)
{
db.CustomersRepository.InsertCustomers(customer);
}
if (userId != 0)
{
customer.CustomerID = userId;
db.CustomersRepository.UpdateCustomer(customer);
}
db.Save();
}
DialogResult = DialogResult.OK;
}
}
private void btnDeleteCustomer_Click(object sender, EventArgs e)
{
if (dgvCustomers.CurrentRow != null)
{
int userid = int.Parse(dgvCustomers.CurrentRow.Cells[0].Value.ToString());
using (ControlerDB db = new ControlerDB())
{
if (MessageBox.Show("ایا از حذف اطمینان دارید؟", "هشدار", MessageBoxButtons.YesNo,
MessageBoxIcon.Warning) == DialogResult.Yes)
{
var user = db.CustomersRepository.GetCustomerByID(userid);
File.Delete(Application.StartupPath + "/Images/" + user.CustomerIMG);
db.CustomersRepository.DeleteCustomer(userid);
db.Save();
UsersBind();
}
}
}
else
{
MessageBox.Show("لطفا یک نغر را انتخاب کنید", "خطا", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
}
}
private void btnDeleteBooks_Click(object sender, EventArgs e)
{
if (dgvBooks.CurrentRow != null)
{
int bookId = int.Parse(dgvBooks.CurrentRow.Cells[0].Value.ToString());
if (MessageBox.Show("ایا میخواهید این کتاب را حذف کنید؟", "هشدار", MessageBoxButtons.YesNo,
MessageBoxIcon.Question) == DialogResult.Yes)
{
using (ControlerDB db = new ControlerDB())
{
try
{
var form = db.FromRepository.get(fr => fr.BookID == bookId);
foreach (var fromTb in form)
{
db.FromRepository.Delete(fromTb);
}
db.BookRepository.Delete(bookId);
db.Save();
BooksBind();
FromBimd();
}
catch
{
MessageBox.Show("حذف با خطا مواجه شد");
}
db.Save();
BooksBind();
}
}
}
else
{
MessageBox.Show("لطفا یک نغر را انتخاب کنید", "خطا", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
}
}
