public bool SaveDepartment(Department department)
{
SqlConnection connection = SqlHelper.CreateConnection();
try
{
string spName = "DepartmentSave";
ArrayList paramList = new ArrayList();
//Creating SqlParameter objects to fields in course
SqlParameter pID = new SqlParameter("@ID", SqlDbType.Int);
SqlParameter pName = new SqlParameter("@Name", SqlDbType.NVarChar);
SqlParameter pAbbreviation = new SqlParameter("@Abbreviation", SqlDbType.NVarChar);
SqlParameter pDescription = new SqlParameter("@Description", SqlDbType.NVarChar);
SqlParameter pIsActiveFL = new SqlParameter("@IsActiveFL", SqlDbType.Bit);
SqlParameter pCreatedBy = new SqlParameter("@CreatedBy", SqlDbType.Int);
SqlParameter pLastUpdatedBy = new SqlParameter("@LastUpdatedBy", SqlDbType.Int);
SqlParameter pCreationDate = new SqlParameter("@CreationDate", SqlDbType.DateTime);
SqlParameter pLastUpdatedDate = new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime);
pID.Direction = ParameterDirection.InputOutput;
pID.Value = department.DeptID;
pName.Value = department.Name;
pAbbreviation.Value = department.Abbreviation;
pDescription.Value = department.Description;
pIsActiveFL.Value = department.IsActiveFL;
pCreationDate.Value = department.CreationDate;
pLastUpdatedDate.Value = DateTime.UtcNow;
pCreatedBy.Value = department.CreatedBy;
pLastUpdatedBy.Value = department.LastUpdatedBy;
SqlHelper.ExecuteNonQuery(connection, CommandType.StoredProcedure, spName, pID, pName, pAbbreviation, pDescription,
pIsActiveFL, pCreationDate, pLastUpdatedDate, pCreatedBy, pLastUpdatedBy);
department.DeptID = Convert.ToInt32(pID.Value);
}
catch (SqlException sqlEx)
{
SqlHelper.CloseConnection(connection);
throw new Exception("DepartmentSave: " + sqlEx.ToString());
}
catch (Exception e)
{
SqlHelper.CloseConnection(connection);
throw new Exception("DepartmentSave: " + e.ToString());
}
finally
{
SqlHelper.CloseConnection(connection);
}
return true;
}
public bool SaveDepartment(Department department)
{
try
{
department.CreationDate = DateTime.UtcNow;
department.LastUpdatedDate = DateTime.UtcNow;
return GetDLDepartment().SaveDepartment(department);
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
}
public List<Department> getLuDepartment()
{
SqlConnection connection = SqlHelper.CreateConnection();
StringBuilder sb = new StringBuilder();
List<Department> departmentList = new List<Department>();
try
{
sb.Append("SELECT ID,Name,[Description],Abbreviation,IsActiveFL,CreatedBy,CreationDate,LastUpdatedBy,");
sb.Append("LastUpdatedDate FROM LuDepartment");
using (SqlDataReader dr = SqlHelper.ExecuteReader(connection, CommandType.Text, sb.ToString()))
{
while (dr.Read())
{
Department department = new Department();
department.DeptID = SqlHelper.ToInt32(dr["ID"]);
department.Name = SqlHelper.ToString(dr["Name"]);
department.Abbreviation = SqlHelper.ToString(dr["Abbreviation"]);
department.Description = SqlHelper.ToString(dr["Description"]);
department.IsActiveFL = SqlHelper.ToBool(dr["IsActiveFL"]);
department.CreationDate = SqlHelper.ToDateTime(dr["CreationDate"]);
department.LastUpdatedDate = SqlHelper.ToDateTime(dr["LastUpdatedDate"]);
department.CreatedBy = SqlHelper.ToInt32(dr["CreatedBy"]);
department.LastUpdatedBy = SqlHelper.ToInt32(dr["LastUpdatedBy"]);
departmentList.Add(department);
}
}
}
catch (SqlException sqlEx)
{
SqlHelper.CloseConnection(connection);
throw new Exception("getLuDepartment : " + sqlEx.ToString());
}
return departmentList;
}
public bool SaveDepartment(Department department)
{
BLDepartment blDept = new BLDepartment();
return blDept.SaveDepartment(department);
}
