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);
}
