public ActionResult InsertUserDepartmentInfo()
{
try
{
DepartmentInfoModel departmentInfoModel = new DepartmentInfoModel();
using (var context = new JustHallAtumationEntities()) // To get Dropdown list for Department Name or Id
{
var user = context.Users.Where(x => x.UserName == User.Identity.Name).FirstOrDefault();
var std = context.Students.Where(x => x.UserId == user.UserId).FirstOrDefault();
if (std == null)
{
return(RedirectToAction("InsertStudentInfo", "InsertInformation"));
}
var add = context.DepartmentInfoes.Where(x => x.StudentId == std.StudentId).FirstOrDefault();
if (add != null)
{
return(RedirectToAction("InsertAddress"));
}
departmentInfoModel.department = context.Departments.ToList();
}
return(View(departmentInfoModel));
}
catch (Exception ex)
{
return(View(ex));
}
}
private void BindDepartment()
{
List <DepartmentInfoModel> source = new List <DepartmentInfoModel>();
var departments = _departmentService.GetAllDepartmentInfo().ToList();
foreach (var item in departments)
{
var department = new DepartmentInfoModel()
{
Id = item.Id,
Code = item.Code,
Name = item.Name,
Level = item.Level,
Description = item.Description,
Remarks = item.Remarks,
IsDeleted = item.IsDeleted,
ParentId = item.ParentId
};
var parentInfo = departments.Where(x => x.Id == department.ParentId).SingleOrDefault();
if (parentInfo != null)
{
department.ParentCode = parentInfo.Code;
department.ParentName = parentInfo.Name;
department.ParentLevel = parentInfo.Level;
}
else
{
department.ParentName = " / ";
}
source.Add(department);
}
this.treeList1.Initialize(source, "Id", "ParentId");
}
/// <summary>
/// 删除
/// </summary>
/// <param name="pc">pc</param>
/// <returns>影响的记录行数</returns>
public int DeleteMultiple(ParameterCollection pc)
{
int ret = 0;
DepartmentInfoModel departmentinfo = new DepartmentInfoModel();
ret = DbUtil.Current.DeleteMultiple(departmentinfo, pc);
return(ret);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="departmentinfo">实体</param>
/// <param name="pc">pc</param>
/// <returns>影响的记录行数</returns>
public int UpdateMultiple(DepartmentInfoModel departmentinfo, ParameterCollection pc)
{
int ret = 0;
departmentinfo.ModifiedBy = SessionUtil.Current.UserId;
departmentinfo.ModifiedOn = DateTime.Now;
ret = DbUtil.Current.UpdateMultiple(departmentinfo, pc);
return(ret);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="departmentinfo">实体</param>
/// <returns>影响的记录行数</returns>
public int Update(DepartmentInfoModel departmentinfo)
{
int ret = 0;
departmentinfo.ModifiedBy = SessionUtil.Current.UserId;
departmentinfo.ModifiedOn = DateTime.Now;
ret = DbUtil.Current.Update(departmentinfo);
return(ret);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="departmentid"></param>
/// <returns>影响的记录行数</returns>
public int Delete(string departmentid)
{
int ret = 0;
DepartmentInfoModel departmentinfo = new DepartmentInfoModel();
departmentinfo.DepartmentId = departmentid;
ret = DbUtil.Current.Delete(departmentinfo);
return(ret);
}
/// <summary>
/// 根据上级部门ID获取部门列表。
/// </summary>
/// <param name="parentId"></param>
/// <returns></returns>
private List <DepartmentInfoModel> GetDepartmentInfoByParentIdFromDatabase(string parentId)
{
List <DepartmentInfoModel> list = null;
string sql = null;
DataTable dt = null;
if (string.IsNullOrEmpty(parentId))
{
sql = @"
SELECT *
FROM
department_info
WHERE
parent_id IS NULL
ORDER BY
sort_order asc
";
dt = ExecuteDataTable(sql);
}
else
{
sql = @"
SELECT *
FROM
department_info
WHERE
parent_id = $parent_id$
ORDER BY
sort_order asc
";
ParameterCollection pc = new ParameterCollection();
pc.Add("parent_id", parentId);
dt = ExecuteDataTable(sql, pc);
}
if (dt != null && dt.Rows.Count > 0)
{
list = new List <DepartmentInfoModel>();
DepartmentInfoModel model = null;
for (int i = 0; i < dt.Rows.Count; i++)
{
model = new DepartmentInfoModel();
ModelConvertFrom(model, dt, i);
list.Add(model);
}
}
return(list);
}
/// <summary>
/// Get Department info By id.
/// </summary>
/// <param name="id"></param>
public void GetDepartment(int id)
{
SqlConnection departmentConnection = ConnectionSetup();
try
{
using (departmentConnection)
{
DepartmentInfoModel displayModel = new DepartmentInfoModel();
//define the SqlCommand object
SqlCommand cmd = new SqlCommand("spGetDepartment", departmentConnection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", id);
departmentConnection.Open();
SqlDataReader dr = cmd.ExecuteReader();
//check if there are records
if (dr.HasRows)
{
while (dr.Read())
{
displayModel.DepartmentId = Convert.ToInt32(dr["DEPTNO"]);
displayModel.DNAME = dr["DNAME"].ToString();
displayModel.Location = dr["LOC"].ToString();
//display retrieved record
Console.WriteLine("{0},{1},{2}", displayModel.DepartmentId, displayModel.DNAME, displayModel.Location);
Console.WriteLine("\n");
}
}
else
{
Console.WriteLine("No data found.");
}
//close data reader
dr.Close();
departmentConnection.Close();
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
finally
{
departmentConnection.Close();
}
}
/// <summary>
/// 根据条件获取实体集合
/// </summary>
/// <param name="pc">pc</param>
/// <param name="obc">obc</param>
/// <returns>实体</returns>
public List <DepartmentInfoModel> RetrieveMultiple(ParameterCollection pc, OrderByCollection obc)
{
List <DepartmentInfoModel> departmentinfos = new List <DepartmentInfoModel>();
DepartmentInfoModel departmentinfo = new DepartmentInfoModel();
DataTable dt = DbUtil.Current.RetrieveMultiple(departmentinfo, pc, obc);
for (int i = 0; i < dt.Rows.Count; i++)
{
departmentinfo = new DepartmentInfoModel();
departmentinfo.ConvertFrom(dt, i);
departmentinfos.Add(departmentinfo);
}
return(departmentinfos);
}
/// <summary>
/// 根据主键获取实体
/// </summary>
/// <param name="departmentid"></param>
/// <returns>实体</returns>
public DepartmentInfoModel Retrieve(string departmentid)
{
DepartmentInfoModel departmentinfo = new DepartmentInfoModel();
departmentinfo.DepartmentId = departmentid;
DataTable dt = DbUtil.Current.Retrieve(departmentinfo);
if (dt.Rows.Count < 1)
{
return(null);
}
departmentinfo.ConvertFrom(dt);
return(departmentinfo);
}
// To insert Student Department Information
public int InsertUserDepartmentInfo(DepartmentInfoModel model, string UserName)
{
using (var context = new JustHallAtumationEntities())
{
var user = context.Users.Where(x => x.UserName == UserName).FirstOrDefault(); // To get userId from UserName
var student = context.Students.Where(x => x.UserId == user.UserId).FirstOrDefault(); // To get Student Id from UserId
DepartmentInfo departmentInfo = new DepartmentInfo // One to one relationship with student to deparmentinfo table
{
DepartmentId = model.DepartmentId,
Session = model.Session,
Cgpa = model.Cgpa,
StudentId = student.StudentId
};
context.DepartmentInfoes.Add(departmentInfo);
context.SaveChanges();
return(departmentInfo.StudentId);
}
}
// 在此添加你的代码...
/// <summary>
/// 更新部门信息。
/// </summary>
/// <param name="departmentId"></param>
/// <param name="departmentName"></param>
/// <param name="description"></param>
/// <returns></returns>
public bool UpdateDepartmentById(string departmentId, string departmentName, string description)
{
bool result = false;
DepartmentInfoModel model = Retrieve(departmentId);
if (model != null)
{
model.DepartmentName = departmentName;
model.Description = description;
if (Update(model) > 0)
{
GetDepartmentTree(true);
result = true;
}
}
return(result);
}
public ActionResult InsertUserDepartmentInfo(DepartmentInfoModel model)
{
try
{
if (ModelState.IsValid)
{
int id = insertInfoOperation.InsertUserDepartmentInfo(model, User.Identity.Name);
if (id > 0) // Inserted successfully
{
ModelState.Clear();
ViewBag.Success = "Information Added!";
}
else // Insertion failed!
{
ViewBag.Success = "Failed!";
}
}
return(RedirectToAction("InsertAddress"));
}
catch (Exception ex)
{
return(View(ex));
}
}
