private void BtnEdit_Click(object sender, EventArgs e)
{
if (dgvStudentList.Rows.Count > 0)
{
if (dgvStudentList.SelectedRows.Count == 1)
{
int selectIndex = dgvStudentList.CurrentRow.Index;
var studentID = dgvStudentList.Rows[selectIndex].Cells[0].Value;
var student = StudentsHelper.GetById(Convert.ToInt32(studentID));
cmbSession.SelectedItem = SessionsHelper.GetByNameFromID(student.SessionID);
cmbDepartment.SelectedItem = DepartmentsHelper.GetByNameFromID(student.DepartmentID);
cmbProgram.SelectedItem = ProgramsHelper.GetByNameFromID(student.ProgramID);
txtStudentName.Text = student.Name;
txtTCNO.Text = student.TCNO;
cmbGender.SelectedIndex = student.Gender;
txtEnrollNo.Text = student.EnrollNo;
txtAddress.Text = student.Address;
txtContactNo.Text = student.ContactNo;
EnableComponent();
}
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
try
{
if (dgvProgramList.Rows.Count > 0)
{
DialogResult dialogResult = MessageBox.Show("Session'u silmek istediğinize emin misiniz?", "Library Management System", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
int selectIndex = dgvProgramList.CurrentRow.Index;
var sessionID = dgvProgramList.Rows[selectIndex].Cells[0].Value;
SessionsHelper.Delete(Convert.ToInt32(sessionID));
MessageBox.Show("Session Silme Başarılı", "Library Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
FillGrid();
}
}
}
catch (Exception ex)
{
MessageBox.Show("Herhangi bir eleman seçmediniz!", "Library Management System", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void BtnAdd_Click(object sender, EventArgs e)
{
epProgram.Clear();
bool check = SessionsHelper.ControlValidate(txtSessionName, "Lütfen Session İsmini Giriniz.", epProgram);
if (check)
{
if (!SessionsHelper.HaveSessionName(txtSessionName.Text))
{
Sessions s = new Sessions();
s.Name = Convert.ToString(txtSessionName.Text).Trim();
s.StartDate = dtpStartDate.Value;
s.EndDate = dtpEndDate.Value;
SessionsHelper.Add(s);
MessageBox.Show("Program Ekleme Başarılı", "Library Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
FillGrid();
}
else
{
MessageBox.Show("Aynı isimde bir Session zaten ekli!", "Library Management System", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
public IActionResult Buy(int id)
{
ProductModel productModel = new ProductModel();
if (SessionsHelper.GetObjectFromJson <List <Item> >(HttpContext.Session, "cart") == null)
{
List <Item> cart = new List <Item>();
cart.Add(new Item {
Product = productModel.find(id), Quantity = 1
});
SessionsHelper.SetObjectAsJson(HttpContext.Session, "cart", cart);
}
else
{
List <Item> cart = SessionsHelper.GetObjectFromJson <List <Item> >(HttpContext.Session, "cart");
int index = isExist(id);
if (index != -1)
{
cart[index].Quantity++;
}
else
{
cart.Add(new Item {
Product = productModel.find(id), Quantity = 1
});
}
SessionsHelper.SetObjectAsJson(HttpContext.Session, "cart", cart);
}
return(RedirectToAction("Index"));
}
public IActionResult Index()
{
var cart = SessionsHelper.GetObjectFromJson <List <Item> >(HttpContext.Session, "cart");
ViewBag.cart = cart;
ViewBag.total = cart.Sum(item => item.Product.Price * item.Quantity);
return(View());
}
private void frmStudent_Load(object sender, EventArgs e)
{
cmbSession.DataSource = SessionsHelper.GetSessionsNameList();
cmbDepartment.DataSource = DepartmentsHelper.GetDepartmentsNameList();
cmbProgram.DataSource = ProgramsHelper.GetProgramsNameList();
cmbGender.DataSource = Enum.GetValues(typeof(Gender));
FillGrid();
}
public GuidesRoutesViewModel(IRegionManager RegionManager)
{
ApplyGuidesPopupCommand = new DelegateCommand <object>(ApplyGuidesPopup);
CloseGuidesPopupCommand = new DelegateCommand <object>(CloseGuidesPopup);
EnterprisesList = new ObservableCollection <Enterprises>();
EnterprisesList.AddRange(SessionsHelper.GetEnterprisesList());
}
public LoginFormViewModel()
{
ButtonLoginCommand = new DelegateCommand <object[]>(ButtonLogin);
ButtonCancelCommand = new DelegateCommand <object>(ButtonCancel);
UsersList = new ObservableCollection <Users>();
UsersList.AddRange(SessionsHelper.GetUsersList());
}
public GuidesPointsViewModel(IRegionManager RegionManager)
{
PointTypesList = new ObservableCollection <PointTypes>();
PointTypesList.AddRange(SessionsHelper.GetPointTypesList());
ApplyGuidesPopupCommand = new DelegateCommand <object>(ApplyGuidesPopup);
CloseGuidesPopupCommand = new DelegateCommand <object>(CloseGuidesPopup);
}
public IActionResult Remove(int id)
{
List <Item> cart = SessionsHelper.GetObjectFromJson <List <Item> >(HttpContext.Session, "cart");
int index = isExist(id);
cart.RemoveAt(index);
SessionsHelper.SetObjectAsJson(HttpContext.Session, "cart", cart);
return(RedirectToAction("Index"));
}
private void FillGridStudent(Students s)
{
dgvStudentDetail.Rows.Clear();
dgvStudentDetail.Rows.Add($"Adı : {s.Name}");
dgvStudentDetail.Rows.Add($"TC No : {s.TCNO}");
dgvStudentDetail.Rows.Add($"Dönem : {SessionsHelper.GetByNameFromID(s.SessionID)}");
dgvStudentDetail.Rows.Add($"Bölüm : {DepartmentsHelper.GetByNameFromID(s.DepartmentID)}");
dgvStudentDetail.Rows.Add($"Dönem : {ProgramsHelper.GetByNameFromID(s.ProgramID)}");
}
private void ApplyGuidesPopup(object Parameters)
{
int sres = SessionsHelper.GuidesItemSave(new Posts()
{
Id = _postsId,
Name = PostsName
});
RaiseRequestClose(new DialogResult(sres > 0 ? ButtonResult.OK : ButtonResult.No));
}
private void GuidesAddItem()
{
_currentDialogService.ShowDialog(GuidesMenuSelectedItem.DialogName, new DialogParameters(), r =>
{
if (r.Result == ButtonResult.OK)
{
GuidesDataItems = SessionsHelper.GetDataGridGuidesItems(GuidesMenuSelectedItem);
}
});
}
private void ApplyGuidesPopup(object Parameters)
{
int sres = SessionsHelper.GuidesItemSave(new Enterprises()
{
Id = _enteprisesId,
Inn = EnterprisesInn,
Name = EnterprisesName
});
RaiseRequestClose(new DialogResult(sres > 0 ? ButtonResult.OK : ButtonResult.No));
}
protected override void OnStartup(StartupEventArgs e)
{
// show splash
SplashScreenForm splashScreenForm = new SplashScreenForm();
splashScreenForm.Show();
Task.Factory.StartNew(() =>
{
// empty
splashScreenForm.SplashScreenText("Инициализация ...");
System.Threading.Thread.Sleep(500);
// db connect
splashScreenForm.SplashScreenText("Соединение с базой данных ...");
SessionsHelper.DatabaseConnect();
/*
* // login form
* splashScreenForm.SplashScreenText("Идентификация пользователя ...");
* splashScreenForm.SplashScreenProgress(false);
* Application.Current.Dispatcher.Invoke((Action)delegate
* {
* LoginFormViewModel loginFormViewModel = new LoginFormViewModel();
* LoginForm loginForm = new LoginForm();
* loginForm.Owner = splashScreenForm;
* loginForm.DataContext = loginFormViewModel;
* loginFormViewModel.OnRequestClose += (s, ee) => loginForm.Close();
* var r = loginForm.ShowDialog();
* });
*/
SessionsHelper.CurrentUser = SessionsHelper.GetUsersList().First();
if (SessionsHelper.CurrentUser != null)
{
// empty
splashScreenForm.SplashScreenText("Применение параметров ...");
splashScreenForm.SplashScreenProgress(true);
System.Threading.Thread.Sleep(500);
this.Dispatcher.Invoke(() =>
{
base.OnStartup(e);
splashScreenForm.Close();
});
}
else
{
Process.GetCurrentProcess().Kill();
}
});
}
private int isExist(int id)
{
List <Item> cart = SessionsHelper.GetObjectFromJson <List <Item> >(HttpContext.Session, "cart");
for (int i = 0; i < cart.Count; i++)
{
if (cart[i].Product.Id.Equals(id))
{
return(i);
}
}
return(-1);
}
private void FillGrid()
{
dgvProgramList.Rows.Clear();
foreach (var session in SessionsHelper.GetSessionsModelList())
{
int row = dgvProgramList.Rows.Add();
dgvProgramList.Rows[row].Cells[0].Value = session.SessionID;
dgvProgramList.Rows[row].Cells[1].Value = session.Name;
dgvProgramList.Rows[row].Cells[2].Value = session.StartDate.ToString("dd MMMM yyyy");
dgvProgramList.Rows[row].Cells[3].Value = session.EndDate.ToString("dd MMMM yyyy");
row++;
}
}
private void ApplyGuidesPopup(object Parameters)
{
int sres = SessionsHelper.GuidesItemSave(new Cars()
{
Id = _carsId,
INomer = CarsINomer,
SNomer = CarsSNomer,
CarTypesId = CarsCarTypesId,
EnterprisesId = CarsEnterprisesId
});
RaiseRequestClose(new DialogResult(sres > 0 ? ButtonResult.OK : ButtonResult.No));
}
private void ApplyGuidesPopup(object Parameters)
{
int sres = SessionsHelper.GuidesItemSave(new Routes()
{
Id = _routesId,
Name = RoutesName,
Nomer = RoutesNomer,
LineName = RoutesLineName,
BackName = RoutesBackName,
EnterprisesId = RoutesEnterprisesId
});
RaiseRequestClose(new DialogResult(sres > 0 ? ButtonResult.OK : ButtonResult.No));
}
private void ApplyGuidesPopup(object Parameters)
{
int sres = SessionsHelper.GuidesItemSave(new Workers()
{
Id = _workersId,
Name = WorkersName,
FirstName = WorkersFirstName,
LastName = WorkersLastName,
EnterprisesId = WorkersEnterprisesId,
PostsId = WorkersPostsId
});
RaiseRequestClose(new DialogResult(sres > 0 ? ButtonResult.OK : ButtonResult.No));
}
private void GuidesEditItem(object SelectedItem)
{
DialogParameters param = new DialogParameters
{
{ "Item", SelectedItem }
};
_currentDialogService.ShowDialog(GuidesMenuSelectedItem.DialogName, param, r =>
{
if (r.Result == ButtonResult.OK)
{
GuidesDataItems = SessionsHelper.GetDataGridGuidesItems(GuidesMenuSelectedItem);
}
});
}
private void GuidesDeleteItem(object SelectedItem)
{
DialogParameters param = new DialogParameters
{
{ "message", "Удалить выбранный элемент?" }
};
_currentDialogService.ShowDialog("MessageBox", param, r =>
{
if (r.Result == ButtonResult.OK)
{
SessionsHelper.GuidesItemDelete(SelectedItem as IGuidesItem);
GuidesDataItems = SessionsHelper.GetDataGridGuidesItems(GuidesMenuSelectedItem);
}
});
}
private void BtnCreate_Click(object sender, EventArgs e)
{
epUserName.Clear();
bool check1 = SessionsHelper.ControlValidate(txtUserName, "Lütfen User Name Giriniz.", epUserName);
epPassword.Clear();
bool check2 = SessionsHelper.ControlValidate(txtEnterPassword, "Lütfen Password Giriniz.", epPassword);
if (txtEnterPassword.Text.Trim() != txtConfirmPassword.Text.Trim())
{
epConfirmPass.Clear();
epConfirmPass.SetError(txtConfirmPassword, "Şifreler eşleşmiyor!");
return;
}
if (check1 && check2)
{
if (!UsersHelper.HaveUserID(txtUserName.Text.ToLower()))
{
UserPrivileges up = new UserPrivileges();
up.StaffID = StaffsHelper.GetByName(cmbSelectUser.SelectedItem.ToString());
up.Configuration = Convert.ToInt32(chkConfiguration.Checked);
up.Book = Convert.ToInt32(chkBook.Checked);
up.Report = Convert.ToInt32(chkReport.Checked);
up.Staff = Convert.ToInt32(chkStaff.Checked);
up.IssueBook = Convert.ToInt32(chkIssueBook.Checked);
up.Gsm = Convert.ToInt32(chkGSM.Checked);
up.Student = Convert.ToInt32(chkStudent.Checked);
up.ReturnBook = Convert.ToInt32(chkReturnBook.Checked);
up.Email = Convert.ToInt32(chkEmail.Checked);
UserPrivilegesHelper.Add(up);
Users u = new Users();
u.StaffID = StaffsHelper.GetByName(cmbSelectUser.SelectedItem.ToString());
u.UserName = txtUserName.Text;
u.Password = txtEnterPassword.Text;
UsersHelper.Add(u);
MessageBox.Show("Üye Ekleme Başarılı", "Library Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Eklemek istediğiniz User Name sistemde mevcuttur.", "Library Management System", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void GuidesMenuNavigatorSelectedItem(object MenuItem)
{
if (MenuItem is MenuNavigatorItem)
{
var _currentMenuItem = MenuItem as MenuNavigatorItem;
DataGridColumns = SessionsHelper.GetDataGridGuidesColumns(_currentMenuItem);
GuidesDataItems = SessionsHelper.GetDataGridGuidesItems(_currentMenuItem);
GuidesName = _currentMenuItem.Text;
if (GuidesDataItems != null)
{
if (GuidesDataItems.Count > 0)
{
GuidesDataSelectedItems = GuidesDataItems[0];
}
}
}
}
private void btnEdit_Click(object sender, EventArgs e)
{
if (dgvProgramList.Rows.Count > 0)
{
if (dgvProgramList.SelectedRows.Count == 1)
{
int selectIndex = dgvProgramList.CurrentRow.Index;
var sessionID = dgvProgramList.Rows[selectIndex].Cells[0].Value;
var s = SessionsHelper.GetById(Convert.ToInt32(sessionID));
txtSessionName.Text = Convert.ToString(s.Name);
dtpStartDate.Value = Convert.ToDateTime(s.StartDate);
dtpEndDate.Value = Convert.ToDateTime(s.EndDate);
EnableComponent();
}
}
}
private void FillGrid()
{
dgvStudentList.Rows.Clear();
foreach (var student in StudentsHelper.GetActiveStudentsList())
{
int row = dgvStudentList.Rows.Add();
dgvStudentList.Rows[row].Cells[0].Value = student.StudentID;
dgvStudentList.Rows[row].Cells[1].Value = student.Name;
dgvStudentList.Rows[row].Cells[2].Value = student.TCNO;
dgvStudentList.Rows[row].Cells[3].Value = student.EnrollNo;
dgvStudentList.Rows[row].Cells[4].Value = SessionsHelper.GetByNameFromID(student.SessionID);
dgvStudentList.Rows[row].Cells[5].Value = DepartmentsHelper.GetByNameFromID(student.DepartmentID);
dgvStudentList.Rows[row].Cells[6].Value = ProgramsHelper.GetByNameFromID(student.ProgramID);
dgvStudentList.Rows[row].Cells[7].Value = student.RegisterDate.ToString("dd MMMM yyyy");
dgvStudentList.Rows[row].Cells[8].Value = student.Address;
dgvStudentList.Rows[row].Cells[9].Value = student.ContactNo;
dgvStudentList.Rows[row].Cells[10].Value = StaffsHelper.GetByNameFromID(student.StaffID);
row++;
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
epProgram.Clear();
bool check = SessionsHelper.ControlValidate(txtProgramName, "Lütfen Program İsmini Giriniz.", epProgram);
if (check)
{
int selectIndex = dgvProgramList.CurrentRow.Index;
var programID = dgvProgramList.Rows[selectIndex].Cells[0].Value;
var p = ProgramsHelper.GetById(Convert.ToInt32(programID));
p.Name = txtProgramName.Text.Trim();
ProgramsHelper.Update(p);
MessageBox.Show("Program güncelleme başarılı", "Library Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
ClearForm();
FillGrid();
DisableComponent();
}
}
private void BtnUpdate_Click(object sender, EventArgs e)
{
ep.Clear();
if (txtStudentName.Text.Trim().Length == 0)
{
ep.SetError(txtStudentName, "Öğrenci adı boş bırakılamaz!");
txtStudentName.Focus();
return;
}
if (txtTCNO.Text.Trim().Length == 0)
{
ep.SetError(txtTCNO, "TC NO boş bırakılamaz!");
txtTCNO.Focus();
return;
}
if (txtEnrollNo.Text.Trim().Length == 0)
{
ep.SetError(txtEnrollNo, "Enroll No boş bırakılamaz!");
txtEnrollNo.Focus();
return;
}
if (txtAddress.Text.Trim().Length == 0)
{
ep.SetError(txtAddress, "Adres boş bırakılamaz!");
txtAddress.Focus();
return;
}
if (txtContactNo.Text.Trim().Length == 0)
{
ep.SetError(txtContactNo, "Telefon No boş bırakılamaz!");
txtContactNo.Focus();
return;
}
if (txtTCNO.Text.Trim().Length != 11)
{
MessageBox.Show("TC No 11 hanali olmalıdır.", "Library Management System", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (txtContactNo.Text.Trim().Length < 9 || txtContactNo.Text.Trim().Length > 14)
{
MessageBox.Show("Lütfen geçerli bir telefon numarası giriniz!", "Library Management System", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
int selectIndex = dgvStudentList.CurrentRow.Index;
var studentID = dgvStudentList.Rows[selectIndex].Cells[0].Value;
if (!StudentsHelper.HaveContactNo(txtContactNo.Text, Convert.ToInt32(studentID)) &&
!StudentsHelper.HaveEnrollNo(txtEnrollNo.Text, Convert.ToInt32(studentID)) &&
!StudentsHelper.HaveTCNO(txtTCNO.Text, Convert.ToInt32(studentID)))
{
var s = StudentsHelper.GetById(Convert.ToInt32(studentID));
s.SessionID = SessionsHelper.GetByName(cmbSession.SelectedItem.ToString());
s.DepartmentID = DepartmentsHelper.GetByName(cmbDepartment.SelectedItem.ToString());
s.ProgramID = ProgramsHelper.GetByName(cmbProgram.SelectedItem.ToString());
s.Name = txtStudentName.Text;
s.Gender = cmbGender.SelectedIndex;
s.Address = txtAddress.Text;
s.EnrollNo = txtEnrollNo.Text;
s.TCNO = txtTCNO.Text;
s.ContactNo = txtContactNo.Text;
StudentsHelper.Update(s);
MessageBox.Show("Öğrenci Güncelleme Başarılı", "Library Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
cmbSession.SelectedIndex = 0;
cmbDepartment.SelectedIndex = 0;
cmbProgram.SelectedIndex = 0;
txtStudentName.Text = string.Empty;
txtTCNO.Text = string.Empty;
cmbGender.SelectedIndex = 0;
txtEnrollNo.Text = string.Empty;
txtAddress.Text = string.Empty;
txtContactNo.Text = string.Empty;
ClearForm();
FillGrid();
DisableComponent();
}
else
{
MessageBox.Show("Girdiğiniz TC, Enroll veya Telefon numarası sistemde kayıtlıdır!", "Library Management System", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
ep.Clear();
if (txtStudentName.Text.Trim().Length == 0)
{
ep.SetError(txtStudentName, "Öğrenci adı boş bırakılamaz!");
txtStudentName.Focus();
return;
}
if (txtTCNO.Text.Trim().Length == 0)
{
ep.SetError(txtTCNO, "TC NO boş bırakılamaz!");
txtTCNO.Focus();
return;
}
if (txtEnrollNo.Text.Trim().Length == 0)
{
ep.SetError(txtEnrollNo, "Enroll No boş bırakılamaz!");
txtEnrollNo.Focus();
return;
}
if (txtAddress.Text.Trim().Length == 0)
{
ep.SetError(txtAddress, "Adres boş bırakılamaz!");
txtAddress.Focus();
return;
}
if (txtContactNo.Text.Trim().Length == 0)
{
ep.SetError(txtContactNo, "Telefon No boş bırakılamaz!");
txtContactNo.Focus();
return;
}
if (txtTCNO.Text.Trim().Length != 11)
{
MessageBox.Show("TC No 11 hanali olmalıdır.", "Library Management System", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (txtContactNo.Text.Trim().Length < 9 || txtContactNo.Text.Trim().Length > 14)
{
MessageBox.Show("Lütfen geçerli bir telefon numarası giriniz!", "Library Management System", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (!StudentsHelper.HaveTCNO(txtTCNO.Text) && !StudentsHelper.HaveEnrollNo(txtEnrollNo.Text) && !StudentsHelper.HaveContactNo(txtEnrollNo.Text))
{
Students s = new Students();
s.SessionID = SessionsHelper.GetByName(cmbSession.SelectedItem.ToString());
s.DepartmentID = DepartmentsHelper.GetByName(cmbDepartment.SelectedItem.ToString());
s.ProgramID = ProgramsHelper.GetByName(cmbProgram.SelectedItem.ToString());
s.StaffID = _staffID;
s.Name = txtStudentName.Text;
s.TCNO = txtTCNO.Text;
s.Status = 1;
s.Gender = cmbGender.SelectedIndex;
s.EnrollNo = txtEnrollNo.Text;
s.Address = txtAddress.Text;
s.ContactNo = txtContactNo.Text;
s.RegisterDate = DateTime.Now;
StudentsHelper.Add(s);
MessageBox.Show("Öğrenci Ekleme Başarılı", "Library Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
cmbSession.SelectedIndex = 0;
cmbDepartment.SelectedIndex = 0;
cmbProgram.SelectedIndex = 0;
txtStudentName.Text = string.Empty;
txtTCNO.Text = string.Empty;
cmbGender.SelectedIndex = 0;
txtEnrollNo.Text = string.Empty;
txtAddress.Text = string.Empty;
txtContactNo.Text = string.Empty;
FillGrid();
}
else
{
MessageBox.Show("Girdiğiniz TC, Enroll veya Telefon numarası sistemde kayıtlıdır.", "Library Management System", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
