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."); } }