/// <summary>
/// create,update,delete record by parameter
/// </summary>
/// <typeparam name="T">model type</typeparam>
/// <param name="sqlFileName">sql file name</param>
/// <param name="sqlId">sql id</param>
/// <param name="modelList">model list</param>
/// <returns>create,update,delete quantity</returns>
public virtual int CUDByModel <T>(string sqlFileName, string sqlId, List <T> modelList) where T : class
{
IBaseDal dal = new BaseDal();
return(dal.CUD(sqlFileName, sqlId, modelList.Select(a => { return BaseDal.ConvertEntityToParameters <T>(a); }).ToList()));
}
/// <summary>
/// create,update,delete record by parameter
/// </summary>
/// <typeparam name="T">model type</typeparam>
/// <param name="sqlFileName">sql file name</param>
/// <param name="sqlId">sql id</param>
/// <param name="model">model</param>
/// <returns>create,update,delete quantity</returns>
public virtual int CUDByModel <T>(string sqlFileName, string sqlId, T model) where T : class
{
IBaseDal dal = new BaseDal();
return(dal.CUD(sqlFileName, sqlId, BaseDal.ConvertEntityToParameters <T>(model)));
}
/// <summary>
/// create,update,delete record by parameter
/// </summary>
/// <param name="sqlFileName">sql file name</param>
/// <param name="sqlId">sql id</param>
/// <param name="pmsDictList">parameter list</param>
/// <returns>create,update,delete quantity</returns>
public virtual int CUDByPms(string sqlFileName, string sqlId, List <Dictionary <string, object> > pmsDictList)
{
IBaseDal dal = new BaseDal();
return(dal.CUD(sqlFileName, sqlId, pmsDictList));
}
/// <summary>
/// delete record by parameters
/// </summary>
/// <param name="sqlFileName">sql file name</param>
/// <param name="pmsDict">parameter</param>
/// <returns>delete quantity</returns>
public virtual int DeleteByPms(string sqlFileName, Dictionary <string, object> pmsDict)
{
IBaseDal dal = new BaseDal();
return(dal.CUD(sqlFileName, "Delete", pmsDict));
}
/// <summary>
/// delete record by model
/// </summary>
/// <typeparam name="T">model type</typeparam>
/// <param name="model">model</param>
/// <returns>delete quantity</returns>
public virtual int DeleteByModel <T>(T model) where T : class
{
IBaseDal dal = new BaseDal();
return(dal.CUD <T>("Delete", model));
}
/// <summary>
/// update record by model
/// </summary>
/// <typeparam name="T">model type</typeparam>
/// <param name="models">models</param>
/// <returns>update quantity</returns>
public virtual int UpdateByModel <T>(List <T> models) where T : class
{
IBaseDal dal = new BaseDal();
return(dal.CUD <T>("Update", models));
}
