public static List <KhieuNaiTienTrinhDTO> GetListKhieuNaiTienTrinh(GetKhieuNaiTienTrinhDTO model)
{
var conn = Config.getConnectionKhieuNai();
//Create Command object
//SqlCommand nonqueryCommand = conn.CreateCommand();
try
{
// Open Connection
conn.Open();
string sql = "";
if (model.IDKhieuNai != "")
{
sql = "SELECT * FROM DT_KHIEUNAI_TIENTRINH WHERE (IDKHIEUNAI=@_IDKHIEUNAI)";
}
else
{
sql = "SELECT * FROM DT_KHIEUNAI_TIENTRINH WHERE (NGAYNHAP >= @_FromDate AND NGAYNHAP <= @_ToDate AND (NGUOINHAP = @_USERNAME || NGUOIXLYTIEP = @_USERNAME))";
}
SqlCommand cmd = new SqlCommand(sql, conn);
if (model.IDKhieuNai != "")
{
cmd.Parameters.AddWithValue("@_IDKHIEUNAI", model.IDKhieuNai);
}
else
{
cmd.Parameters.AddWithValue("@_USERNAME", model.UserName);
cmd.Parameters.AddWithValue("@_FromDate", model.FromDate);
cmd.Parameters.AddWithValue("@_ToDate", model.ToDate);
}
IDataReader reader = (IDataReader)cmd.ExecuteReader();
List <KhieuNaiTienTrinhDTO> result = new List <KhieuNaiTienTrinhDTO>();
if (reader != null)
{
result = DbExtensions.ToList <KhieuNaiTienTrinhDTO>(reader);
}
return(result);
}
catch (SqlException ex)
{
string err = string.Format("[ERR_KhieuNai] loi get du lieu [DT_KHIEUNAI_TIENTRINH] - IDKhieuNai={0},FromDate={1},ToDate={2},ex={3}", model.IDKhieuNai, model.FromDate, model.ToDate, ex.Message);
LogHelper.LogInfo(err, "KhieuNai");
return(new List <KhieuNaiTienTrinhDTO>());
}
finally
{
// Close Connection
conn.Close();
conn.Dispose();
}
}
public async Task <IHttpActionResult> GetListKhieuNaiTienTrinh(DateTime?fromdate, DateTime?todate, string idkhieunai, string username)
{
var model = new GetKhieuNaiTienTrinhDTO()
{
FromDate = fromdate,
ToDate = todate,
IDKhieuNai = idkhieunai,
UserName = username
};
try
{
await Task.Delay(100);
if (model.FromDate == null)
{
return(Ok(new ResponseCode {
code = "error", message = "Thời gian từ ngày không được bỏ trống"
}));
}
if (model.ToDate == null)
{
return(Ok(new ResponseCode {
code = "error", message = "Thời gian đến ngày không được bỏ trống"
}));
}
if (string.IsNullOrEmpty(model.IDKhieuNai))
{
return(Ok(new ResponseCode {
code = "error", message = "Mã khiếu nại không được bỏ trống"
}));
}
var data = KhieuNaiBLL.GetListKhieuNaiTienTrinh(model);
return(Ok(new ResponseCode {
code = "success", message = "Lấy danh sách khiếu nại tiến trình", data = data
}));
}
catch (Exception ex)
{
string err = string.Format("[ERR_KhieuNai] ex = {0},FromDate={1},ToDate={2},IDKhieuNai={3},UserName={4}", ex.Message, model.FromDate, model.ToDate, model.IDKhieuNai, model.UserName);
return(Ok(new ResponseCode {
code = "error", message = err
}));
}
}
public static List <KhieuNaiTienTrinhDTO> GetListKhieuNaiTienTrinh(GetKhieuNaiTienTrinhDTO model)
{
var conn = Config.getConnectionKhieuNai();
conn.Open();
string sql = "";
if (model.IDKhieuNai != "")
{
sql = "SELECT * FROM DT_KHIEUNAI_TIENTRINH WHERE (IDKHIEUNAI=@_IDKHIEUNAI)";
}
else
{
sql = "SELECT * FROM DT_KHIEUNAI_TIENTRINH WHERE (NGAYNHAP >= @_FromDate AND NGAYNHAP <= @_ToDate AND (NGUOINHAP = @_USERNAME OR NGUOIXLYTIEP = @_USERNAME))";
}
SqlCommand cmd = new SqlCommand(sql, conn);
if (model.IDKhieuNai != "")
{
cmd.Parameters.AddWithValue("@_IDKHIEUNAI", model.IDKhieuNai);
}
else
{
cmd.Parameters.AddWithValue("@_USERNAME", model.UserName);
cmd.Parameters.AddWithValue("@_FromDate", model.FromDate);
cmd.Parameters.AddWithValue("@_ToDate", model.ToDate);
}
IDataReader reader = (IDataReader)cmd.ExecuteReader();
List <KhieuNaiTienTrinhDTO> result = new List <KhieuNaiTienTrinhDTO>();
if (reader != null)
{
result = DbExtensions.ToList <KhieuNaiTienTrinhDTO>(reader);
}
conn.Close();
conn.Dispose();
return(result);
}
