public void DelRes(AdminUpdateDTO AdminUpdateDto) { sqlConnection.Open(); string query = " delete from Restaurant where R_ID = '" + AdminUpdateDto.r_id + "'"; sqlCommand = new SqlCommand(query, sqlConnection); sqlCommand.ExecuteNonQuery(); sqlConnection.Close(); }
public void UpdateRes(AdminUpdateDTO AdminUpdateDto) { sqlConnection.Open(); string query = " update Restaurant set Name ='" + AdminUpdateDto.name + "', Location = '" + AdminUpdateDto.location + "', Type = '" + AdminUpdateDto.type + "', Status = '" + AdminUpdateDto.status + "' where R_ID = '" + AdminUpdateDto.r_id + "'"; sqlCommand = new SqlCommand(query, sqlConnection); sqlCommand.ExecuteNonQuery(); sqlConnection.Close(); }
public void AddRes(AdminUpdateDTO AdminUpdateDto) { string query = " insert into Restaurant(R_ID,Name,Location,Type,Status) values ('" + AdminUpdateDto.r_id + "','" + AdminUpdateDto.name + "','" + AdminUpdateDto.location + "','" + AdminUpdateDto.type + "','" + AdminUpdateDto.status + "')"; sqlCommand = new SqlCommand(query, sqlConnection); sqlConnection.Open(); sqlCommand.ExecuteNonQuery(); sqlConnection.Close(); }