protected void DeleteDepartmentPerson(Object sender, CommandEventArgs e)
{
DepartmentPersonTableAdapters.un_ref_co_dept_peopleTableAdapter tableAdapter = new DepartmentPersonTableAdapters.un_ref_co_dept_peopleTableAdapter();
tableAdapter.Delete(int.Parse(e.CommandArgument.ToString()), loggedInUserId);
GridView1.DataBind();
SetInfoMessage(WebConstants.Messages.Information.RECORD_DELETED);
}
protected void UploadButton_Click(object sender, EventArgs e)
{
if (FileUploader.HasFile)
{
try
{
using (CsvReader csv = new CsvReader(new StreamReader(FileUploader.FileContent), true))
{
int count = 0;
while (csv.ReadNextRecord())
{
DepartmentPersonTableAdapters.un_ref_co_dept_peopleTableAdapter personTA = new DepartmentPersonTableAdapters.un_ref_co_dept_peopleTableAdapter();
personTA.Insert((int)Session[WebConstants.Session.REG_DEPT_ID], (int)Session[WebConstants.Session.REG_CO_ID],csv[0],
(int)Session[WebConstants.Session.REG_USER_ID], ParseBoolean(csv[1]), ParseBoolean(csv[2]), ParseBoolean(csv[3]));
count++;
}
SetInfoMessage(count + " people added to the system.");
}
}
catch(Exception ex)
{
SetErrorMessage("Error processing the file. Please check its contents. File should be CSV and in the format shown below");
}
}
else
{
SetErrorMessage("No file specified");
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (isValid(0))
{
DepartmentPersonTableAdapters.un_ref_co_dept_peopleTableAdapter tableAdapter = new DepartmentPersonTableAdapters.un_ref_co_dept_peopleTableAdapter();
tableAdapter.Insert(int.Parse(ddlDepartment.SelectedValue), loggedInUserCoId, tbName.Text, loggedInUserId,chkboxSupervisor.Checked,chkboxFirstAider.Checked,chkboxWarden.Checked);
GridView1.DataBind();
SetInfoMessage(WebConstants.Messages.Information.RECORD_SAVED);
}
//lbl
}
private void BindGrids()
{
try
{
DepartmentPersonTableAdapters.un_ref_co_dept_peopleTableAdapter ta = new DepartmentPersonTableAdapters.un_ref_co_dept_peopleTableAdapter();
gv1.DataSource = ta.GetDepartmentPersonByDeptId(int.Parse(ddlDepartment1.SelectedValue), int.Parse(ddlCompany1.SelectedValue));
gv1.DataBind();
gv2.DataSource = ta.GetDepartmentPersonByDeptId(int.Parse(ddlDepartment2.SelectedValue), int.Parse(ddlCompany2.SelectedValue));
gv2.DataBind();
HideTransferButtons();
}
catch
{
//this is needed as some time the ddls are not set.
}
}
protected void btnUpate_Click(object sender, EventArgs e)
{
int id = int.Parse(hfDeptPersonId.Value);
if (isValid(id))
{
DepartmentPerson.un_ref_co_dept_peopleRow dataRow = getDepartmentPerson(id);
if (dataRow != null)
{
DepartmentPersonTableAdapters.un_ref_co_dept_peopleTableAdapter tableAdapter = new DepartmentPersonTableAdapters.un_ref_co_dept_peopleTableAdapter();
tableAdapter.Update(int.Parse(ddlDepartment.SelectedValue), tbName.Text, dataRow.index_seq, loggedInUserId, dataRow.sequence,chkboxSupervisor.Checked,chkboxFirstAider.Checked,chkboxWarden.Checked);
GridView1.DataBind();
SetInfoMessage(WebConstants.Messages.Information.RECORD_SAVED);
}
btnAdd.Visible = true;
btnUpate.Visible = false;
tbName.Text = "";
chkboxSupervisor.Checked = false;
chkboxWarden.Checked = false;
chkboxFirstAider.Checked = false;
}
}
private bool isValid(int id)
{
DepartmentPersonTableAdapters.un_ref_co_dept_peopleTableAdapter tableAdapter = new DepartmentPersonTableAdapters.un_ref_co_dept_peopleTableAdapter();
IEnumerator iEnumerator = tableAdapter.GetDepartmentPersonByName(int.Parse(ddlDepartment.SelectedValue),loggedInUserCoId,tbName.Text,id).GetEnumerator();
if (iEnumerator.MoveNext())
{
SetErrorMessage(WebConstants.Messages.Error.ALREAD_EXISTS);
return false;
}
return true;
}
private DepartmentPerson.un_ref_co_dept_peopleRow getDepartmentPerson(int departmentPersonId)
{
DepartmentPerson.un_ref_co_dept_peopleRow dataRow = null;
DepartmentPersonTableAdapters.un_ref_co_dept_peopleTableAdapter tableAdapter = new DepartmentPersonTableAdapters.un_ref_co_dept_peopleTableAdapter();
IEnumerator iEnumerator = tableAdapter.GetDepartmentPersonByIdNCoId(departmentPersonId, loggedInUserCoId).GetEnumerator();
if (iEnumerator.MoveNext())
{
dataRow = (DepartmentPerson.un_ref_co_dept_peopleRow)iEnumerator.Current;
}
return dataRow;
}
