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