public static List <KhieuNaiUserDTO> GetListKhieuNaiUser(GetKhieuNaiUserDTO model)
{
try
{
var conn = Config.getConnectionKhieuNai();
// Open Connection
conn.Open();
string sql = "SELECT * FROM DT_KHIEUNAI_USER WHERE IDKHIEUNAI = @_IDKHIEUNAI";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@_IDKHIEUNAI", model.IdKhieuNai);
IDataReader reader = (IDataReader)cmd.ExecuteReader();
List <KhieuNaiUserDTO> result = new List <KhieuNaiUserDTO>();
if (reader != null)
{
result = DbExtensions.ToList <KhieuNaiUserDTO>(reader);
}
conn.Close();
conn.Dispose();
return(result);
}
catch (SqlException ex)
{
string err = string.Format("[ERR_KhieuNai] loi get du lieu [DT_KHIEUNAI_USER] - IDKhieuNai={0},ex={1}", model.IdKhieuNai, ex.Message);
LogHelper.LogInfo(err, "KhieuNai");
return(new List <KhieuNaiUserDTO>());
}
}
public async Task <IHttpActionResult> GetListKhieuNaiUser(string username, string idkhieunai)
{
GetKhieuNaiUserDTO model = new GetKhieuNaiUserDTO()
{
UserName = username,
IdKhieuNai = idkhieunai
};
try
{
await Task.Delay(1000);
if (string.IsNullOrEmpty(model.IdKhieuNai) && string.IsNullOrEmpty(model.UserName))
{
return(Ok(new ResponseCode {
code = "error", message = "Phải nhập mã số khiếu nại hoặc UserName"
}));
}
var data = KhieuNaiBLL.GetListKhieuNaiUser(model);
return(Json(data));
}
catch (Exception ex)
{
string err = string.Format("[ERR_KhieuNai] loi get du lieu [DT_KHIEUNAI_] - UserName={0},IdKhieuNai={1},ex={2}", model.UserName, model.IdKhieuNai, ex.Message);
return(Json(new ResponseCode {
code = "error", message = err
}));
}
}
public static List <KhieuNaiUserDTO> GetListKhieuNaiUser(GetKhieuNaiUserDTO model)
{
var conn = Config.getConnectionKhieuNai();
// Open Connection
string sql = "";
conn.Open();
if (!string.IsNullOrEmpty(model.IdKhieuNai) && !string.IsNullOrEmpty(model.UserName))
{
sql = "SELECT * FROM DT_KHIEUNAI_USER WHERE IDKHIEUNAI = @_IDKHIEUNAI AND USERNAME = @_UserName";
}
if (string.IsNullOrEmpty(model.IdKhieuNai) && !string.IsNullOrEmpty(model.UserName))
{
sql = "SELECT * FROM DT_KHIEUNAI_USER WHERE USERNAME = @_UserName ";
}
if (!string.IsNullOrEmpty(model.IdKhieuNai) && string.IsNullOrEmpty(model.UserName))
{
sql = "SELECT * FROM DT_KHIEUNAI_USER WHERE IDKHIEUNAI = @_IDKHIEUNAI";
}
SqlCommand cmd = new SqlCommand(sql, conn);
if (!string.IsNullOrEmpty(model.IdKhieuNai))
{
cmd.Parameters.AddWithValue("@_IDKHIEUNAI", model.IdKhieuNai);
}
if (!string.IsNullOrEmpty(model.UserName))
{
cmd.Parameters.AddWithValue("@_UserName", model.UserName);
}
IDataReader reader = (IDataReader)cmd.ExecuteReader();
List <KhieuNaiUserDTO> result = new List <KhieuNaiUserDTO>();
if (reader != null)
{
result = DbExtensions.ToList <KhieuNaiUserDTO>(reader);
}
conn.Close();
conn.Dispose();
return(result);
}
