public static object GetImagesById(string id)
{
var files = new List <FileInfoModel>();
var criticalCareImages = new CriticalCareManager().GetCriticalCareImagesById(id);
var response = new JsonResponse()
{
IsSuccess = true, Message = "Files found successfully.", Data = files
};
if (!string.IsNullOrEmpty(criticalCareImages))
{
var images = criticalCareImages.Split(' ');
try
{
foreach (var item in images)
{
if (!string.IsNullOrEmpty(item))
{
string absFile = HttpContext.Current.Server.MapPath("/photo/" + item);
var fs = new FileStream(absFile, FileMode.Open, FileAccess.Read, FileShare.ReadWrite);
using (var sr = new StreamReader(fs))
{
var size = fs.Length;
files.Add(new FileInfoModel()
{
Name = item,
Size = size.ToString(),
Type = "image"
});
}
}
}
response.Data = files;
}
catch (Exception e)
{
response.IsSuccess = false;
response.Message = e.Message;
}
}
return(response);
}
public static object GetCriticalCares(DataTableAjaxPostModel model)
{
var cols = new List <string>()
{
"LOWER(TRIM(cc.hospital_name))", "LOWER(TRIM(cc.email_id))", "LOWER(TRIM(cc.contact_no))", "LOWER(TRIM(cm.city_name))"
};
// Initialization.
DataTableData <CriticalCareModel> result = new DataTableData <CriticalCareModel>();
try
{
// Initialization.
string draw = model.draw.ToString();
int startRec = model.start;
int pageSize = model.length;
var c_order = "";
foreach (var o in model.order)
{
var columnName = cols[o.column];
c_order += string.IsNullOrWhiteSpace(c_order) ? columnName + " " + o.dir : ", " + columnName + " " + o.dir;
}
if (!string.IsNullOrWhiteSpace(c_order))
{
c_order = " order by " + c_order;
}
var c_search = "";
foreach (var s in model.columns)
{
if (!string.IsNullOrWhiteSpace(s.search.value) && s.searchable)
{
var i = model.columns.IndexOf(s);
var columnName = cols[i];
c_search += i == 1 ? " and " + columnName + " like '%" + s.search.value.Trim().ToLower() + "%'" : " and " + columnName + " like '%" + s.search.value + "%'";
}
}
var criticalCares = new CriticalCareManager().GetAllCriticalCaresPaginated(startRec, pageSize, c_order, c_search);
var criticalCareList = criticalCares.Data;
foreach (var criticalCare in criticalCareList)
{
criticalCare.Link = "<a href='javascript:void(0);' style='margin-right:10px' class='edit-cc' data-id='" + criticalCare.Id + "'>Edit</a><a href='javascript:void(0);' class='add-cc-images' data-id='" + criticalCare.Id + "'>Add Images</a><a href='javascript:void(0);' style='margin-left:10px' class='delete-cc' data-id='" + criticalCare.Id + "'>Delete</a>";
}
int recFilter = criticalCares.Data.Count;
result.draw = Convert.ToInt32(draw);
result.recordsTotal = criticalCares.TotalCount;
result.recordsFiltered = criticalCares.TotalCount;
result.data = criticalCareList;
}
catch (Exception ex)
{
// Info
Console.Write(ex);
}
// Return info.
return(result);
}
public static object DeleteCriticalCareById(string id)
{
var resp = new CriticalCareManager().DeleteCriticalCare(id);
return(resp);
}
public static object GetCriticalCareById(string id)
{
var cc = new CriticalCareManager().GetCriticalCareById(id);
return(cc);
}
