public JsonResult GetVisitById(string ID)
{
VIST_CONTACTOR vit = new VIST_CONTACTOR();
var result = vit.GetVisit(ID);
return(Json(result));
}
public JsonResult GetVisit(DataTableParameters dataTableParameters, string from, string to, string cus_id, string emp_id)
{
VIST_CONTACTOR vit = new VIST_CONTACTOR();
var resultSet = new DataTableResultSet();
resultSet.draw = dataTableParameters.Draw;
var lst = vit.GetVisit(from, to, cus_id, emp_id, dataTableParameters.Start + 1,
dataTableParameters.Start + dataTableParameters.Length + 1);
resultSet.recordsTotal = resultSet.recordsFiltered = vit.GetCountVisit(from, to, cus_id, emp_id);
foreach (var i in lst)
{
var columns = new List <string>();
columns.Add("<input type='checkbox' class='ckb' id='" + i.ID + "' data-emp='" + i.EMP_ID + "' />");
columns.Add(i.CONTACT_DATE.ToShortDateString());
columns.Add(i.CUSTOMER_ID.ToString());
columns.Add(i.CUS_NAME.ToString());
columns.Add(i.CUST_VIST_TYPE == null ? "" : i.CUST_VIST_TYPE);
columns.Add(i.CUST_VIST_PURPOSE == null ? "" : i.CUST_VIST_PURPOSE);
columns.Add(i.VIST_REMARK == null ? "" : i.VIST_REMARK);
columns.Add(i.EMP_NAME == null? "":i.EMP_NAME);
resultSet.data.Add(columns);
}
return(Json(resultSet));
}