public JsonResult SelectAlerts(ThongBaoModels model)
{
int iCurrentPage = int.Parse(model.curentPage);
//check login
if (!IsLogged())
{
return(null);
}
ThongBaoServices service = new ThongBaoServices();
List <ThongBaoModels> lstResult = service.SelectRows(new M_ThongBao()
{
noidung = model.noidung,
limit = base.defaultConst.ReadConst("paging", 0).ToString(),
offset = model.curentPage
});
int soluongTong = service.CountRows(new M_ThongBao()
{
noidung = model.noidung
});
StringBuilder result = new StringBuilder();
StringBuilder lstRow = new StringBuilder();
if (lstResult.Count > 0)
{
int i = 1;
if (iCurrentPage > 0)
{
i = iCurrentPage + 1;
}
foreach (var item in lstResult)
{
lstRow.Append(PrepareDataJsonForSelectAlerts(item, i));
i++;
}
if (lstRow.Length > 0)
{
lstRow.Remove(lstRow.Length - 1, 1);
}
}
result.Append("{");
result.Append("\"isHeader\":\"" + "111" + "\",");
result.Append("\"curentPage\":\"" + (iCurrentPage + lstResult.Count) + "\",");
result.Append("\"Pages\":\"" + soluongTong + "\",");
result.Append("\"data\":[" + lstRow.ToString() + "]");
result.Append("}");
return(Json(result.ToString(), JsonRequestBehavior.AllowGet));
}
public List <ThongBaoModels> SelectQuickAlerts(ThongBaoModels clParam)
{
logger.Start("SelectQuickAlerts");
List <ThongBaoModels> lstResult = new List <ThongBaoModels>();
try
{
Hashtable param = new Hashtable();
param = base.SetDataToHashtable(false, clParam);
IList ilist = sqlMap.ExecuteQueryForList("m_thongbao.SelectQuickAlerts", param);
CastDataType cast = new CastDataType();
lstResult = cast.AdvanceCastDataToList <ThongBaoModels>(ilist);
}
catch (Exception ex)
{
logger.Error("Loi ---> " + ex.Message);
}
logger.End("SelectQuickAlerts");
return(lstResult);
}
private StringBuilder PrepareDataJsonForSelectAlerts(ThongBaoModels model, int couter)
{
StringBuilder sbResult = new StringBuilder();
try
{
sbResult.Append("{");
sbResult.Append("\"col_class\":\"rows-box\",");
sbResult.Append("\"col_id\":\"" + model.mathongbao + "\",");
sbResult.Append("\"col_value\":[");
#region Data cell
//stt
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col1 stt\",");
sbResult.Append("\"col_value\":\"" + couter.ToString() + "\"");
sbResult.Append("},");
//noi dung
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col2\",");
sbResult.Append("\"title\":\"" + model.noidung + "\",");
sbResult.Append("\"col_value\":\"" + model.noidung + "\"");
sbResult.Append("},");
//ngay nhap
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col3\",");
sbResult.Append("\"col_value\":\"" + FunctionsDateTime.GetDateTimeClientCustomFormat(model.ngaytao) + "\"");
sbResult.Append("}");
#endregion
sbResult.Append("]");
sbResult.Append("},");
}
catch (Exception ex)
{
_logger.Error(ex);
}
return(sbResult);
}
public ThongBaoModels RowDetail(M_ThongBao clparam)
{
logger.Start("RowDetail");
ThongBaoModels vbResult = new ThongBaoModels();
try
{
Hashtable param = new Hashtable();
param = base.SetDataToHashtable(false, clparam);
IList ilist = sqlMap.ExecuteQueryForList("m_thongbao.RowDetail", param);
CastDataType cast = new CastDataType();
vbResult = cast.AdvanceCastDataToList <ThongBaoModels>(ilist)[0];
}
catch (Exception ex)
{
logger.Error(ex.Message);
vbResult = new ThongBaoModels();
}
logger.End("RowDetail");
return(vbResult);
}
public bool UpdateRow(ThongBaoModels clParam)
{
logger.Start("UpdateRow");
bool bResult = false;
try
{
sqlMap.BeginTransaction();
Hashtable param = new Hashtable();
param = base.SetDataToHashtable(false, clParam);
sqlMap.Update("m_thongbao.UpdateRow", param);
sqlMap.CommitTransaction();
bResult = true;
}
catch (Exception ex)
{
sqlMap.RollbackTransaction();
bResult = false;
logger.Error(ex.Message);
}
logger.End("UpdateRow");
return(bResult);
}
