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();
}
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();
}
protected void btn_submit_Click(object sender, EventArgs e)
{
string IP = GetVisitorIpAddress();
Department_tbl tblDept = new Department_tbl();
Tuple<Department_tbl, UniversityEntities> tuple = new Tuple<Department_tbl, UniversityEntities>(null, null);
if (btn_submit.Text == "Submit")
{
try
{
tblDept.CenterID = 1;
tblDept.DeptRoomID = Convert.ToInt32(txtbx_roomid.Text);
tblDept.DeptName = txtbx_deptname.Text;
tblDept.DeptDesc = txtbx_desc.Text;
tblDept.IsBitDeleted = false;
tblDept.CreatedBy = "Admin";
tblDept.CreatedDate = Convert.ToDateTime(System.DateTime.Now);
tblDept.CreatedIP = IP;
int deptid = ManageDepartmentBAL.SaveDepartment(tblDept);
lblmsg.Text = "Department added sucessfully!!!";
lblmsg.ForeColor = System.Drawing.ColorTranslator.FromHtml("#ff6230");
Clear();
}
catch
{
//Exception
}
finally
{
BindGrid(gvdept.PageSize, gvdept.PageIndex);
}
}
else if (btn_submit.Text == "Update")
{
try
{
tblDept.DeptID = Convert.ToInt32(lbldeptid.Text);
tblDept.DeptRoomID = Convert.ToInt32(txtbx_roomid.Text);
tblDept.DeptName = txtbx_deptname.Text;
tblDept.DeptDesc = txtbx_desc.Text;
tblDept.CreatedBy = lblcreator.Text;
tblDept.CreatedDate = Convert.ToDateTime(lblcreatedate.Text);
tblDept.CreatedIP = lblCreateIP.Text;
tblDept.ModifiedBy = "Admin";
tblDept.ModifiedDate = Convert.ToDateTime(System.DateTime.Now);
tblDept.ModifiedIP = IP;
int deptId = ManageDepartmentBAL.UpdateDept(tblDept);
lblmsg.Text = "Record Updated Sucessfully";
lblmsg.ForeColor = System.Drawing.ColorTranslator.FromHtml("#ff6230");
Clear();
btn_submit.Text = "Submit";
}
catch
{
//Exception
}
finally
{
BindGrid(gvdept.PageSize, gvdept.PageIndex);
}
}
}