protected void btnLogin_Click(object sender, EventArgs e)
{
try
{
var empno = txtEmpNum.Text.ToLower();
using (var context = new DatabaseContext())
{
if (string.IsNullOrWhiteSpace(txtEmpNum.Text) == true)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "sweetAlertInfo('" + "Please enter a username." + "');", true);
}
else
{
var selecteduser = context.Users.FirstOrDefault(c => c.EmployeeNumber.ToLower() == empno);
if (selecteduser != null)
{
if (selecteduser.Password == txtPass.Text)
{
Variables.EmployeeNumber = selecteduser.EmployeeNumber;
Variables.AccessType = selecteduser.AccessType;
Variables.deptNo = selecteduser.DepartmentId;
Variables.secNo = selecteduser.SectionId;
if (selecteduser.AccessType == "Supervisor")
{
#region Code for Supervisor
Session["EmpNo"] = selecteduser.EmployeeNumber;
Session["FullName"] = selecteduser.FullName;
Session["AccountType"] = "Supervisor";
string code = Variables.code;
if (string.IsNullOrWhiteSpace(Variables.checkOutCode) == true)
{
int dept = Variables.deptNo;
var userList = context.Users.Where(c => c.DepartmentId == dept).ToList();
var shopList = context.ShopTrainings.ToList();
List <ShopTraining> newShopList = new List <ShopTraining>();
newShopList.Clear();
foreach (var item in shopList)
{
var check = userList.FirstOrDefault(c => c.EmployeeNumber == item.EmployeeNumber);
if (check != null)
{
newShopList.Add(item);
}
}
if (string.IsNullOrWhiteSpace(code) != true)
{
var checkDuplicate = newShopList.FirstOrDefault(c => c.TrainingCode == code && c.EmployeeNumber == selecteduser.EmployeeNumber);
if (checkDuplicate == null)
{
ShopTraining newShopTraining = new ShopTraining()
{
EmployeeNumber = selecteduser.EmployeeNumber,
TrainingCode = code,
IsComfirmedByAdmin = false,
IsConfirmedByManger = false,
IsSubmitted = false,
SectionId = Variables.secNo
};
context.ShopTrainings.Add(newShopTraining);
context.SaveChanges();
Response.Redirect("~/Home/Supervisor/SupervisorList.aspx");
}
else
{
Response.Redirect("~/Home/Supervisor/SupervisorList.aspx");
}
}
else
{
Response.Redirect("~/Home/Supervisor/SupervisorList.aspx");
}
}
else
{
int dept = Variables.deptNo;
var userList = context.Users.Where(c => c.DepartmentId == dept).ToList();
var shopList = context.ShopTrainings.ToList();
List <ShopTraining> newShopList = new List <ShopTraining>();
newShopList.Clear();
foreach (var item in shopList)
{
var check = userList.FirstOrDefault(c => c.EmployeeNumber == item.EmployeeNumber);
if (check != null)
{
newShopList.Add(item);
}
}
var checkDuplicate = newShopList.FirstOrDefault(c => c.TrainingCode == code);
if (checkDuplicate != null)
{
var selectEmpCheck = newShopList.FirstOrDefault(c => c.EmployeeNumber == selecteduser.EmployeeNumber && c.TrainingCode == code);
if (selectEmpCheck != null)
{
Variables.checkOutCode = code;
Response.Redirect("~/Home/Supervisor/SupervisorNominate.aspx");
}
else
{
ShopTraining newShopTraining = new ShopTraining()
{
EmployeeNumber = selecteduser.EmployeeNumber,
TrainingCode = code,
IsComfirmedByAdmin = false,
IsConfirmedByManger = false,
IsSubmitted = false,
SectionId = Variables.secNo
};
context.ShopTrainings.Add(newShopTraining);
context.SaveChanges();
Variables.checkOutCode = code;
Response.Redirect("~/Home/Supervisor/SupervisorList.aspx");
}
}
else
{
ShopTraining newShopTraining = new ShopTraining()
{
EmployeeNumber = selecteduser.EmployeeNumber,
TrainingCode = code,
IsComfirmedByAdmin = false,
IsConfirmedByManger = false,
IsSubmitted = false,
SectionId = Variables.secNo
};
context.ShopTrainings.Add(newShopTraining);
context.SaveChanges();
Variables.checkOutCode = code;
Response.Redirect("~/Home/Supervisor/SupervisorNominate.aspx");
}
}
#endregion
}
else if (selecteduser.AccessType == "Manager")
{
#region Code for manager
//Session["EmpNo"] = selecteduser.EmployeeNumber;
//Session["FullName"] = selecteduser.FullName;
//Session["AccountType"] = "Manager";
//string code = Variables.code;
//if (string.IsNullOrWhiteSpace(Variables.checkOutCode) == true)
//{
// if (string.IsNullOrWhiteSpace(code) != true)
// {
// int dept = Variables.deptNo;
// var empList = context.Employees.Where(c => c.DepartmentId == dept).ToList();
// var shopList = context.ShopTrainings.ToList();
// List<ShopTraining> newShopList = new List<ShopTraining>();
// newShopList.Clear();
// foreach (var item in shopList)
// {
// var check = empList.FirstOrDefault(c => c.EmployeeNumber == item.EmployeeNumber);
// if (check != null)
// {
// newShopList.Add(item);
// }
// else
// {
// var checkUser = context.Users.FirstOrDefault(c => c.EmployeeNumber == item.EmployeeNumber);
// if (checkUser != null)
// {
// newShopList.Add(item);
// }
// }
// }
// var checkDuplicate = newShopList.FirstOrDefault(c => c.TrainingCode == code);
// if (checkDuplicate == null)
// {
// ShopTraining newShopTraining = new ShopTraining()
// {
// EmployeeNumber = selecteduser.EmployeeNumber,
// TrainingCode = code,
// IsComfirmedByAdmin = false,
// IsConfirmedByManger = false,
// IsSubmitted = false,
// };
// context.ShopTrainings.Add(newShopTraining);
// context.SaveChanges();
// }
// }
// Response.Redirect("~/Home/Manager/ManagerList.aspx");
//}
//else
//{
// int dept = Variables.deptNo;
// var empList = context.Employees.Where(c => c.DepartmentId == dept).ToList();
// var shopList = context.ShopTrainings.ToList();
// List<ShopTraining> newShopList = new List<ShopTraining>();
// newShopList.Clear();
// foreach (var item in shopList)
// {
// var check = empList.FirstOrDefault(c => c.EmployeeNumber == item.EmployeeNumber);
// if (check != null)
// {
// newShopList.Add(item);
// }
// else
// {
// var checkUser = context.Users.FirstOrDefault(c => c.EmployeeNumber == item.EmployeeNumber);
// if (checkUser != null)
// {
// newShopList.Add(item);
// }
// }
// }
// var checkDuplicate = newShopList.FirstOrDefault(c => c.TrainingCode == code);
// if (checkDuplicate == null)
// {
// ShopTraining newShopTraining = new ShopTraining()
// {
// EmployeeNumber = selecteduser.EmployeeNumber,
// TrainingCode = code,
// IsComfirmedByAdmin = false,
// IsConfirmedByManger = false,
// IsSubmitted = true,
// };
// context.ShopTrainings.Add(newShopTraining);
// context.SaveChanges();
// }
// Variables.checkOutCode = code;
// Response.Redirect("~/Home/Manager/ManagerNominate.aspx");
//}
#endregion
Session["EmpNo"] = selecteduser.EmployeeNumber;
Session["FullName"] = selecteduser.FullName;
Session["AccountType"] = "Manager";
Variables.checkOutCode = string.Empty;
Variables.code = string.Empty;
Variables.currentcmbSec = string.Empty;
Variables.selectedSecId = 0;
Variables.submitCode = string.Empty;
Variables.submitShopTrainingId = 0;
Response.Redirect("~/Home/Manager/ManagerList.aspx");
}
else if (selecteduser.AccessType == "Admin")
{
Session["EmpNo"] = selecteduser.EmployeeNumber;
Session["FullName"] = selecteduser.FullName;
Session["AccountType"] = "Admin";
//Response.Redirect("~/Admin Page/AdminReport.aspx");
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "sweetAlertWarning('" + "Invalid Password" + "');", true);
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "sweetAlertError('" + "Invalid User" + "');", true);
}
}
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "sweetAlertWarning('" + ex.Message + "');", true);
}
}
protected void lnkCheckout_Click(object sender, EventArgs e)
{
try
{
LinkButton clickedButton = (LinkButton)sender;
Variables.code = clickedButton.CommandName;
Variables.checkOutCode = clickedButton.CommandName;
string code = string.Empty;
string empNo = string.Empty;
using (var context = new DatabaseContext())
{
if (Session["EmpNo"] != null)
{
if (Session["AccountType"] == "Supervisor")
{
#region Supervisor
code = clickedButton.CommandName;
empNo = Session["EmpNo"].ToString().ToLower();
int dept = Variables.deptNo;
var userList = context.Users.Where(c => c.DepartmentId == dept).ToList();
var shopList = context.ShopTrainings.ToList();
List <ShopTraining> newShopList = new List <ShopTraining>();
newShopList.Clear();
foreach (var item in shopList)
{
var check = userList.FirstOrDefault(c => c.EmployeeNumber == item.EmployeeNumber);
if (check != null)
{
newShopList.Add(item);
}
}
var checkDuplicate = newShopList.FirstOrDefault(c => c.TrainingCode == code);
if (checkDuplicate != null)
{
var selectEmpCheck = newShopList.FirstOrDefault(c => c.EmployeeNumber.ToLower() == empNo && c.TrainingCode == code);
if (selectEmpCheck != null)
{
Variables.checkOutCode = clickedButton.CommandName;
if (selectEmpCheck.IsSubmitted == true)
{
Response.Redirect("~/Home/Supervisor/SupervisorStatus.aspx");
}
else
{
Response.Redirect("~/Home/Supervisor/SupervisorNominate.aspx");
}
}
else
{
ShopTraining newShopTraining = new ShopTraining()
{
EmployeeNumber = Session["EmpNo"].ToString(),
TrainingCode = code,
IsComfirmedByAdmin = false,
IsConfirmedByManger = false,
IsSubmitted = false,
SectionId = Variables.secNo
};
context.ShopTrainings.Add(newShopTraining);
context.SaveChanges();
Variables.checkOutCode = clickedButton.CommandName;
Response.Redirect("~/Home/Supervisor/SupervisorNominate.aspx");
}
}
else
{
ShopTraining newShopTraining = new ShopTraining()
{
EmployeeNumber = Session["EmpNo"].ToString(),
TrainingCode = code,
IsComfirmedByAdmin = false,
IsConfirmedByManger = false,
IsSubmitted = false,
SectionId = Variables.secNo
};
context.ShopTrainings.Add(newShopTraining);
context.SaveChanges();
Variables.checkOutCode = clickedButton.CommandName;
Response.Redirect("~/Home/Supervisor/SupervisorNominate.aspx");
}
#endregion
}
else if (Session["AccountType"] == "Manager")
{
#region Manager
code = clickedButton.CommandName;
empNo = Session["EmpNo"].ToString().ToLower();
int dept = Variables.deptNo;
var empList = context.Employees.Where(c => c.DepartmentId == dept).ToList();
var selectId = context.Sections.FirstOrDefault(c => c.SectionName == cmbSections.Text);
var checkDuplicate = context.ShopTrainings.FirstOrDefault(c => c.EmployeeNumber.ToLower() == empNo && c.TrainingCode == code && c.SectionId == selectId.SectionId);
if (selectId == null)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "sweetAlertInfo('" + "Please select a section first." + "');", true);
}
else
{
if (checkDuplicate != null)
{
Variables.checkOutCode = clickedButton.CommandName;
Variables.selectedSecId = selectId.SectionId;
if (checkDuplicate.IsSubmitted == true && checkDuplicate.IsConfirmedByManger == true)
{
Response.Redirect("~/Home/Manager/ManagerStatus.aspx");
}
else
{
Response.Redirect("~/Home/Manager/ManagerNominate.aspx");
}
}
else
{
ShopTraining newShopTraining = new ShopTraining()
{
EmployeeNumber = Session["EmpNo"].ToString(),
TrainingCode = code,
IsComfirmedByAdmin = false,
IsConfirmedByManger = false,
IsSubmitted = true,
SectionId = selectId.SectionId
};
context.ShopTrainings.Add(newShopTraining);
context.SaveChanges();
Variables.checkOutCode = clickedButton.CommandName;
Variables.selectedSecId = selectId.SectionId;
Response.Redirect("~/Home/Manager/ManagerNominate.aspx");
}
}
#endregion
}
else
{
Response.Redirect("~/Admin Page/AdminReport.aspx");
}
}
else
{
Response.Redirect("~/Home/Login.aspx");
}
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "sweetAlertWarning('" + ex.Message + "');", true);
}
}
