//Update row in Tbl_def_Courses_Types_x Table
public async Task <bool> Tbl_def_Courses_Types_xUpdate(Tbl_def_Courses_Types_x tbl_def_Courses_Types_x)
{
using (var conn = new SqlConnection(_configuration.Value))
{
var parameters = new DynamicParameters();
parameters.Add("pID", tbl_def_Courses_Types_x.ID, System.Data.DbType.Int32);
parameters.Add("pTitle_Ar", tbl_def_Courses_Types_x.Title_En, System.Data.DbType.String);
parameters.Add("pTitle_En", tbl_def_Courses_Types_x.Title_Ar, System.Data.DbType.String);
parameters.Add("pDescription_En", tbl_def_Courses_Types_x.Description_En, System.Data.DbType.String);
parameters.Add("pDescription_Ar", tbl_def_Courses_Types_x.Description_Ar, System.Data.DbType.String);
parameters.Add("pPhoto", tbl_def_Courses_Types_x.Photo, System.Data.DbType.String);
parameters.Add("pEnabled", tbl_def_Courses_Types_x.Enabled, System.Data.DbType.Boolean);
parameters.Add("pNotes", tbl_def_Courses_Types_x.Notes, System.Data.DbType.String);
await conn.ExecuteAsync("sp_Update_Tbl_def_Courses_Types_x", parameters, commandType : System.Data.CommandType.StoredProcedure);
}
return(true);
}
//Insert new row to Tbl_def_Courses_Types_x Table
public async Task <bool> Tbl_def_Courses_Types_xInsert(Tbl_def_Courses_Types_x tbl_def_Courses_Types_x)
{
using (var conn = new SqlConnection(_configuration.Value))
{
//Debug.WriteLine(">> " + conn.ConnectionString);
var parameters = new DynamicParameters();
parameters.Add("pTitle_Ar", tbl_def_Courses_Types_x.Title_En, System.Data.DbType.String);
parameters.Add("pTitle_En", tbl_def_Courses_Types_x.Title_Ar, System.Data.DbType.String);
parameters.Add("pDescription_En", tbl_def_Courses_Types_x.Description_En, System.Data.DbType.String);
parameters.Add("pDescription_Ar", tbl_def_Courses_Types_x.Description_Ar, System.Data.DbType.String);
parameters.Add("pPhoto", tbl_def_Courses_Types_x.Photo, System.Data.DbType.String);
parameters.Add("pEnabled", tbl_def_Courses_Types_x.Enabled, System.Data.DbType.Boolean);
parameters.Add("pNotes", tbl_def_Courses_Types_x.Notes, System.Data.DbType.String);
//Raw sql Method
await conn.ExecuteAsync("sp_Insert_Tbl_def_Courses_Types_x", parameters, commandType : System.Data.CommandType.StoredProcedure);
}
return(true);
}
