/// <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));
}
