public List <DepartmentInfo> getDepartment(DepartmentSeachCriteria _criteria)
{
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
List <DepartmentInfo> ListDepartment = DepartmentDataLayer.GetInstance().getDepartment(connection, _criteria);
return(ListDepartment);
}
}
public List <DepartmentInfo> getDepartment(SqlConnection connection, DepartmentSeachCriteria _criteria)
{
var result = new List <DepartmentInfo>();
using (var command = new SqlCommand("Select * " +
" from tbl_Department where 1 = 1 ", connection))
{
if (!string.IsNullOrEmpty(_criteria.DepartmentID))
{
command.CommandText += " and DepartmentID = @DepartmentID";
AddSqlParameter(command, "@DepartmentID", _criteria.DepartmentID, System.Data.SqlDbType.Int);
}
if (!string.IsNullOrEmpty(_criteria.DepartmentCode))
{
command.CommandText += " and DepartmentCode = @DepartmentCode";
AddSqlParameter(command, "@DepartmentCode", _criteria.DepartmentCode, System.Data.SqlDbType.NVarChar);
}
if (!string.IsNullOrEmpty(_criteria.DepartmentName))
{
command.CommandText += " and DepartmentName like N'%" + _criteria.DepartmentName + "%' ";
}
command.CommandText += " order by DepartmentID ";
WriteLogExecutingCommand(command);
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var info = new DepartmentInfo();
info.DepartmentID = GetDbReaderValue <int>(reader["DepartmentID"]);
info.DepartmentCode = GetDbReaderValue <string>(reader["DepartmentCode"]);
info.DepartmentName = GetDbReaderValue <string>(reader["DepartmentName"]);
info.Address = GetDbReaderValue <string>(reader["Address"]);
info.Phone = GetDbReaderValue <string>(reader["Phone"]);
info.Email = GetDbReaderValue <string>(reader["Email"]);
info.UserI = GetDbReaderValue <string>(reader["UserI"]);
info.InTime = GetDbReaderValue <DateTime?>(reader["InTime"]);
info.UserU = GetDbReaderValue <string>(reader["UserU"]);
info.UpdateTime = GetDbReaderValue <DateTime>(reader["UpdateTime"]);
info.SourceID = GetDbReaderValue <int>(reader["SourceID"]);
result.Add(info);
}
}
return(result);
}
}
public ActionMessage createDepartment(DepartmentInfo _department, string _userI)
{
ActionMessage ret = new ActionMessage();
if (_department.DepartmentCode.Trim() == string.Empty)
{
ret.isSuccess = false;
ret.err.msgCode = "Internal Error";
ret.err.msgString = "Chưa nhập Khoa phòng";
}
//else if (_department.SourceID == -1)
//{
//}
else
{
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
DepartmentSeachCriteria _criteria = new DepartmentSeachCriteria();
_criteria.DepartmentCode = _department.DepartmentCode;
var chkDepartmentInfo = getDepartment(_criteria);
if (chkDepartmentInfo.Count > 0)
{
ret.isSuccess = false;
ret.err.msgCode = "Internal Error";
ret.err.msgString = "Trùng mã Khoa phòng";
}
else
{
try
{
DepartmentDataLayer.GetInstance().InsertDepartment(connection, _department, _userI);
ret.isSuccess = true;
}
catch (Exception ex)
{
ret.isSuccess = false;
ret.err.msgCode = "Internal Error";
ret.err.msgString = ex.ToString();
}
}
}
}
return(ret);
}
public ActionMessage editDepartment(int id, DepartmentInfo _department, string _userU)
{
ActionMessage ret = new ActionMessage();
if (_department.DepartmentCode.Trim().Length == 0)
{
ret.isSuccess = false;
ret.err.msgCode = "Internal Error";
ret.err.msgString = "Chưa nhập mã Khoa phòng";
}
else
{
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
DepartmentSeachCriteria _criteria = new DepartmentSeachCriteria();
_criteria.DepartmentCode = _department.DepartmentCode;
var chkDepartmentInfo = getDepartment(_criteria);
if (chkDepartmentInfo.Count > 0)
{
ret.isSuccess = false;
ret.err.msgCode = "Internal Error";
ret.err.msgString = "Trùng mã Khoa phòng";
}
else
{
try
{
DepartmentDataLayer.GetInstance().UpdateDepartment(connection, _department, _userU);
ret.isSuccess = true;
}
catch (Exception ex)
{
ret.isSuccess = false;
ret.err.msgCode = "Internal Error";
ret.err.msgString = ex.ToString();
}
}
}
}
return(ret);
}
