protected void Update_Click(object sender, EventArgs e)
{
tblJobTitle = adpJobTitle.GetData();
Cache["tblJobTitle"] = tblJobTitle;
if (string.IsNullOrEmpty(txtJobTitleNumber.Text))
{
lblErrorMessage.Text = "Please Insert the Job Title Number";
lblErrorMessage.ForeColor = System.Drawing.Color.Red;
}
else
{
if (int.Parse(ddlDepartment.SelectedValue) <= 0)
{
lblErrorMessage.Text = "Please Select a Department";
lblErrorMessage.ForeColor = System.Drawing.Color.Red;
}
else
{
if (string.IsNullOrEmpty(txtJobTitle.Text))
{
lblErrorMessage.Text = "Please Enter a Job Title";
lblErrorMessage.ForeColor = System.Drawing.Color.Red;
}
else
{
updateRow();
}
}
}
}
private void loadFields()
{
int id = int.Parse(txtJobTitleNumber.Text);
tblJobTitle = adpJobTitle.GetDataBy(id);
Cache["tblJobTitle"] = tblJobTitle;
var row = tblJobTitle;
if (row.Count > 0)
{
if (row != null)
{
string name = row[0].JobTitleName.ToString();
txtJobTitle.Text = name.Trim();
int deptid = row[0].JobDepartment;
ddlDepartment.SelectedValue = deptid.ToString();
}
}
else
{
lblErrorMessage.Text = " Department ID " + id + " is not found";
lblErrorMessage.ForeColor = System.Drawing.Color.Red;
}
}
private void loadJobTitle()
{
int deptId = int.Parse(ddlDept.SelectedValue);
tblJobTitle = adpJobTitle.GetDataByDepartment(deptId);
Cache["tblJobTitle"] = tblJobTitle;
ddlTitle.DataSource = tblJobTitle;
ddlTitle.DataTextField = "JobTitleName";
ddlTitle.DataValueField = "JobTitleId";
ddlTitle.DataBind();
ddlTitle.Items.Insert(0, new ListItem("Select a Job Title", "-1"));
}
private void insertJobTitle(string jobtitle, int dept)
{
tblJobTitle = adpJobTitle.GetData();
Cache["tblJobTitle"] = tblJobTitle;
int result = adpJobTitle.Insert(jobtitle, dept);
if (result == 1)
{
lblErrorMessage.Text = "Job Title Inserted ";
lblErrorMessage.ForeColor = System.Drawing.Color.Yellow;
txtJobTitle.Text = "";
ddlDepartment.SelectedIndex = -1;
}
else
{
lblErrorMessage.Text = "Job Title NOT Inserted";
lblErrorMessage.ForeColor = System.Drawing.Color.Red;
}
Refresh();
}
