public static bool Delete(int id)
{
string sql = @"delete from dbo.FileTable
where Id=" + id.ToString() + ";";
return(SqlDataAccess.DeleteData(sql));
}
public static List <UsersModel> DeleteUser()
{
int DeleteID = Variables.UID;
string sql = @"delete from dbo.UserInfo where id = " + @DeleteID.ToString() + ";";
return(SqlDataAccess.DeleteData <UsersModel>(sql));
}
//Delete OrderLine Method
public static void DeleteOrderLine(int id)
{
//create the sql command
string sql = @"DELETE FROM dbo.[OrderLine] WHERE OrderLineId = @id";
//Call the sql data access to delete the User entry
SqlDataAccess.DeleteData(sql, id);
}
//Delete Client Method
public static void DeleteClient(int id)
{
//create the sql command
string sql = @"DELETE FROM dbo.[Client] WHERE ClientId = @id";
//call the sql data access to delete the User entry
SqlDataAccess.DeleteData(sql, id);
}
//Method to delete Project
public static void DeleteBug(int id)
{
//create the sql command
string sql = @"DELETE FROM dbo.Bug WHERE Id = @id";
//call the sql data access to delete the project entry
SqlDataAccess.DeleteData(sql, id);
}
//Delete Order
public static void DeleteService(int id)
{
//create the sql command
string sql = @"DELETE FROM dbo.[Service] WHERE ServiceId = @id;";
//Call the sql data access to delete the User entry
SqlDataAccess.DeleteData(sql, id);
}
public static int DeleteSozlesme(int ID)
{
int Id = ID;
string sql = @"DELETE FROM SOZLESME WHERE SOZLESME_ID=:ID";
string sql2 = @"DELETE FROM PERSONEL WHERE SOZLESME_ID=:ID";
return(SqlDataAccess.DeleteData <int>(sql, sql2, Id));
}
public static int DeleteData(int id)
{
VehicleMake data = new VehicleMake
{
Id = id
};
string sql = @"delete from dbo.VehicleMakeT where Id=@Id";
return(SqlDataAccess.DeleteData <VehicleMake>(sql, data));
}
//Method to delete Project
public static void DeleteProject(int id)
{
//delete all of the bugs related to the project
string sql = @"DELETE FROM dbo.Bug WHERE BugProjectId = @id"; //create the sql query
SqlDataAccess.DeleteData(sql, id); // access the data access to delete files
//create the sql command
sql = @"DELETE FROM dbo.Project WHERE Id = @id";
//call the sql data access to delete the project entry
SqlDataAccess.DeleteData(sql, id);
}
public static int DeleteRecord(int iId)
{
string sqlU = @"delete from dbo.People where Id=" + iId + ";";
return(SqlDataAccess.DeleteData(sqlU));
}
public static int RemoveAGig(string gigId)
{
string sql = @"DELETE FROM dbo.Gigs WHERE Id = @gigId";
return(SqlDataAccess.DeleteData(sql, gigId));
}
public static int DeleteCategory(int id)
{
string sql = "delete from dbo.Category where CategoryId = " + id;
return(SqlDataAccess.DeleteData(sql));
}
public static int DeleteImage(int id)
{
string sql = "delete from dbo.ProductImages where Id_Product = " + id;
return(SqlDataAccess.DeleteData(sql));
}
public static int DeleteStudent(int iId)
{
string sqlU = @"delete from dbo.student where Id=" + iId + ";";
return(SqlDataAccess.DeleteData(sqlU));
}
public static int DeleteUser(Guid userId)
{
string sql = "delete from dbo.Users where UserId = @UserId";
return(SqlDataAccess.DeleteData(sql, userId));
}
