private ResultModelSingle <SP_STATISTIC_Result> List()
{
var result = new ResultModelSingle <SP_STATISTIC_Result>();
try
{
result.resultItem = _dbContext.SP_STATISTIC().FirstOrDefault();
}
catch (Exception ex)
{
Log.Error(ex);
result.exceptionMessage = ex.Message;
}
return(result);
}
private ResultModelSingle <Notes> Find(string user_id, string id)
{
var result = new ResultModelSingle <Notes>();
try
{
result.resultItem = _dbContext.Notes.FirstOrDefault(x => x.Id == id && x.User_Id == user_id);
}
catch (Exception ex)
{
Log.Error(ex);
result.exceptionMessage = ex.Message;
}
return(result);
}
/// <summary>
/// Menü Bulma
/// </summary>
/// <param name="id">Menü Id</param>
/// <returns></returns>
private ResultModelSingle <Menu> FindById(string id)
{
var result = new ResultModelSingle <Menu>();
try
{
result.resultItem = _dbContext.Menu.FirstOrDefault(x => x.Id == id);
}
catch (Exception ex)
{
Log.Error(ex);
result.exceptionMessage = ex.Message;
}
return(result);
}
private ResultModelSingle <WorkDefinition> FindById(string user_id, string project_id)
{
var result = new ResultModelSingle <WorkDefinition>();
try
{
result.resultItem = _dbContext.WorkDefinition.Include("Projects").FirstOrDefault(x => x.User_Id == user_id && x.Id == project_id);
}
catch (Exception ex)
{
Log.Error(ex);
result.exceptionMessage = ex.Message;
}
return(result);
}
private ResultModelSingle <AspNetUsers> FindById(string id)
{
var result = new ResultModelSingle <AspNetUsers>();
try
{
result.resultItem = result.resultItem = _dbContext.AspNetUsers.Include("AspNetRoles").FirstOrDefault(x => x.Id == id);
}
catch (Exception ex)
{
Log.Error(ex);
result.exceptionMessage = ex.Message;
}
return(result);
}
/// <summary>
/// Sunucu Parametrelerini İşleme
/// </summary>
/// <typeparam name="T">İşlenecek Veri Modeli</typeparam>
public async Task <ResultModelSingle <T> > GetServerParameter <T>()
{
var result = new ResultModelSingle <T>();
try
{
var serverInfo = await this.DB_ServerInfo().ListAsync("Hepsi");
var _activator = (T)Activator.CreateInstance(typeof(T));
var _props = _activator.GetType().GetProperties();
var a = (T)Activator.CreateInstance(typeof(T));
foreach (var item in serverInfo.resultItem)
{
foreach (var child in _props)
{
if (child.Name == item.key_str)
{
if (child.PropertyType == typeof(int))
{
child.SetValue(a, Convert.ToInt32(item.value_str), null);
}
else
{
child.SetValue(a, item.value_str, null);
}
}
}
}
result.resultItem = a;
}
catch (Exception ex)
{
result.exceptionMessage = ex.Message;
}
return(result);
}
