private DepartmentInfo GetModel() { DepartmentInfo deparmentInfo = new DepartmentInfo(); deparmentInfo.DepartmentCode = txtDepartmentCode.Text.Trim(); deparmentInfo.DepartmentName = txtDepartmentName.Text.Trim(); deparmentInfo.Introduction = txtDepartmentName.Text.Trim(); deparmentInfo.CreatedDate = DateTime.Now; deparmentInfo.ParentId = ParementDpartmentId; return deparmentInfo; }
public DepartmentInfo GetDepartmentInfoByDepartmentCode(string departmentCode) { DepartmentInfo departmentInfo = new DepartmentInfo(); DepartmentDal dal = new DepartmentDal(); DataSet ds = dal.GetDepartmentInfoByDepartmentCode(departmentCode); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { departmentInfo = ConvertToModel(ds.Tables[0].Rows[0]); } return departmentInfo; }
public DepartmentInfo GetDepartmentById(int departmentId) { DepartmentInfo departmentInfo = new DepartmentInfo(); DepartmentDal dal = new DepartmentDal(); DataSet ds = dal.GetDepartmentById(departmentId); if(ds!=null &&ds.Tables.Count>0&&ds.Tables[0].Rows.Count>0) { departmentInfo = ConvertToModel(ds.Tables[0].Rows[0]); } return departmentInfo; }
public void AddDepartment(DepartmentInfo departmentInfo) { string sql = " insert into U_Department (DepartmentCode,DepartmentName,Introduction,CreatedDate,ParentId)"; sql += " values(@DepartmentCode,@DepartmentName,@Introduction,@CreatedDate,@ParentId)"; List<SqlParameter> lstParamter = new List<SqlParameter>(); SqlParameter paramter = new SqlParameter("@DepartmentCode", departmentInfo.DepartmentCode); lstParamter.Add(paramter); paramter = new SqlParameter("@DepartmentName", departmentInfo.DepartmentName); lstParamter.Add(paramter); paramter = new SqlParameter("@Introduction", departmentInfo.Introduction); lstParamter.Add(paramter); paramter = new SqlParameter("@CreatedDate", departmentInfo.CreatedDate); lstParamter.Add(paramter); paramter = new SqlParameter("@ParentId", departmentInfo.ParentId); lstParamter.Add(paramter); SQLHelp.ExecuteNonQuery(sql, lstParamter); }
public void Update(DepartmentInfo departmentInfo) { string sql = " update U_Department set DepartmentCode=@DepartmentCode, DepartmentName=@DepartmentName where DepartmentId =@DepartmentId"; List<SqlParameter> lstParamter = new List<SqlParameter>(); SqlParameter paramter = new SqlParameter("@DepartmentCode", departmentInfo.DepartmentCode); lstParamter.Add(paramter); paramter = new SqlParameter("@DepartmentName", departmentInfo.DepartmentName); lstParamter.Add(paramter); paramter = new SqlParameter("@DepartmentId", departmentInfo.DepartmentId); lstParamter.Add(paramter); SQLHelp.ExecuteNonQuery(sql, lstParamter); }
public void AddDepartment(DepartmentInfo departmentInfo) { DepartmentDal dal = new DepartmentDal(); dal.AddDepartment(departmentInfo); }
private DepartmentInfo ConvertToModel(DataRow dr) { DepartmentInfo departmentInfo = new DepartmentInfo(); if (dr != null) { if (dr["DepartmentId"] is DBNull == false) { int departmentId = 0; int.TryParse(dr["DepartmentId"].ToString(), out departmentId); departmentInfo.DepartmentId = departmentId; } if (dr["DepartmentCode"] is DBNull == false) { departmentInfo.DepartmentCode = dr["DepartmentCode"].ToString(); } if (dr["DepartmentName"] is DBNull == false) { departmentInfo.DepartmentName = dr["DepartmentName"].ToString(); } if (dr["Introduction"] is DBNull == false) { departmentInfo.Introduction = dr["Introduction"].ToString(); } if (dr["CreatedDate"] is DBNull == false) { DateTime createdDate = DateTime.MinValue; DateTime.TryParse(dr["CreatedDate"].ToString(), out createdDate); departmentInfo.CreatedDate = createdDate; } if (dr["ParentId"] is DBNull == false) { int parentId = 0; int.TryParse(dr["ParentId"].ToString(), out parentId); departmentInfo.ParentId = parentId; } } return departmentInfo; }
public void Update(DepartmentInfo departmentInfo) { DepartmentDal dal = new DepartmentDal(); dal.Update(departmentInfo); }