private void frmLogin_Load(object sender, EventArgs e)
{
if (IsEdit)
{
this.Text = "تنظیمات کاربر";
this.btnLogin.Text = "ویرایش کاربر";
using (var uow = new UnitOfWorks())
{
var id = Common.Common.UserID;
var data = uow.Userrepository.GetById(id);
this.txtUsername.Text = data.Username;
this.txtPassword.Text = data.userPassword;
}
}
}
public void Upload()
{
string mathevienchuc = _view.MaTheVienChuc.EditValue.ToString();
_view.OpenFileDialog.FileName = string.Empty;
_view.OpenFileDialog.Filter = "Image files (*.jpg, *.jpeg, *.jpe, *.jfif, *.png) | *.jpg; *.jpeg; *.jpe; *.jfif; *.png";
if (_view.OpenFileDialog.ShowDialog() == DialogResult.Cancel)
{
return;
}
UnitOfWorks unitOfWorks = new UnitOfWorks(new Model.Entities.QLNSSGU_1Entities());
if (unitOfWorks.GoogleDriveFileRepository.InternetAvailable() == true)
{
try
{
SplashScreenManager.ShowForm(_view, typeof(WaitForm1), true, true, false);
SplashScreenManager.Default.SetWaitFormCaption("Vui lòng chờ");
SplashScreenManager.Default.SetWaitFormDescription("Đang tải tập tin lên Google Drive....");
foreach (string filename in _view.OpenFileDialog.FileNames)
{
string[] temp = filename.Split('\\');
if (temp[temp.Length - 1].Contains(mathevienchuc))
{
unitOfWorks.GoogleDriveFileRepository.UploadFile(filename);
}
else
{
string[] split_filename = filename.Split('.');
string new_filename = split_filename[0] + "-" + mathevienchuc + "." + split_filename[1];
FileInfo fileInfo = new FileInfo(filename);
fileInfo.MoveTo(new_filename);
unitOfWorks.GoogleDriveFileRepository.UploadFile(new_filename);
}
}
SplashScreenManager.CloseForm();
DataSource();
}
catch
{
XtraMessageBox.Show("Tải lên thất bại. Vui lòng kiểm tra lại đường truyền", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
XtraMessageBox.Show("Tải lên thất bại. Vui lòng kiểm tra lại đường truyền", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void ClickRowAndShowInfo()
{
checkAddNew = false;
UnitOfWorks unitOfWorks = new UnitOfWorks(new QLNSSGU_1Entities());
int row_handle = _view.GVDanhGiaVienChuc.FocusedRowHandle;
if (row_handle >= 0)
{
string khoangthoigian = _view.GVDanhGiaVienChuc.GetFocusedRowCellDisplayText("KhoangThoiGian").ToString();
string mucdodanhgia = _view.GVDanhGiaVienChuc.GetFocusedRowCellDisplayText("MucDoDanhGia").ToString();
_view.CBXKhoangThoiGian.EditValue = unitOfWorks.DanhMucThoiGianRepository.GetIdByName(khoangthoigian);
_view.CBXMucDoDanhGia.EditValue = unitOfWorks.MucDoDanhGiaRepository.GetIdByName(mucdodanhgia);
_view.DTNgayBatDau.EditValue = unitOfWorks.HopDongVienChucRepository.ReturnNullIfDateTimeNullToView(_view.GVDanhGiaVienChuc.GetFocusedRowCellDisplayText("NgayBatDau"));
_view.DTNgayKetThuc.EditValue = unitOfWorks.HopDongVienChucRepository.ReturnNullIfDateTimeNullToView(_view.GVDanhGiaVienChuc.GetFocusedRowCellDisplayText("NgayKetThuc"));
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (dgvReport.CurrentRow != null)
{
var id = int.Parse(dgvReport.CurrentRow.Cells[0].Value.ToString());
if (RtlMessageBox.Show("آیا از حذف مطمئن هستید؟", "توجه", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
using (var uow = new UnitOfWorks())
{
uow.AccountingRepo.Delete(id);
uow.Save();
Filter();
}
}
}
}
private void Filter()
{
using (var uow = new UnitOfWorks())
{
List <DataLayer.Context.Accounting> result = new List <DataLayer.Context.Accounting>();
DateTime?startDate;
DateTime?endDate;
if ((int)cbCustomers.SelectedValue != 0)
{
var customerID = int.Parse(cbCustomers.SelectedValue.ToString());
result.AddRange(uow.AccountingRepo.GetAll(a => a.TypeID_typ == reportType && a.CustomerID_Cus == customerID));
}
else
{
result.AddRange(uow.AccountingRepo.GetAll(a => a.TypeID_typ == reportType));
}
if (txtFromDate.Text != " / /")
{
startDate = Convert.ToDateTime(txtFromDate.Text);
startDate = Convertors.ToMiladi(startDate.Value);
result = result.Where(r => r.CreationDate.Date >= startDate.Value.Date).ToList();
}
if (txtToDate.Text != " / /")
{
endDate = Convert.ToDateTime(txtToDate.Text);
endDate = Convertors.ToMiladi(endDate.Value);
var sss = endDate.Value.Date;
result = result.Where(r => r.CreationDate.Date <= endDate.Value.Date).ToList();
}
//dgvReport.DefaultCellStyle.SelectionBackColor = dgvReport.DefaultCellStyle.BackColor;
//dgvReport.DefaultCellStyle.SelectionForeColor = dgvReport.DefaultCellStyle.ForeColor;
//dgvReport.AutoGenerateColumns = false;
//dgvReport.DataSource = result;
dgvReport.Rows.Clear();
foreach (var item in result)
{
var customerName = uow.CustomerRepository.GetCustomerNameById(item.CustomerID_Cus);
dgvReport.Rows.Add(item.AccountigID, customerName, item.Amount.ShowMoney(), item.CreationDate.ToShamsi(), item.AccountingDescription);
}
}
}
/// <summary>
/// Get All Categories
/// </summary>
/// <returns></returns>
public List <Categories> GetAllCategories()
{
List <Categories> lstcategories = new List <Categories>();
using (IUnitOfWorks unitOfWorks = new UnitOfWorks())
{
var result = unitOfWorks.CategoryRepository.GetAllCategory().ToList();
result.ToList().ForEach(c =>
{
Categories categories = new Categories();
categories.Category = c.Category;
categories.CategoryId = c.CategoryId;
lstcategories.Add(categories);
});
}
return(lstcategories);
}
private void InsertData()
{
string mavienchuc = _view.TXTMaVienChuc.Text;
UnitOfWorks unitOfWorks = new UnitOfWorks(new QLNSSGU_1Entities());
unitOfWorks.QuaTrinhDanhGiaVienChucRepository.Insert(new QuaTrinhDanhGiaVienChuc
{
idVienChuc = unitOfWorks.VienChucRepository.GetIdVienChuc(mavienchuc),
idDanhMucThoiGian = Convert.ToInt32(_view.CBXKhoangThoiGian.EditValue),
ngayBatDau = DateTimeHelper.ParseDatetimeMatchDatetimeDatabase(_view.DTNgayBatDau.Text),
ngayKetThuc = DateTimeHelper.ParseDatetimeMatchDatetimeDatabase(_view.DTNgayKetThuc.Text),
idMucDoDanhGia = Convert.ToInt32(_view.CBXMucDoDanhGia.EditValue)
});
unitOfWorks.Save();
LoadGridTabPageDanhGiaVienChuc(_view.TXTMaVienChuc.Text);
XtraMessageBox.Show("Thêm dữ liệu thành công.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
SetDefaultValueControl();
}
public static HomeReportViewModels HomeReport()
{
var rp = new HomeReportViewModels();
using (var uow = new UnitOfWorks())
{
var startDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 01);
var endDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 30);
var recieve = uow.AccountingRepo.GetAll(r => r.TypeID_typ == 2 && r.CreationDate >= startDate && r.CreationDate <= endDate)
.Sum(r => int.Parse(r.Amount));
var pays = uow.AccountingRepo.GetAll(p => p.TypeID_typ == 1 && p.CreationDate >= startDate && p.CreationDate <= endDate)
.Sum(s => int.Parse(s.Amount));
rp.Receive = recieve;
rp.Pay = pays;
rp.AccountBalance = recieve - pays;
}
return(rp);
}
private void frmAddOrEditCustomer_Load(object sender, EventArgs e)
{
if (customerID != 0)
{
this.Text = "ویرایش شخص";
this.btnSave.Text = "ویرایش";
using (var uow = new UnitOfWorks())
{
var customer = uow.CustomerRepository.GetById(customerID);
txtFullName.Text = customer.FullName;
txtMobile.Text = customer.Mobile;
txtEmail.Text = customer.Email;
txtAddress.Text = customer.CustomerAddress;
pcCustomer.ImageLocation = Application.StartupPath + "/Images/Customers/" + customer.CustomerImage;
}
}
}
/// <summary>
/// Login
/// </summary>
/// <param name="userId"></param>
/// <param name="password"></param>
/// <returns></returns>
public Users Login(int userId, string password)
{
Users users = new Users();
using (IUnitOfWorks unitOfWorks = new UnitOfWorks())
{
var result = unitOfWorks.UserRepository.Login(userId, password);
if (result != null)
{
users.FirstName = result.FirstName;
users.LastName = result.LastName;
users.RoleId = result.RoleId;
users.EmailId = result.EmailId;
users.UserId = result.UserId;
users.Password = result.Password;
}
}
return(users);
}
/// <summary>
/// Get Return Book Details
/// </summary>
/// <param name="bookId"></param>
/// <returns></returns>
public Transaction GetReturnDetails(int bookId)
{
Transaction transaction = new Transaction();
using (IUnitOfWorks unitOfWorks = new UnitOfWorks())
{
var result = unitOfWorks.TransactionRepository.GetByID(x => x.BookId == bookId && x.ReturnDate == null);
if (result != null)
{
transaction.BookId = result.BookId;
transaction.DueDate = result.DueDate;
transaction.IssueDate = result.IssueDate;
transaction.ReturnDate = result.ReturnDate;
transaction.TransactionId = result.TransactionId;
transaction.UserId = result.UserId;
}
//unitOfWorks.Save();
}
return(transaction);
}
/// <summary>
/// Get Member Details
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public Users GetMemberDetails(int userId)
{
Users users = new Users();
using (IUnitOfWorks unitOfWorks = new UnitOfWorks())
{
var result = unitOfWorks.UserRepository.GetByID(x => x.UserId == userId);
if (result != null)
{
users.DOB = result.DOB;
users.EmailId = result.EmailId;
users.FirstName = result.FirstName;
users.LastName = result.LastName;
users.MobileNo = result.MobileNo;
users.Password = result.Password;
users.RoleId = result.RoleId;
users.UserId = result.UserId;
}
}
return(users);
}
/// <summary>
/// Get Self Transactions
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public List <Transaction> GetSelfTransaction(int userId)
{
List <Transaction> lsttransaction = new List <Transaction>();
using (IUnitOfWorks unitOfWorks = new UnitOfWorks())
{
var result = unitOfWorks.TransactionRepository.GetSelfTransaction(userId).ToList();
result.ToList().ForEach(c =>
{
Transaction transaction = new Transaction();
transaction.BookId = c.BookId;
transaction.DueDate = c.DueDate;
transaction.IssueDate = c.IssueDate;
transaction.ReturnDate = c.ReturnDate;
transaction.TransactionId = c.TransactionId;
transaction.UserId = c.UserId;
lsttransaction.Add(transaction);
});
}
return(lsttransaction);
}
private void DataSource()
{
UnitOfWorks unitOfWorks = new UnitOfWorks(new Model.Entities.QLNSSGU_1Entities());
string mathevienchuc = _view.MaTheVienChuc.EditValue.ToString();
List <GoogleDriveFile> list1 = unitOfWorks.GoogleDriveFileRepository.GetDriveFiles(mathevienchuc);
List <GoogleDriveFile> list2 = new List <GoogleDriveFile>();
foreach (var a in list1)
{
list2.Add(new GoogleDriveFile
{
TT = a.TT,
ID = a.ID,
Name = a.Name,
Size = a.Size / 1024,
Version = a.Version,
CreatedTime = a.CreatedTime
});
}
_view.GridControl.DataSource = list2;
}
/// <summary>
/// Get Book Details
/// </summary>
/// <param name="bookId"></param>
/// <returns></returns>
public Books GetBookDetails(int bookId)
{
Books books = new Books();
using (IUnitOfWorks unitOfWorks = new UnitOfWorks())
{
var result = unitOfWorks.BookRepository.GetByID(x => x.BookId == bookId);
if (result != null)
{
books.Author = result.Author;
books.AvailStatus = result.AvailStatus;
books.BookId = result.BookId;
books.Category = result.Category;
books.Description = result.Description;
books.ISBNNumber = result.Description;
books.Title = result.Title;
books.Price = result.Price;
books.Publisher = result.Publisher;
}
}
return(books);
}
/// <summary>
/// Get Authentication Details
/// </summary>
/// <param name="emailId"></param>
/// <returns></returns>
public Users GetAuthenticationDetails(string emailId)
{
Users users = new Users();
using (IUnitOfWorks unitOfWorks = new UnitOfWorks())
{
var result = unitOfWorks.UserRepository.GetByID(x => x.EmailId == emailId);
if (result != null)
{
users.UserId = result.UserId;
users.Password = result.Password;
//users.DOB = users.DOB;
//users.EmailId = users.EmailId;
//users.FirstName = users.FirstName;
//users.LastName = users.LastName;
//users.MobileNo = users.MobileNo;
//users.RoleId = users.RoleId;
//unitOfWorks.Save();
}
}
return(users);
}
/// <summary>
/// Add Member
/// </summary>
/// <param name="users"></param>
/// <returns></returns>
public int AddMember(Users users)
{
tbl_Users tbl_users = new tbl_Users();
using (IUnitOfWorks unitOfWorks = new UnitOfWorks())
try
{
tbl_users.DOB = users.DOB;
tbl_users.EmailId = users.EmailId;
tbl_users.FirstName = users.FirstName;
tbl_users.LastName = users.LastName;
tbl_users.MobileNo = users.MobileNo;
tbl_users.Password = "******";
tbl_users.RoleId = users.RoleId;
unitOfWorks.UserRepository.Insert(tbl_users);
unitOfWorks.Save();
return(1);
}
catch (Exception ex)
{
return(0);
}
}
/// <summary>
/// Delete Member
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public int DeleteMember(int userID)
{
using (IUnitOfWorks unitOfWorks = new UnitOfWorks())
try
{
var result = unitOfWorks.TransactionRepository.GetDetailsbyUserId(userID).ToList();
if (result != null)
{
//var transaction = unitOfWorks.TransactionRepository.GetByID(user => user.UserId == userID && user.ReturnDate != null);
//if (transaction != null)
//{
// unitOfWorks.TransactionRepository.Delete(transaction.TransactionId);
// unitOfWorks.UserRepository.Delete(userID);
// unitOfWorks.Save();
// return 1;
//}
result.ToList().ForEach(c =>
{
Transaction transaction = new Transaction();
{
transaction.TransactionId = c.TransactionId;
unitOfWorks.TransactionRepository.Delete(transaction.TransactionId);
unitOfWorks.Save();
}
});
}
unitOfWorks.UserRepository.Delete(userID);
unitOfWorks.Save();
return(1);
}
catch (Exception ex)
{
return(-99);
}
}
/// <summary>
/// Search Books
/// </summary>
/// <param name="columnName"></param>
/// <param name="searchItems"></param>
/// <returns></returns>
public List <Books> SearchBooks(string columnName, string searchItems)
{
List <Books> lstbooks = new List <Books>();
using (IUnitOfWorks unitOfWorks = new UnitOfWorks())
{
var result = unitOfWorks.BookRepository.SearchBooks(columnName, searchItems).ToList();
result.ToList().ForEach(c =>
{
Books books = new Books();
books.Title = c.Title;
books.Author = c.Author;
books.Category = c.Category;
books.Description = c.Description;
books.ISBNNumber = c.ISBNNumber;
books.Publisher = c.Publisher;
books.AvailStatus = c.AvailStatus;
books.BookId = c.BookId;
lstbooks.Add(books);
});
}
return(lstbooks);
}
private void LoadCbxData()
{
UnitOfWorks unitOfWorks = new UnitOfWorks(new QLNSSGU_1Entities());
List <DanhMucThoiGian> listDanhMucThoiGian = unitOfWorks.DanhMucThoiGianRepository.GetListDanhMucThoiGian();
_view.CBXKhoangThoiGian.Properties.DataSource = listDanhMucThoiGian;
_view.CBXKhoangThoiGian.Properties.DisplayMember = "tenDanhMucThoiGian";
_view.CBXKhoangThoiGian.Properties.ValueMember = "idDanhMucThoiGian";
_view.CBXKhoangThoiGian.Properties.DropDownRows = listDanhMucThoiGian.Count;
_view.CBXKhoangThoiGian.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("idDanhMucThoiGian", string.Empty));
_view.CBXKhoangThoiGian.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("tenDanhMucThoiGian", string.Empty));
_view.CBXKhoangThoiGian.Properties.Columns[0].Visible = false;
List <MucDoDanhGia> listMucDoDanhGia = unitOfWorks.MucDoDanhGiaRepository.GetListMucDoDanhGia();
_view.CBXMucDoDanhGia.Properties.DataSource = listMucDoDanhGia;
_view.CBXMucDoDanhGia.Properties.DisplayMember = "tenMucDoDanhGia";
_view.CBXMucDoDanhGia.Properties.ValueMember = "idMucDoDanhGia";
_view.CBXMucDoDanhGia.Properties.DropDownRows = listMucDoDanhGia.Count;
_view.CBXMucDoDanhGia.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("idMucDoDanhGia", string.Empty));
_view.CBXMucDoDanhGia.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("tenMucDoDanhGia", string.Empty));
_view.CBXMucDoDanhGia.Properties.Columns[0].Visible = false;
}
