public DataTable GetDataTableHeirarchichal()
{
CostCentre[] tree = CostCentreDB.GetTree();
ArrayList list = Flatten(tree, "", "-1", 0);
DataTable dt = new DataTable();
dt.Columns.Add("costcentre_id");
dt.Columns.Add("descr");
dt.Columns.Add("parent_id");
dt.Columns.Add("parent_descr");
dt.Columns.Add("level");
foreach (Hashtable hashTable in list)
{
DataRow newRow = dt.NewRow();
newRow["costcentre_id"] = hashTable["costcentre_id"].ToString();
newRow["descr"] = hashTable["descr"].ToString();
newRow["parent_id"] = hashTable["parent_id"].ToString();
newRow["parent_descr"] = hashTable["parent_descr"].ToString();
newRow["level"] = hashTable["level"].ToString();
dt.Rows.Add(newRow);
}
return(dt);
}
public DataTable GetDataTableHWithNullParent()
{
DataTable dt = CostCentreDB.GetDataTable();
DataTable dt2 = new DataTable();
dt2.Columns.Add("costcentre_id");
dt2.Columns.Add("descr");
dt2.Columns.Add("parent_id");
DataRow newRow1 = dt2.NewRow();
newRow1["costcentre_id"] = -1;
newRow1["descr"] = "";
newRow1["parent_id"] = -1;
dt2.Rows.Add(newRow1);
foreach (DataRow row in dt.Rows)
{
DataRow newRow = dt2.NewRow();
newRow["costcentre_id"] = row["costcentre_id"];
newRow["descr"] = row["descr"];
newRow["parent_id"] = row["parent_id"];
dt2.Rows.Add(newRow);
}
return(dt2);
}
public static Staff LoadAll(DataRow row)
{
Staff staff = Load(row, "staff_");
staff.Person = PersonDB.Load(row, "person_");
staff.Person.Title = IDandDescrDB.Load(row, "title_title_id", "title_descr");
staff.Field = IDandDescrDB.Load(row, "field_field_id", "field_descr");
staff.StaffPosition = StaffPositionDB.Load(row, "staff_position_");
staff.CostCentre = CostCentreDB.Load(row, "cost_centre_");
return(staff);
}
protected void GrdCostCentre_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("Insert"))
{
DropDownList ddlParent = (DropDownList)GrdCostCentre.FooterRow.FindControl("ddlNewParent");
TextBox txtDescr = (TextBox)GrdCostCentre.FooterRow.FindControl("txtNewDescr");
CostCentreDB.Insert(txtDescr.Text, Convert.ToInt32(ddlParent.SelectedValue));
FillGrid();
}
}
public static CostCentre[] GetChildren(DataTable dt, string query)
{
DataRow[] foundRows = dt.Select(query);
CostCentre[] children = new CostCentre[foundRows.Length];
for (int i = 0; i < foundRows.Length; i++)
{
CostCentre cc = CostCentreDB.Load(foundRows[i]);
cc.Children = GetChildren(dt, "parent_id = " + cc.CostCentreID.ToString());
children[i] = cc;
}
return children;
}
public static System.Collections.Hashtable GetAllInHashtable(bool incSupportStaff = false, bool showIsFired = false, bool showIsExternal = false, bool showOnlyExternal = false)
{
System.Collections.Hashtable hash = new System.Collections.Hashtable();
DataTable tbl = StaffDB.GetDataTable_StaffInfo(incSupportStaff, showIsFired, showIsExternal, showOnlyExternal);
for (int i = 0; i < tbl.Rows.Count; i++)
{
Staff staff = Load(tbl.Rows[i]);
staff.Person = PersonDB.Load(tbl.Rows[i]);
staff.Person.Title = IDandDescrDB.Load(tbl.Rows[i], "title_id", "descr");
staff.Field = IDandDescrDB.Load(tbl.Rows[i], "field_field_id", "field_descr");
staff.StaffPosition = StaffPositionDB.Load(tbl.Rows[i], "staff_position_");
staff.CostCentre = CostCentreDB.Load(tbl.Rows[i], "cost_centre_");
hash[staff.StaffID] = staff;
}
return(hash);
}
public static StaffOfferings LoadAll(DataRow row)
{
StaffOfferings so = Load(row, "so_");
so.Offering = OfferingDB.Load(row, "o_");
so.Offering.OfferingType = IDandDescrDB.Load(row, "type_offering_type_id", "type_descr");
so.Offering.Field = IDandDescrDB.Load(row, "fld_field_id", "fld_descr");
so.Offering.AgedCarePatientType = IDandDescrDB.Load(row, "acpatientcat_aged_care_patient_type_id", "acpatientcat_descr");
so.Offering.OfferingInvoiceType = IDandDescrDB.Load(row, "invtype_offering_invoice_type_id", "invtype_descr");
so.Staff = StaffDB.Load(row, "staff_");
so.Staff.Person = PersonDB.Load(row, "person_");
so.Staff.Person.Title = IDandDescrDB.Load(row, "title_title_id", "title_descr");
so.Staff.Field = IDandDescrDB.Load(row, "field_field_id", "field_descr");
so.Staff.StaffPosition = StaffPositionDB.Load(row, "staff_position_");
so.Staff.CostCentre = CostCentreDB.Load(row, "cost_centre_");
return(so);
}
protected void GrdCostCentre_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Label lblId = (Label)GrdCostCentre.Rows[e.RowIndex].FindControl("lblId");
DropDownList ddlParent = (DropDownList)GrdCostCentre.Rows[e.RowIndex].FindControl("ddlParent");
TextBox txtDescr = (TextBox)GrdCostCentre.Rows[e.RowIndex].FindControl("txtDescr");
// make sure we are not parent up the line of parent_id
CostCentre[] tree = CostCentreDB.GetTree();
CostCentre thisNode = GetRoot(tree, Convert.ToInt32(lblId.Text));
if (ChildrenContains(thisNode, Convert.ToInt32(ddlParent.SelectedValue)))
{
lblErrorMessage.Visible = true;
lblErrorMessage.Text = "Can not add this parent because this is already a child";
return;
}
CostCentreDB.Update(Convert.ToInt32(lblId.Text), txtDescr.Text, Convert.ToInt32(ddlParent.SelectedValue));
GrdCostCentre.EditIndex = -1;
FillGrid();
}
protected void GrdStaff_RowDataBound(object sender, GridViewRowEventArgs e)
{
DataTable fields = DBBase.GetGenericDataTable(null, "Field", "field_id", "descr");
DataTable costcentres = CostCentreDB.GetDataTable();
DataTable positions = StaffPositionDB.GetDataTable();
DataTable dt = Session["externalstaffinfo_data"] as DataTable;
bool tblEmpty = (dt.Rows.Count == 1 && dt.Rows[0][0] == DBNull.Value);
if (!tblEmpty && e.Row.RowType == DataControlRowType.DataRow)
{
Label lblId = (Label)e.Row.FindControl("lblId");
DataRow[] foundRows = dt.Select("staff_id=" + lblId.Text);
DataRow thisRow = foundRows[0];
DropDownList ddlTitle = (DropDownList)e.Row.FindControl("ddlTitle");
if (ddlTitle != null)
{
DataTable titles = DBBase.GetGenericDataTable_WithWhereOrderClause(null, "Title", Convert.ToInt32(thisRow["title_id"]) == 0 ? "" : " title_id <> 0 ", " descr ", "title_id", "descr");
ddlTitle.DataSource = titles;
ddlTitle.DataTextField = "descr";
ddlTitle.DataValueField = "title_id";
ddlTitle.DataBind();
ddlTitle.SelectedValue = thisRow["title_id"].ToString();
}
DropDownList ddlGender = (DropDownList)e.Row.FindControl("ddlGender");
if (ddlGender != null)
{
if (thisRow["gender"].ToString() != "")
{
for (int i = ddlGender.Items.Count - 1; i >= 0; i--)
{
if (ddlGender.Items[i].Value == "")
{
ddlGender.Items.RemoveAt(i);
}
}
}
}
if (ddlTitle != null && ddlGender != null)
{
ddlTitle.Attributes["onchange"] = "title_changed_reset_gender('" + ddlTitle.ClientID + "','" + ddlGender.ClientID + "');";
}
DropDownList ddlDOB_Day = (DropDownList)e.Row.FindControl("ddlDOB_Day");
DropDownList ddlDOB_Month = (DropDownList)e.Row.FindControl("ddlDOB_Month");
DropDownList ddlDOB_Year = (DropDownList)e.Row.FindControl("ddlDOB_Year");
if (ddlDOB_Day != null && ddlDOB_Month != null && ddlDOB_Year != null)
{
ddlDOB_Day.Items.Add(new ListItem("--", "-1"));
ddlDOB_Month.Items.Add(new ListItem("--", "-1"));
ddlDOB_Year.Items.Add(new ListItem("----", "-1"));
for (int i = 1; i <= 31; i++)
{
ddlDOB_Day.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
for (int i = 1; i <= 12; i++)
{
ddlDOB_Month.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
for (int i = 1915; i <= DateTime.Today.Year; i++)
{
ddlDOB_Year.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
if (thisRow["dob"] != DBNull.Value)
{
DateTime dob = Convert.ToDateTime(thisRow["dob"]);
ddlDOB_Day.SelectedValue = dob.Day.ToString();
ddlDOB_Month.SelectedValue = dob.Month.ToString();
int firstYearSelectable = Convert.ToInt32(ddlDOB_Year.Items[1].Value);
int lastYearSelectable = Convert.ToInt32(ddlDOB_Year.Items[ddlDOB_Year.Items.Count - 1].Value);
if (dob.Year < firstYearSelectable)
{
ddlDOB_Year.Items.Insert(1, new ListItem(dob.Year.ToString(), dob.Year.ToString()));
}
if (dob.Year > lastYearSelectable)
{
ddlDOB_Year.Items.Add(new ListItem(dob.Year.ToString(), dob.Year.ToString()));
}
ddlDOB_Year.SelectedValue = dob.Year.ToString();
}
}
TextBox txtPwd = (TextBox)e.Row.FindControl("txtPwd");
if (txtPwd != null)
{
txtPwd.Attributes["value"] = thisRow["pwd"].ToString();
}
DropDownList ddlPosition = (DropDownList)e.Row.FindControl("ddlStaffPosition");
if (ddlPosition != null)
{
ddlPosition.DataSource = positions;
ddlPosition.DataTextField = "descr";
ddlPosition.DataValueField = "staff_position_id";
ddlPosition.DataBind();
ddlPosition.SelectedValue = thisRow["staff_position_id"].ToString();
}
DropDownList ddlField = (DropDownList)e.Row.FindControl("ddlField");
if (ddlField != null)
{
ddlField.DataSource = fields;
ddlField.DataTextField = "descr";
ddlField.DataValueField = "field_id";
ddlField.DataBind();
ddlField.SelectedValue = thisRow["field_id"].ToString();
}
DropDownList ddlCostCentre = (DropDownList)e.Row.FindControl("ddlCostCentre");
if (ddlCostCentre != null)
{
ddlCostCentre.DataSource = costcentres;
ddlCostCentre.DataTextField = "descr";
ddlCostCentre.DataValueField = "costcentre_id";
ddlCostCentre.DataBind();
ddlCostCentre.SelectedValue = thisRow["costcentre_id"].ToString();
}
bool is_fired = Convert.ToBoolean(thisRow["is_fired"]);
DropDownList ddlStatus = (DropDownList)e.Row.FindControl("ddlStatus");
if (ddlStatus != null)
{
if (is_fired)
{
ddlStatus.SelectedValue = "Inactive";
}
else
{
ddlStatus.SelectedValue = "Active";
}
}
Label lblIsFired = (Label)e.Row.FindControl("lblIsFired");
if (is_fired)
{
e.Row.ForeColor = System.Drawing.Color.Gray;
if (lblIsFired != null)
{
lblIsFired.ForeColor = System.Drawing.Color.Red;
}
}
Utilities.AddConfirmationBox(e);
if ((e.Row.RowState & DataControlRowState.Edit) > 0)
{
Utilities.SetEditRowBackColour(e, System.Drawing.Color.LightGoldenrodYellow);
}
}
if (e.Row.RowType == DataControlRowType.Footer)
{
DataTable titles = DBBase.GetGenericDataTable_WithWhereOrderClause(null, "Title", " title_id <> 0 ", " descr ", "title_id", "descr");
DropDownList ddlTitle = (DropDownList)e.Row.FindControl("ddlNewTitle");
ddlTitle.DataSource = titles;
ddlTitle.DataBind();
ddlTitle.SelectedIndex = Utilities.IndexOf(ddlTitle, "mr", "mr.");
}
}
