本文整理汇总了C#中DBFunctions.getalldepartments方法的典型用法代码示例。如果您正苦于以下问题：C# DBFunctions.getalldepartments方法的具体用法？C# DBFunctions.getalldepartments怎么用？C# DBFunctions.getalldepartments使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DBFunctions的用法示例。
在下文中一共展示了DBFunctions.getalldepartments方法的5个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
string pagename = Path.GetFileName(Request.PhysicalPath);
if (Session["admin"] != null)
{
string action = Request.QueryString["action"];
id = int.Parse(Request.QueryString["programmeid"]);
if (!IsPostBack)
{
DBFunctions db = new DBFunctions();
if (action == "Disable")
{
db.disableeprogmme(id);
Response.Redirect("ManagePrograms.aspx");
}
else if (action == "Enable")
{
db.Enableeprogmme(id);
Response.Redirect("ManagePrograms.aspx");
}
else if (action == "update")
{
DropDownDept.DataSource = db.getalldepartments();
DropDownDept.DataValueField = "ID";
DropDownDept.DataTextField = "Department";
DropDownDept.DataBind();
Program_tbl program = db.getprogram(id);
DropDownDept.SelectedValue = program.DeptID.ToString();
ProgrammeNametxt.Text = program.ProgramName;
dropdownSecondChoise.SelectedValue = program.SecondChoice.ToString();
Cuttofpointstxt.Text = program.CutoffPoints;
dropdownCampus.SelectedValue = program.HasCampus.ToString();
txtApplicationFee.Text = program.ApplicationFee;
txtAcceptenceFee.Text = program.AcceptenceFee;
txtFormCh.Text = program.FormCh;
txtFormNum.Text = program.FormNumber;
dropdownPrograms.SelectedValue = program.ProgramType;
dropdownJamb.SelectedValue = program.HasJambData.ToString();
dropdownOlevel.SelectedValue = program.HasOlevelResult.ToString();
dropdownPreviousRecord.SelectedValue = program.HasPreviousRecord.ToString();
dropdownBioData.SelectedValue = program.HasBioDataSection.ToString();
dropdownCbtSchedule.SelectedValue = program.HasCBTSchedule.ToString();
}
else if (action == "viewdetail")
{
}
}
}
else
{
Response.Redirect("Login.aspx?Redirecturl=" + pagename);
}
}示例2: setdepartment
public void setdepartment()
{
DBFunctions db = new DBFunctions();
DeptList.DataSource = db.getalldepartments();
DeptList.DataTextField = "Department";
DeptList.DataValueField = "ID";
DeptList.DataBind();
}示例3: setdepartments
private void setdepartments()
{
DBFunctions db = new DBFunctions();
Department_tbl dept = new Department_tbl { Department = "Select Department" };
var department=db.getalldepartments();
department.Add(dept);
department = department.OrderBy(x => x.ID).ToList();
DropDownDept.DataSource =department ;
ListItem item = new ListItem();
DropDownDept.DataTextField = "Department";
DropDownDept.DataValueField = "ID";
DropDownDept.DataBind();
}示例4: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
string pagename = Path.GetFileName(Request.PhysicalPath);
if (Session["admin"] != null)
{
DBFunctions db = new DBFunctions();
List<Program_tbl> programs = db.getprogramslist();
foreach (Program_tbl prg in programs)
{
programstbl.Text += "<tr><td>" + prg.ProgramName + "</td><td>" + prg.ProgramType + "</td><td>" + prg.Department_tbl.Department + "</td><td>" + prg.ApplicationFee + "</td><td>" + prg.AcceptenceFee + "</td><td>";
if (prg.Enable == true)
{
programstbl.Text += "<a href='#0' class='btn btn-danger btn-action Disable' data-id=" + prg.ID + ">Disable</a> ";
}
else
{
programstbl.Text += "<a href='#0' class='btn btn-primary btn-action Enable' data-id=" + prg.ID + ">Enable</a> ";
}
programstbl.Text += "<a href='#0' class='btn btn-primary btn-action update' data-id=" + prg.ID + ">Update</a></td></tr>";
}
DropDownDept.DataSource = db.getalldepartments();
ListItem item = new ListItem();
item.Text = "Select Department";
item.Value = "";
DropDownDept.Items.Add(item);
DropDownDept.DataTextField = "Department";
DropDownDept.DataValueField = "ID";
DropDownDept.DataBind();
}
else
{
Response.Redirect("Login.aspx?Redirecturl=" + pagename);
}
}示例5: btnaddEmployee_Click
protected void btnaddEmployee_Click(object sender, EventArgs e)
{
DBFunctions db = new DBFunctions();
DateTime dob=DateTime.Parse(dropdownyears.SelectedItem.Text+"-"+dropdownMonth.SelectedItem.Text+"-"+dropdownDay.SelectedItem.Text);
Employee_tbl employee = new Employee_tbl { Name = EmpNametxt.Text, Qualification = Qualificationtxt.Text, PhoneNumber = phonetxt.Text, Gender = dropdownGender.SelectedValue, Deptid = int.Parse(DeptList.SelectedValue), DateOFBirth = dob.ToShortDateString(), Email = Emailtxt.Text, CNIC = CNICtxt.Text, Address = Addresstxt.Text, City = Citytxt.Text, BankAccountNumber = Accounttxt.Text, Bank = Banktxt.Text,Designation=Designationtxt.Text,EmployeeType=int.Parse(DropDownEmpType.SelectedValue),Username=usernametxt.Text,Password=Passwordtxt.Text,IsFirstTime=0 };
employee = db.addEmployee(employee);
employee.Department_tbl = db.getalldepartments().Where(x => x.ID == int.Parse(DeptList.SelectedValue)).FirstOrDefault();
List<Employee_tbl> emp = new List<Employee_tbl>();
emp.Add(employee);
renderemployees(emp);
}