public object LanguageUpdate(LanguageParam b)
{
if (b.Language == null)
{
return(new Error()
{
IsError = true, Message = "Required Language"
});
}
var data = db.TblLanguages.Where(r => r.LanguageId == b.LanguageId).FirstOrDefault();
try
{
TblBoard obj = new TblBoard();
data.Language = b.Language;
data.ModifiedBy = null;
data.ModifiedDate = System.DateTime.Today.Date;
db.SaveChanges();
return(new Result()
{
IsSucess = true, ResultData = "Update Language"
});
}
catch (Exception e)
{
return(new Error()
{
IsError = true, Message = e.Message
});
}
}
public object DeleteLanguage(LanguageParam PM)
{
try
{
TblLanguage obj = db.TblLanguages.Where(r => r.LanguageId == PM.LanguageId).FirstOrDefault();
if (obj.Status == 1)
{
obj.Status = 0;
}
else
{
obj.Status = 1;
}
db.SaveChanges();
return(new Result()
{
IsSucess = true, ResultData = "Language Deactivated Successfully."
});
}
catch (Exception e)
{
return(new Error()
{
IsError = true, Message = e.Message
});
}
}
/// <summary>
/// 查
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ExcutedResult QueryLanguage(LanguageQueryRequestModel model)
{
try
{
if (model == null)
{
throw new BusinessException(BusinessResultCode.ArgumentError, "参数错误或无效");
}
if (model.PageIndex == default(int))
{
model.PageIndex = 1;
}
if (model.PageSize == default(int))
{
model.PageSize = 10;
}
DateTime startTime = default(DateTime);
DateTime.TryParse(model.StartTime, out startTime);
DateTime endTime = default(DateTime);
DateTime.TryParse(model.EndTime, out endTime);
if (string.IsNullOrEmpty(model.SortName))
{
model.SortName = "CreateTime";
model.IsSortOrderDesc = true;
}
LanguageParam languageParam = new LanguageParam();
languageParam.Code = model.Code;
languageParam.Desc = model.Desc;
languageParam.Type = model.Type;
languageParam.Content = model.Content;
languageParam.StartTime = startTime;
languageParam.EndTime = endTime;
languageParam.PageIndex = model.PageIndex;
languageParam.PageSize = model.PageSize;
languageParam.SortName = model.SortName;
languageParam.IsSortOrderDesc = model.IsSortOrderDesc;
var data = Repository.QueryLanguage(languageParam);
return(ExcutedResult.SuccessResult(data));
}
catch (BusinessException businessException)
{
return(ExcutedResult.FailedResult(businessException.ErrorCode,
GetDescribe(businessException.ErrorCode, EnumLanguageDataType.BusinessResultCode)));
}
catch (Exception exception)
{
return(ExcutedResult.FailedResult(SysResultCode.ServerException,
GetDescribe(SysResultCode.ServerException, EnumLanguageDataType.BusinessResultCode)));
}
}
public object DeleteLanguage([FromBody] LanguageParam PM)
{
try
{
SchoolBusiness b = new SchoolBusiness();
var Result = b.DeleteLanguage(PM);
return(Result);
}
catch (Exception e)
{
return(new Error()
{
IsError = true, Message = e.Message
});
}
}
public object AddLanguage([FromBody] LanguageParam obj)
{
try
{
SchoolBusiness save = new SchoolBusiness();
var result = save.SaveLanguage(obj);
return(result);
}
catch (Exception e)
{
return(new Error()
{
IsError = true, Message = e.Message
});
}
}
public object UpdateLanguage(LanguageParam b)
{
try
{
SchoolBusiness board = new SchoolBusiness();
var Result = board.LanguageUpdate(b);
return(Result);
}
catch (Exception e)
{
return(new Error()
{
IsError = true, Message = e.Message
});
}
}
public object GetSingleLanuageInfo(LanguageParam b)
{
try
{
SchoolBusiness language = new SchoolBusiness();
var Result = language.GetSingleLanguage(b);
return(Result);
}
catch (Exception e)
{
return(new Error()
{
IsError = true, Message = e.Message
});
}
}
public object GetSingleLanguage(LanguageParam b)
{
try
{
var language = db.TblLanguages.Where(r => r.LanguageId == b.LanguageId).FirstOrDefault();
return(new Result()
{
IsSucess = true, ResultData = language
});
}
catch (Exception e)
{
return(new Error()
{
IsError = true, Message = e.Message
});
}
}
public object SaveLanguage(LanguageParam b)
{
if (b.Language == null)
{
return(new Error()
{
IsError = true, Message = "Required Language"
});
}
var data = db.TblLanguages.FirstOrDefault(r => r.Language == b.Language);
if (data != null)
{
return(new Error()
{
IsError = true, Message = "Duplicate Entry Not Allowed"
});
}
try
{
TblLanguage obj = new TblLanguage();
obj.Language = b.Language;
obj.Status = 1;
obj.CreatedBy = 1;
obj.CreatedDate = System.DateTime.Today.Date;
obj.ModifiedBy = null;
obj.ModifiedDate = System.DateTime.Today.Date;
db.TblLanguages.Add(obj);
db.SaveChanges();
return(new Result()
{
IsSucess = true, ResultData = "Created Language"
});
}
catch (Exception e)
{
return(new Error()
{
IsError = true, Message = e.Message
});
}
}
/// <summary>
/// 根据条件查询
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public PagedResults <Language> QueryLanguage(LanguageParam model)
{
var queryable = GetAdvQuery(model);
return(queryable.ToPagedResults <Language, Language>(model));;
}
