/// <summary> /// /// </summary> /// <param name="employeId"></param> public static int DeleteEmploye(int employeId) { try { int result = 0; // -- Check for existing data in DB -- //var sqlQuery = @"Select count(*) from dbo.Employee where EmployeeId = @EmployeeId;"; var sqlQuery = @"Select count(*) from dbo.Employee where EmployeeId = " + employeId + ";"; //var param = new DynamicParameters(); //param.Add("@EmployeeId", employeId); var dataExist = SqlDataAccess.SelectOneData <IEmployeeModel>(sqlQuery, employeId); if (dataExist) { // -- -- string sqlQuery2 = @"Delete from dbo.Employee where EmployeeId = @EmployeeId;"; result = SqlDataAccess.DeleteData <IEmployeeModel>(sqlQuery2, employeId); } return(result); } catch (Exception exception) { Console.WriteLine(exception.ToString()); throw; } }
public void DeleteBrandById(int id) { SqlDataAccess sql = new SqlDataAccess(); var parameters = new { Id = id }; sql.DeleteData <dynamic>("dbo.spBrandDeleteById", parameters, "DefaultConnection"); }
public void ApagaSala(int salaId, string userId) { SqlDataAccess sql = new SqlDataAccess(); var parameters = new { UserId = userId, SalaId = salaId }; sql.DeleteData <Tuple <string, int>, dynamic>("dbo.spApagaSala", parameters, "WebAPIData"); }
public void DesbanirUser(int salaId, string userId, string idUser) { SqlDataAccess sql = new SqlDataAccess(); var parameters = new { SalaId = salaId, UserId = userId, IdADesbanir = idUser }; sql.DeleteData <int, dynamic>("dbo.spDesbaneUser", parameters, "WebAPIData"); }
public void RemoverUser(int salaId, string userId, string idARemover) { SqlDataAccess sql = new SqlDataAccess(); var parameters = new { SalaId = salaId, UserId = userId, IdARemover = idARemover }; sql.DeleteData <string, dynamic>("dbo.spRemoveUserSala", parameters, "WebAPIData"); }
public void RemoveMusicaSala(int salaId, string URI, int posicao, string userId) { SqlDataAccess sql = new SqlDataAccess(); var parameters = new { SalaId = salaId, MusicaURI = URI, Posicao = posicao, UserId = userId }; sql.DeleteData <string, dynamic>("dbo.spRemoverMusicaSalaURI", parameters, "WebAPIData"); }
private void RemoveFiltros(int salaId, string userId) { SqlDataAccess sql = new SqlDataAccess(); var parameter = new { SalaId = salaId, UserId = userId }; sql.DeleteData <int, dynamic>("dbo.spRemoveFiltrosSala", parameter, "WebAPIData"); }
public static int Remove(int Id) { return(SqlDataAccess.DeleteData <PartLinkModel>( @"delete from dbo.PartLinks where Id=@Id", new PartLinkModel { Id = Id, })); }
public static int Remove(int Id) { return(SqlDataAccess.DeleteData <UserModel>( @"delete from dbo.Users where Id=@Id", new UserModel { Id = Id, })); }
//DELETE a record from the DB public static int DeleteCustomer(int id) { var parameter = new DynamicParameters(); parameter.Add("CustomerID", id); string sql = @"DELETE FROM Customer WHERE CustomerID = @customerID"; return(SqlDataAccess.DeleteData(sql, parameter)); }
public void SaiSala(string userId, int salaId) { SqlDataAccess sql = new SqlDataAccess(); UserSalaModel model = new UserSalaModel(); model.UserId = userId; model.SalaId = salaId; sql.DeleteData <Tuple <string, int>, dynamic>("dbo.spSairSala", model, "WebAPIData"); }
public static void ObrisiKurs(int PKKursID) { string del = @"delete sk from StudentiKurs sk INNER JOIN Kurs k ON sk.PKKursID = k.PKKursID WHERE k.PKKursID=" + PKKursID + ";"; SqlDataAccess.DeleteData(del); string sql = "delete from Kurs where PKKursID = " + PKKursID + ";"; SqlDataAccess.DeleteData(sql); }
public static void ObrisiStudenta(int PKStudentID) { string del = @"delete sk from StudentiKurs sk INNER JOIN Studenti s ON sk.PKStudentID = s.PKStudentID WHERE s.PKStudentID=" + PKStudentID + ";"; SqlDataAccess.DeleteData(del); string sql = "delete from Studenti where PKStudentID = " + PKStudentID + ";"; SqlDataAccess.DeleteData(sql); }
public void Delete() { ParentDisplayModel e = Parents.Where(x => x.Id == SelectedParent.Id).FirstOrDefault(); if (e != null) { SqlDataAccess sql = new SqlDataAccess(); sql.DeleteData <dynamic>("dbo.spParent_Delete", new { Id = SelectedParent.Id }, "ADBData"); Parents = new BindingList <ParentDisplayModel>(GetAllParents()); SelectedParent = null; Clear(); _events.PublishOnUIThread(new ParentChangedEvent()); } }
public void Delete() { SchoolDisplayModel e = Schools.Where(x => x.Id == SelectedSchool.Id).FirstOrDefault(); if (e != null) { SqlDataAccess sql = new SqlDataAccess(); sql.DeleteData <dynamic>("dbo.spSchool_Delete", new { Id = SelectedSchool.Id }, "ADBData"); Schools = new BindingList <SchoolDisplayModel>(GetAllSchools()); SelectedSchool = null; Clear(); _events.PublishOnUIThread(new SchoolChangedEvent()); } }
public void Delete() { AddressDisplayModel e = Addresses.Where(x => x.Id == SelectedAddress.Id).FirstOrDefault(); if (e != null) { SqlDataAccess sql = new SqlDataAccess(); sql.DeleteData <dynamic>("dbo.spAddress_Delete", new { Id = SelectedAddress.Id }, "ADBData"); Addresses = new BindingList <AddressDisplayModel>(GetAllAddresses()); SelectedAddress = null; Clear(); _events.PublishOnUIThread(new AddressChangedEvent()); } }
public void Delete() { CoachDisplayModel e = Coaches.Where(x => x.Id == SelectedCoach.Id).FirstOrDefault(); if (e != null) { SqlDataAccess sql = new SqlDataAccess(); sql.DeleteData <dynamic>("dbo.spCoach_Delete", new { Id = SelectedCoach.Id }, "ADBData"); Coaches = new BindingList <CoachDisplayModel>(GetAllCoaches()); SelectedCoach = null; Clear(); _events.PublishOnUIThread(new CoachChangedEvent()); } }
public static void DeleteUser(int id) { SqlDataAccess.DeleteData(id); }
public void DeleteClient(int id) { SqlDataAccess sql = new SqlDataAccess(); sql.DeleteData("dbo.spClient_Remove", new { id }, "OHMData"); }
public void DeleteUser(int id) { string sql = "Delete from users where userid = " + id; SqlDataAccess.DeleteData(sql); }
public static int DeleteComment(Nullable <int> id) { string sql = $"DELETE FROM comments WHERE ID = {id}"; return(SqlDataAccess.DeleteData(sql)); }
public static int DeleteEvent(int id) { string sql = "delete from dbo.Event where Id = " + id + ";"; return(SqlDataAccess.DeleteData(sql)); }
public void DeleteProfile(IProfile profile) { dataAccess.DeleteData(profile); }
public void DeleteRoom(int id) { SqlDataAccess sql = new SqlDataAccess(); sql.DeleteData("dbo.spRoom_Remove", new { id }, "OHMData"); }
// ID is giving from frontend model.ID public static int Deleteuser(int ID) { string sql = $"DELETE FROM users WHERE ID = {ID}"; return(SqlDataAccess.DeleteData(sql)); }
// ID is giving from frontend model.ID public static int Deletenews(Nullable <int> id) { string sql = $"DELETE FROM news WHERE ID = {id};"; return(SqlDataAccess.DeleteData(sql)); }
public static int DeleteContact(int ID) { string sql = $"DELETE FROM Contacts WHERE ID = {ID}"; return(SqlDataAccess.DeleteData(sql)); }