protected void Page_Load(object sender, EventArgs e)
{
string departmentID = Request.QueryString["departmentID"] as string;
if (departmentID == null)
{
Response.Redirect("Z_DepartmentDefault.aspx");
}
try
{
departmentDepartmentID = Convert.ToInt32(departmentID.Trim());
departmentHandler = new DepartmentHandler();
Department department = departmentHandler.GetDetails(departmentDepartmentID);
lblDepartmentID.Text = department.DepartmentID.ToString();
lblDividerFullName.Text = department.DividerFullName.ToString();
lblComputationTypeIDTitle.Text = department.ComputationTypeIDTitle.ToString();
lblMainOfficeTypeIDTitle.Text = department.MainOfficeTypeIDTitle.ToString();
lblAdjutancyTypeIDTitle.Text = department.AdjutancyTypeIDTitle.ToString();
lblComputationTypeID.Text = department.ComputationTypeID.ToString();
lblMainOfficeTypeID.Text = department.MainOfficeTypeID.ToString();
lblAdjutancyTypeID.Text = department.AdjutancyTypeID.ToString();
lblTotalEmployeeNumber.Text = department.TotalEmployeeNumber.ToString();
lblTotalContractualEmployeeNumber.Text = department.TotalContractualEmployeeNumber.ToString();
lblTotalPersonalScore.Text = department.TotalPersonalScore.ToString();
lblDividerNationalCode.Text = department.DividerNationalCode.ToString();
lblTitle.Text = department.Title.ToString();
}
catch (Exception)
{
Response.Redirect("Z_DepartmentDefault.aspx");
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
A_Handler = new DepartmentHandler();
A1 = new Department();
//A1.Dep_id = Convert.ToInt32(txtDep_id.Text);
A1.Reg_id = Convert.ToInt32(ddlReg_id.SelectedValue);
A1.Dep_name = txtDep_name.Text;
A1.Dep_code = txtDep_code.Text;
if (btnSubmit.Text == "Submit")
{
bool B = A_Handler.AddNewDepartment(A1);
if (B == true)
{
Label1.Text = "Record Inserted";
MSG = "Record Inserted";
}
else
{
Label1.Text = "Record Not Inserted";
MSG = "Record Not Inserted";
}
}
else if (btnSubmit.Text == "Update")
{
A1.Dep_id = Convert.ToInt32(txtDep_id.Text);
bool B = A_Handler.UpdateDepartment(A1);
if (B == true)
{
Label1.Text = "Record Updated";
MSG = "Record Not Updated";
}
else
{
Label1.Text = "Record Not Updated";
MSG = "Record Not Updated";
}
}
else if (btnSubmit.Text == "Delete")
{
A1.Dep_id = Convert.ToInt32(txtDep_id.Text);
bool B = A_Handler.DeleteDepartment(A1);
if (B == true)
{
Label1.Text = "Record Deleted";
MSG = "Record Deleted";
}
else
{
Label1.Text = "Record Not Deleted";
MSG = "Record Not Deleted";
}
}
//Response.Redirect("~/ADMIN/Department_list.aspx?msg="+MSG);
}
public void show_data(int ID)
{
A_Handler = new DepartmentHandler();
A1 = new Department();
A1 = A_Handler.GetDepartmentDetails(ID);
txtDep_id.Text = A1.Dep_id.ToString();
ddlReg_id.SelectedValue = A1.Reg_id.ToString();
txtDep_name.Text = A1.Dep_name.ToString();
txtDep_code.Text = A1.Dep_code.ToString();
btnSubmit.Text = "Update";
btnReset.Text = "Cancel";
if (Request.QueryString["action"] == "del")
{
Label1.Text = "Are U Sure, U want to Delete a Record ?";
txtDep_id.ReadOnly = false;
ddlReg_id.Enabled = false;
txtDep_name.ReadOnly = false;
txtDep_code.ReadOnly = false;
btnSubmit.Text = "Delete";
}
}
protected void Page_Load(object sender, EventArgs e)
{
lblResult.Text = string.Empty;
departmentHandler = new DepartmentHandler();
if (IsPostBack == false)
{
BindData();
}
}
protected void btnYES_Click(object sender, EventArgs e)
{
Department department = new Department();
department.ComputationTypeID = Convert.ToInt32(ddlComputationTypeID.SelectedValue);
department.MainOfficeTypeID = Convert.ToInt32(ddlMainOfficeTypeID.SelectedValue);
department.AdjutancyTypeID = Convert.ToInt32(ddlAdjutancyTypeID.SelectedValue);
department.TotalEmployeeNumber = Convert.ToInt32(txtTotalEmployeeNumber.Text);
department.TotalContractualEmployeeNumber = Convert.ToInt32(txtTotalContractualEmployeeNumber.Text);
department.DividerNationalCode = Convert.ToInt64(txtDividerNationalCode.Text);
department.Title = txtTitle.Text;
DepartmentHandler departmentHandler = new DepartmentHandler();
if (departmentHandler.Insert(department) > 0)
{
Response.Redirect("Z_DepartmentDefault.aspx");
}
}
protected void btnShow_Click(object sender, EventArgs e)
{
fld = cboSearch.SelectedValue.ToString();
txt = txtSearch.Text;
A_Handler = new DepartmentHandler();
sql = "select * from " + Tbl_Name + " where " + fld + " like '" + txt + "%' ";
//Grid1.DataSource = A_Handler.GetDepartmentList(sql);
//Grid1.DataBind();
SqlDataSource1.SelectCommand = sql;
SqlDataSource1.DataBind();
if (Grid1.Rows.Count > 0)
{
lblRec.Text = "Total Records : " + Grid1.Rows.Count.ToString();
}
else
{
lblRec.Text = "Record Not Found...";
}
}
protected void Page_Load(object sender, EventArgs e)
{
//lblResult.Text = string.Empty;
A_Handler = new DepartmentHandler();
//if (IsPostBack == false)
//{
// Grid1.DataSource = A_Handler.GetDepartmentList();
// Grid1.DataBind();
if (Grid1.Rows.Count > 0)
{
lblRec.Text = "Total Records : " + Grid1.Rows.Count.ToString();
}
else
{
lblRec.Text = "Record Not Found...";
}
//}
}
protected void Page_Load(object sender, EventArgs e)
{
DepartmentHandler departmentHandler = new DepartmentHandler();
List <Department> departmentList = departmentHandler.GetListAll();
DataTable departmentTable = new DataTable();
departmentTable.Columns.Add("DepartmentID");
if (departmentList != null)
{
foreach (Department department in departmentList)
{
departmentTable.Rows.Add(department.DepartmentID);
}
}
if (!IsPostBack)
{
ddlDepartmentID.DataSource = departmentTable;
ddlDepartmentID.DataTextField = "DepartmentID";
ddlDepartmentID.DataValueField = "DepartmentID";
ddlDepartmentID.DataBind();
}
MonthTypeHandler monthTypeHandler = new MonthTypeHandler();
List <MonthType> monthTypeList = monthTypeHandler.GetListAll();
DataTable monthTypeTable = new DataTable();
monthTypeTable.Columns.Add("MonthTypeID");
if (monthTypeList != null)
{
foreach (MonthType monthType in monthTypeList)
{
monthTypeTable.Rows.Add(monthType.MonthTypeID);
}
}
if (!IsPostBack)
{
ddlMonthTypeID.DataSource = monthTypeTable;
ddlMonthTypeID.DataTextField = "MonthTypeID";
ddlMonthTypeID.DataValueField = "MonthTypeID";
ddlMonthTypeID.DataBind();
}
YearTypeHandler yearTypeHandler = new YearTypeHandler();
List <YearType> yearTypeList = yearTypeHandler.GetListAll();
DataTable yearTypeTable = new DataTable();
yearTypeTable.Columns.Add("YearTypeID");
if (yearTypeList != null)
{
foreach (YearType yearType in yearTypeList)
{
yearTypeTable.Rows.Add(yearType.YearTypeID);
}
}
if (!IsPostBack)
{
ddlYearTypeID.DataSource = yearTypeTable;
ddlYearTypeID.DataTextField = "YearTypeID";
ddlYearTypeID.DataValueField = "YearTypeID";
ddlYearTypeID.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
ContractTypeHandler contractTypeHandler = new ContractTypeHandler();
List <ContractType> contractTypeList = contractTypeHandler.GetListAll();
DataTable contractTypeTable = new DataTable();
contractTypeTable.Columns.Add("ContractTypeID");
if (contractTypeList != null)
{
foreach (ContractType contractType in contractTypeList)
{
contractTypeTable.Rows.Add(contractType.ContractTypeID);
}
}
if (!IsPostBack)
{
ddlContractTypeID.DataSource = contractTypeTable;
ddlContractTypeID.DataTextField = "ContractTypeID";
ddlContractTypeID.DataValueField = "ContractTypeID";
ddlContractTypeID.DataBind();
}
DepartmentHandler departmentHandler = new DepartmentHandler();
List <Department> departmentList = departmentHandler.GetListAll();
DataTable departmentTable = new DataTable();
departmentTable.Columns.Add("DepartmentID");
if (departmentList != null)
{
foreach (Department department in departmentList)
{
departmentTable.Rows.Add(department.DepartmentID);
}
}
if (!IsPostBack)
{
ddlDepartmentID.DataSource = departmentTable;
ddlDepartmentID.DataTextField = "DepartmentID";
ddlDepartmentID.DataValueField = "DepartmentID";
ddlDepartmentID.DataBind();
}
RoleTypeHandler roleTypeHandler = new RoleTypeHandler();
List <RoleType> roleTypeList = roleTypeHandler.GetListAll();
DataTable roleTypeTable = new DataTable();
roleTypeTable.Columns.Add("RoleTypeID");
if (roleTypeList != null)
{
foreach (RoleType roleType in roleTypeList)
{
roleTypeTable.Rows.Add(roleType.RoleTypeID);
}
}
if (!IsPostBack)
{
ddlRoleTypeID.DataSource = roleTypeTable;
ddlRoleTypeID.DataTextField = "RoleTypeID";
ddlRoleTypeID.DataValueField = "RoleTypeID";
ddlRoleTypeID.DataBind();
}
}
