public DiagnosisServiceItem GetDsi(DsiInputModel model)
{
DiagnosisServiceItem message = new DiagnosisServiceItem();
try
{
using (var imisContext = new ImisDB())
{
List <CodeName> diagnoses;
List <CodeNamePrice> items;
List <CodeNamePrice> services;
diagnoses = imisContext.TblIcdcodes
.Where(i => i.ValidityFrom >= Convert.ToDateTime(model.last_update_date) &&
i.ValidityTo == null)
.Select(x => new CodeName()
{
code = x.Icdcode,
name = x.Icdname
}).ToList();
items = imisContext.TblItems
.Where(i => i.ValidityFrom >= Convert.ToDateTime(model.last_update_date) &&
i.ValidityTo == null)
.Select(x => new CodeNamePrice()
{
code = x.ItemCode,
name = x.ItemName,
price = x.ItemPrice.ToString()
}).ToList();
services = imisContext.TblServices
.Where(i => i.ValidityFrom >= Convert.ToDateTime(model.last_update_date) &&
i.ValidityTo == null)
.Select(x => new CodeNamePrice()
{
code = x.ServCode,
name = x.ServName,
price = x.ServPrice.ToString()
}).ToList();
message.diagnoses = diagnoses;
message.items = items;
message.services = services;
message.update_since_last = DateTime.UtcNow;
}
return(message);
}
catch (Exception e)
{
throw e;
}
}
public DiagnosisServiceItem GetDsi(DsiInputModel model)
{
var sSQL = @"SELECT ICDCode AS code ,ICDName AS name FROM tblICDCodes WHERE ValidityFrom >= @LastUpdated AND ValidityTo IS NULL
SELECT ItemCode AS code,ItemName As name,ItemPrice As price FROM tblItems WHERE ValidityFrom >= @LastUpdated AND ValidityTo IS NULL
SELECT ServCode as code,ServName AS name,ServPrice As price FROM tblServices WHERE ValidityFrom >= @LastUpdated AND ValidityTo IS NULL";
DataHelper helper = new DataHelper(Configuration);
SqlParameter date;
if (model.last_update_date != null)
{
date = new SqlParameter("@LastUpdated", model.last_update_date);
}
else
{
date = new SqlParameter("@LastUpdated", System.Data.SqlTypes.SqlDateTime.MinValue);
}
SqlParameter[] sqlParameters =
{
date,
};
DiagnosisServiceItem message = new DiagnosisServiceItem();
try
{
var response = helper.FillDataSet(sSQL, sqlParameters, CommandType.Text);
if (response.Tables.Count > 0)
{
var diagnoses = JsonConvert.SerializeObject(response.Tables[0]);
var items = JsonConvert.SerializeObject(response.Tables[1]);
var services = JsonConvert.SerializeObject(response.Tables[2]);
message.diagnoses = JsonConvert.DeserializeObject <List <CodeName> >(diagnoses);
message.items = JsonConvert.DeserializeObject <List <CodeNamePrice> >(items);
message.services = JsonConvert.DeserializeObject <List <CodeNamePrice> >(services);
message.update_since_last = DateTime.UtcNow;
}
}
catch (Exception e)
{
throw e;
}
return(message);
}
