protected void DropDowndepartment_SelectedIndexChanged(object sender, EventArgs e)
{
DBFunctions db = new DBFunctions();
if (DropDowndepartment.SelectedValue == "")
{
return;
}
int deptid = int.Parse(DropDowndepartment.SelectedValue);
var programs = db.getprogramslist().Where(x => x.DeptID == deptid).ToList();
Program_tbl prgrm = new Program_tbl {
ProgramName = "Select Programme"
};
programs.Add(prgrm);
DropDownprogramme.DataSource = programs.OrderBy(x => x.ID);
DropDownprogramme.DataTextField = "ProgramName";
DropDownprogramme.DataValueField = "ID";
DropDownprogramme.DataBind();
DropDownteacher.DataSource = db.getallemployee(0, db.getemployee_count(deptid), deptid);
DropDownteacher.DataTextField = "Name";
DropDownteacher.DataValueField = "ID";
DropDownteacher.DataBind();
}
protected void btnaddprogramme_Click(object sender, EventArgs e)
{
DBFunctions db = new DBFunctions();
Program_tbl prgram = new Program_tbl { ProgramName = ProgrammeNametxt.Text, SecondChoice = int.Parse(dropdownSecondChoise.SelectedValue), HasCampus = int.Parse(dropdownCampus.SelectedValue), ApplicationFee = txtApplicationFee.Text, FormNumber = txtFormCh.Text, ProgramType = dropdownPrograms.SelectedValue, HasJambData = int.Parse(dropdownJamb.SelectedValue), HasBioDataSection = int.Parse(dropdownBioData.SelectedValue), HasPreviousRecord = int.Parse(dropdownPreviousRecord.SelectedValue), HasCBTSchedule = int.Parse(dropdownCbtSchedule.SelectedValue), HasOlevelResult = int.Parse(dropdownOlevel.SelectedValue), Enable = true, DeptID = int.Parse(DropDownDept.SelectedValue), CutoffPoints = Cuttofpointstxt.Text, DateCreated = DateTime.Now.Date,AcceptenceFee=txtAcceptenceFee.Text,FormCh=txtFormCh.Text };
db.addprogramme(prgram);
}
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);
}
}
protected void btnaddprogramme_Click(object sender, EventArgs e)
{
DBFunctions db = new DBFunctions();
Program_tbl prgram = new Program_tbl {
ProgramName = ProgrammeNametxt.Text, SecondChoice = int.Parse(dropdownSecondChoise.SelectedValue), HasCampus = int.Parse(dropdownCampus.SelectedValue), ApplicationFee = txtApplicationFee.Text, FormNumber = txtFormCh.Text, ProgramType = dropdownPrograms.SelectedValue, HasJambData = int.Parse(dropdownJamb.SelectedValue), HasBioDataSection = int.Parse(dropdownBioData.SelectedValue), HasPreviousRecord = int.Parse(dropdownPreviousRecord.SelectedValue), HasCBTSchedule = int.Parse(dropdownCbtSchedule.SelectedValue), HasOlevelResult = int.Parse(dropdownOlevel.SelectedValue), Enable = true, DeptID = int.Parse(DropDownDept.SelectedValue), CutoffPoints = Cuttofpointstxt.Text, DateCreated = DateTime.Now.Date, AcceptenceFee = txtAcceptenceFee.Text, FormCh = txtFormCh.Text
};
db.addprogramme(prgram);
}
protected void DropDowndepartment_SelectedIndexChanged(object sender, EventArgs e)
{
DBFunctions db = new DBFunctions();
if(DropDowndepartment.SelectedValue==""){
return;
}
int deptid=int.Parse(DropDowndepartment.SelectedValue);
var programs = db.getprogramslist().Where(x => x.DeptID == deptid).ToList();
Program_tbl prgrm=new Program_tbl{ProgramName="Select Programme"};
programs.Add(prgrm);
DropDownprogramme.DataSource = programs.OrderBy(x=>x.ID);
DropDownprogramme.DataTextField = "ProgramName";
DropDownprogramme.DataValueField = "ID";
DropDownprogramme.DataBind();
DropDownteacher.DataSource = db.getallemployee(0, db.getemployee_count(deptid), deptid);
DropDownteacher.DataTextField = "Name";
DropDownteacher.DataValueField = "ID";
DropDownteacher.DataBind();
}
public void updateprogram(Program_tbl updateprog)
{
db = new CollegeERPDBEntities();
db.Program_tbl.Attach(updateprog);
// var progrm = db.Program_tbl.Where(x => x.ID == id).FirstOrDefault();
db.Entry(updateprog).State = EntityState.Modified;
db.SaveChanges();
}
public void addprogramme(Program_tbl program)
{
using (db = new CollegeERPDBEntities())
{
db.Program_tbl.Add(program);
db.SaveChanges();
}
}
