I am trying to delete a record from the database using angular services. I created a method in my mvc controller but I don't know how to call this method and pass the id.
[HttpPost]
public static void DeleteRecord(int settingID)
{
try
{
using (SqlConnection conn = new SqlConnection(connStringApps))
{
conn.Open();
using (SqlCommand command = new SqlCommand("DeleteCurrentRecord", conn))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.Add("@SettingId", SqlDbType.VarChar).Value = settingID;
command.ExecuteNonQuery();
command.Parameters.Clear();
}
conn.Close();
}
}
catch (Exception ex)
{
Console.Write(ex.ToString());
}
}
myApp.service("deleteService", function ($rootScope) {
this.removeRow = function (recId) {
}
});
myApp.controller('myController', ['$scope','deleteService',
function ($scope, deleteService) {
$scope.deleteRecordFromDB = function (recId) {
//record id is the Id of the record that I want to delete
}
;
}
]);
myApp.service("deleteService", function ($rootScope, $http) {
this.removeRow = function (recId) {
$http.delete(url, {params: {recordId:recId}})
.success(function (data, status, headers, config) {
window.location.reload();
})
.error(function (data, status, header, config) {
});
}
});
myApp.controller('myController', ['$scope', 'deleteService', function ($scope, deleteService) {
$scope.deleteRecordFromDB = function (recId) {
deleteService.removeRow(recId);
};
}
]);
You can access recordId by HttpGet method on server side.
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments