private bool isNewTimePeriod(DateTime utcNow)
{
/* The last time of consumed message */
string lastTimestampOfConsumedMsg = _redisCacheHelper.GetValueByKey(_cachekey_message_consumed_date);
if (lastTimestampOfConsumedMsg == null)
{
_consoleLog.Info("Redis Cache {0} was NOT found", _cachekey_message_consumed_date.ToString());
_consoleLog.BlobLogInfo("Redis Cache {0} was NOT found", _cachekey_message_consumed_date.ToString());
// THIS IS A NEW DAY!
return(true);
}
else
{
DateTime lastTimestamp = DateTime.Parse((string)lastTimestampOfConsumedMsg);
/* The period is 1 day */
DateTime timeup = DateTime.Parse(lastTimestamp.AddDays(1).ToString("yyyy-MM-ddT00:00:00.000"));
/* This is a sample for that the period is 1 minute */
//DateTime timeup = DateTime.Parse(lastTimestamp.AddMinutes(1).ToString("yyyy-MM-ddTHH:mm:00.000"));
if (DateTime.Compare(utcNow, timeup) >= 0)
{
// THIS IS A NEW DAY!
return(true);
}
else
{
return(false);
}
}
}
public IHttpActionResult GetCompanyById(int id)
{
RedisKey cacheKey = "company_" + id;
string cacheValue = null;
if (Global._enableRedisCache)
{
cacheValue = RedisCacheHelper.GetValueByKey(cacheKey);
}
if (cacheValue == null)
{
CompanyModel companyModel = new CompanyModel();
try
{
CompanyModel.Format_Detail company = companyModel.GetById(id);
//RedisCacheHelper.SetKeyValue(cacheKey, JsonConvert.SerializeObject(company));
return(Content(HttpStatusCode.OK, company));
}
catch (CDSException cdsEx)
{
return(Content(HttpStatusCode.BadRequest, CDSException.GetCDSErrorMessageByCode(cdsEx.ErrorId)));
}
catch (Exception ex)
{
return(Content(HttpStatusCode.InternalServerError, ex));
}
}
else
{
return(Content(HttpStatusCode.OK, JsonConvert.DeserializeObject(cacheValue)));
}
}
public HttpResponseMessage GetAllowDomainByCompanyId(int id)
{
RedisKey cacheKey = "company_" + id + "_allowDomain";
string cacheValue = null;
if (Global._enableRedisCache)
{
cacheValue = RedisCacheHelper.GetValueByKey(cacheKey);
}
if (cacheValue == null)
{
CompanyModel companyModel = new Models.CompanyModel();
try
{
CompanyModel.Format_Detail company = companyModel.GetById(id);
//RedisCacheHelper.SetKeyValue(cacheKey, new JavaScriptSerializer().Serialize(company));
return(Request.CreateResponse(HttpStatusCode.OK, company.AllowDomain));
}
catch (CDSException cdsEx)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, CDSException.GetCDSErrorMessageByCode(cdsEx.ErrorId)));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, JsonConvert.DeserializeObject <CompanyModel.Format_Detail>(cacheValue).AllowDomain));
}
}
public IHttpActionResult GetEmployeeById(int id)
{
RedisKey cacheKey = "employee_" + id;
string cacheValue = null;
if (Global._enableRedisCache)
{
cacheValue = RedisCacheHelper.GetValueByKey(cacheKey);
}
if (cacheValue == null)
{
try
{
EmployeeModel model = new EmployeeModel();
var employee = model.GetById(id);
//RedisCacheHelper.SetKeyValue(cacheKey, new JavaScriptSerializer().Serialize(employee));
return(Content(HttpStatusCode.OK, employee));
}
catch (CDSException cdsEx)
{
return(Content(HttpStatusCode.BadRequest, CDSException.GetCDSErrorMessageByCode(cdsEx.ErrorId)));
}
catch (Exception ex)
{
return(Content(HttpStatusCode.InternalServerError, ex));
}
}
else
{
return(Ok(JsonConvert.DeserializeObject <Object>(cacheValue)));
}
}
public IHttpActionResult GetRolesByEmployeeId(int id)
{
RedisKey cacheKey = "employee_" + id + "_Role";
string cacheValue = null;
if (Global._enableRedisCache)
{
cacheValue = RedisCacheHelper.GetValueByKey(cacheKey);
}
if (cacheValue == null)
{
try
{
EmployeeInRoleModel model = new EmployeeInRoleModel();
model.GetAllByEmployeeId(id);
return(Content(HttpStatusCode.OK, model.GetAllByEmployeeId(id)));
}
catch (CDSException cdsEx)
{
return(Content(HttpStatusCode.BadRequest, CDSException.GetCDSErrorMessageByCode(cdsEx.ErrorId)));
}
catch (Exception ex)
{
return(Content(HttpStatusCode.InternalServerError, ex));
}
}
else
{
return(Content(HttpStatusCode.OK, JsonConvert.DeserializeObject <List <Object> >(cacheValue)));
}
}
public IHttpActionResult GetRolesByEmployeeId(int id)
{
RedisKey cacheKey = "employee_" + id + "_Role";
string cacheValue = RedisCacheHelper.GetValueByKey(cacheKey);
if (cacheValue == null)
{
using (var ctx = new SFDatabaseEntities())
{
var roles = ctx.EmployeeInRole
.Where(s => s.EmployeeID == id && s.DeletedFlag == false)
.Select(s => new EmployeeRoleModels.Detail()
{
UserRoleId = s.UserRoleID,
UserRoleName = s.UserRole.Name
}).ToList <EmployeeRoleModels.Detail>();
RedisCacheHelper.SetKeyValue(cacheKey, new JavaScriptSerializer().Serialize(roles));
return(Ok(roles));
}
}
else
{
return(Ok(new JavaScriptSerializer().Deserialize <List <Object> >(cacheValue)));
}
}
public IHttpActionResult GetCompanyById()
{
int companyId = GetCompanyIdFromToken();
RedisKey cacheKey = "external_company_" + companyId;
string cacheValue = RedisCacheHelper.GetValueByKey(cacheKey);
if (cacheValue == null)
{
CompanyModels companyModel = new CompanyModels();
try
{
CompanyModels.Detail_readonly company = companyModel.getCompanyByIdReadonly(Convert.ToInt32(companyId.ToString()));
RedisCacheHelper.SetKeyValue(cacheKey, JsonConvert.SerializeObject(company));
return(Ok(company));
}
catch (Exception ex)
{
StringBuilder logMessage = LogUtility.BuildExceptionMessage(ex);
string logAPI = "[Get] " + Request.RequestUri.ToString();
Startup._sfAppLogger.Error(logAPI + logMessage);
return(InternalServerError());
}
}
else
{
return(Ok(new JavaScriptSerializer().Deserialize <Object>(cacheValue)));
}
}
public IHttpActionResult GetAllDeviceTypes()
{
string cacheValue = RedisCacheHelper.GetValueByKey(cacheKey);
if (string.IsNullOrEmpty(cacheValue) || cacheValue.Length < 10)
{
DeviceTypeModels deviceTypeModel = new Models.DeviceTypeModels();
List <DeviceTypeModels.Detail> deviceTypeList = deviceTypeModel.GetAllDeviceType();
RedisCacheHelper.SetKeyValue(cacheKey, new JavaScriptSerializer().Serialize(deviceTypeList));
return(Ok(deviceTypeList));
}
else
{
return(Ok(new JavaScriptSerializer().Deserialize <Object>(cacheValue)));
}
}
public IHttpActionResult GetPermissionsByEmployeeId(int id)
{
RedisKey cacheKey = "employee_" + id + "_Permission";
string cacheValue = RedisCacheHelper.GetValueByKey(cacheKey);
if (cacheValue == null)
{
EmployeeModels employeeModel = new EmployeeModels();
var empPermissions = employeeModel.GetAllPermissionById(id);
RedisCacheHelper.SetKeyValue(cacheKey, new JavaScriptSerializer().Serialize(empPermissions));
return(Ok(empPermissions));
}
else
{
return(Ok(new JavaScriptSerializer().Deserialize <List <Object> >(cacheValue)));
}
}
public IHttpActionResult GetAll()
{
RedisKey cacheKey = "cultureCodesJson";
string cacheValue = null;
if (Global._enableRedisCache)
{
cacheValue = RedisCacheHelper.GetValueByKey(cacheKey);
}
if (cacheValue == null)
{
RefCultureInfoModel model = new RefCultureInfoModel();
return(Ok(model.GetAll()));
}
else
{
return(Ok(JsonConvert.DeserializeObject(cacheValue)));
//return Ok(new JavaScriptSerializer().Deserialize<List<RefCultureInfoModels>>(cacheValue));
}
}
public IHttpActionResult GetCompanyById(int id)
{
RedisKey cacheKey = "company_" + id;
string cacheValue = RedisCacheHelper.GetValueByKey(cacheKey);
if (cacheValue == null)
{
CompanyModels companyModel = new CompanyModels();
try
{
CompanyModels.Detail company = companyModel.getCompanyById(id);
RedisCacheHelper.SetKeyValue(cacheKey, new JavaScriptSerializer().Serialize(company));
return(Ok(company));
}
catch
{
return(NotFound());
}
}
else
{
return(Ok(new JavaScriptSerializer().Deserialize <Object>(cacheValue)));
}
}
public IHttpActionResult GetEmployeeById(int id)
{
RedisKey cacheKey = "employee_" + id;
string cacheValue = RedisCacheHelper.GetValueByKey(cacheKey);
if (cacheValue == null)
{
EmployeeModels employeeMode = new EmployeeModels();
try
{
var employee = employeeMode.GetEmployeeById(id);
RedisCacheHelper.SetKeyValue(cacheKey, new JavaScriptSerializer().Serialize(employee));
return(Ok(employee));
}
catch
{
return(NotFound());
}
}
else
{
return(Ok(new JavaScriptSerializer().Deserialize <Object>(cacheValue)));
}
}
public IHttpActionResult GetAll()
{
RedisKey cacheKey = "cultureCodesJson";
string cacheValue = RedisCacheHelper.GetValueByKey(cacheKey);
if (cacheValue == null)
{
using (var ctx = new SFDatabaseEntities())
{
var cultureCodes = ctx.RefCultureInfo
.Select(s => new RefCultureInfoModels()
{
CultureCode = s.CultureCode,
Name = s.Name
}).ToList <RefCultureInfoModels>();
RedisCacheHelper.SetKeyValue(cacheKey, new JavaScriptSerializer().Serialize(cultureCodes));
return(Ok(cultureCodes));
}
}
else
{
return(Ok(new JavaScriptSerializer().Deserialize <List <RefCultureInfoModels> >(cacheValue)));
}
}
