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