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