protected void btnSearch_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtDeptNumber.Text))
{
lblErrorMessage.Text = "Please Insert the Department Number";
lblErrorMessage.ForeColor = System.Drawing.Color.Red;
}
else
{
int id = int.Parse(txtDeptNumber.Text);
tblDepartment = adpDepartment.GetDataBy(id);
Cache["tblDepartment"] = tblDepartment;
var row = tblDepartment;
if (row.Count > 0)
{
if (row != null)
{
string name = row[0].DepartmentName.ToString();
txtDeptName.Text = name.Trim();
}
}
else
{
lblErrorMessage.Text = " Department ID " + id + " is not found";
lblErrorMessage.ForeColor = System.Drawing.Color.Red;
}
}
}
private void RefreshDepartment()
{
if (Session["DepartmentId"] == null || Session["EmployeeId"] == null)
{
Response.Redirect("~/LoginForm.aspx");
}
tblDepartment = adpDepartment.GetData();
grdDepart.DataSource = tblDepartment;
grdDepart.DataBind();
}
protected void Update_Click(object sender, EventArgs e)
{
tblDepartment = adpDepartment.GetData();
int id = 0;
string depart = txtDeptName.Text;
if (string.IsNullOrEmpty(txtDeptNumber.Text))
{
lblErrorMessage.Text = "Please Insert the Department Number";
lblErrorMessage.ForeColor = System.Drawing.Color.Red;
}
else
{
if (string.IsNullOrEmpty(depart))
{
lblErrorMessage.Text = "Please Enter a Department Name";
lblErrorMessage.ForeColor = System.Drawing.Color.Red;
}
else
{
try
{
id = int.Parse(txtDeptNumber.Text);
}
catch (Exception ex)
{
lblErrorMessage.Text = "Please Enter a Department Number";
lblErrorMessage.ForeColor = System.Drawing.Color.Red;
}
int result = adpDepartment.Update(depart, id);
if (result == 1)
{
lblErrorMessage.Text = "Department Update ";
lblErrorMessage.ForeColor = System.Drawing.Color.Yellow;
txtDeptName.Text = "";
RefreshDepartment();
}
else
{
lblErrorMessage.Text = "Department NOT Update";
lblErrorMessage.ForeColor = System.Drawing.Color.Red;
}
}
}
}
private void insertDepartment(string dpt)
{
tblDepartment = adpDepartment.GetData();
int result = adpDepartment.Insert(dpt);
if (result == 1)
{
lblErrorMessage.Text = "Department Inserted ";
lblErrorMessage.ForeColor = System.Drawing.Color.Yellow;
txtDeptName.Text = "";
}
else
{
lblErrorMessage.Text = "Department NOT Inserted";
lblErrorMessage.ForeColor = System.Drawing.Color.Red;
}
RefreshDepartment();
}
public static void CreateDataBase(string dataBaseName, string userName, string pass)
{
using (var db = new SQLite.SQLiteConnection(dataBaseName, true))
{
db.CreateTable <TableDepartment>();
db.CreateTable <TableGroup>();
// db.CreateTable<TableGroupAdministarator>();
db.CreateTable <TableSubordination>();
// db.Execute("create view DepartmentView as select a.name, b.name_group, a.Date, a.wage from TableDepartment as a, TableGroup as b where a.group_id == b.id");
var insertAccount = new TableDepartment()
{
Name = userName,
Password = Action.Encrypt(pass),
Group_ID = 4,
Date = DateTime.Now
};
db.Insert(insertAccount);
db.Dispose();
}
}
private void Refresh()
{
if (Session["DepartmentId"] == null || Session["EmployeeId"] == null)
{
Response.Redirect("~/LoginForm.aspx");
}
tblDepartment = adpDepartment.GetData();
Cache["tblDepartment"] = tblDepartment;
ddlDepartment.DataSource = tblDepartment;
ddlDepartment.DataTextField = "DepartmentName";
ddlDepartment.DataValueField = "DepartmentId";
ddlDepartment.DataBind();
ddlDepartment.Items.Insert(0, new ListItem("Select a Department", "-1"));
tblJobEDepartment = adpJobEDepartment.GetDataMyData();
Cache["JobEDepartment"] = tblJobEDepartment;
grdJobTitle.DataSource = tblJobEDepartment;
grdJobTitle.DataBind();
}
private void RefreshDepartment()
{
if (Session["DepartmentId"] == null || Session["EmployeeId"] == null)
{
Response.Redirect("~/LoginForm.aspx");
}
tblDepartment = adpDepartment.GetData();
Cache["tblDepartment"] = tblDepartment;
ddlDept.DataSource = tblDepartment;
ddlDept.DataTextField = "DepartmentName";
ddlDept.DataValueField = "DepartmentId";
ddlDept.DataBind();
ddlDept.Items.Insert(0, new ListItem("Select a Department", "-1"));
ddlProvinceE.Items.Add("ALBERTA - AB");
ddlProvinceE.Items.Add("BRITISH COLUMBIA -BC");
ddlProvinceE.Items.Add("MANITOBA - MB");
ddlProvinceE.Items.Add("NEW BRUNSWICK -NB");
ddlProvinceE.Items.Add("NEWFOUNDLAND and LABRADOR - NL");
ddlProvinceE.Items.Add("NORTHWEST TERRITORIES -NT");
ddlProvinceE.Items.Add("NOVA SCOTIA -NS");
ddlProvinceE.Items.Add("NUNAVUT - NU");
ddlProvinceE.Items.Add("ONTARIO - ON");
ddlProvinceE.Items.Add("PRINCE EDWARD ISLAND - PE");
ddlProvinceE.Items.Add("QUEBEC - QC");
ddlProvinceE.Items.Add("SASKATCHEWAN - SK");
ddlProvinceE.Items.Add("YUKON - YT");
ddlProvinceE.Items.Insert(0, new ListItem("Select a Province", "-1"));
rdbGender.SelectedIndex = 0;
rdbStatus.SelectedIndex = 0;
int year = int.Parse(DateTime.Now.ToString("yyyy"));
for (int i = year; i >= 1900; i--)
{
ddlDOBY.Items.Add(i.ToString());
}
for (int i = year + 1; i >= 1900; i--)
{
ddlStartdty.Items.Add(i.ToString());
}
ddlDOBM.Items.Add("January");
ddlDOBM.Items.Add("February");
ddlDOBM.Items.Add("March");
ddlDOBM.Items.Add("April");
ddlDOBM.Items.Add("May");
ddlDOBM.Items.Add("June");
ddlDOBM.Items.Add("July");
ddlDOBM.Items.Add("August");
ddlDOBM.Items.Add("September");
ddlDOBM.Items.Add("October");
ddlDOBM.Items.Add("November");
ddlDOBM.Items.Add("December");
ddlDOBM.Items.Insert(0, new ListItem("Month", "0"));
ddlStartdtm.Items.Add("January");
ddlStartdtm.Items.Add("February");
ddlStartdtm.Items.Add("March");
ddlStartdtm.Items.Add("April");
ddlStartdtm.Items.Add("May");
ddlStartdtm.Items.Add("June");
ddlStartdtm.Items.Add("July");
ddlStartdtm.Items.Add("August");
ddlStartdtm.Items.Add("September");
ddlStartdtm.Items.Add("October");
ddlStartdtm.Items.Add("November");
ddlStartdtm.Items.Add("December");
ddlStartdtm.Items.Insert(0, new ListItem("Month", "0"));
ddlStartdty.SelectedValue = year.ToString();
}
