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