private void deleteButton_Click(object sender, EventArgs e)
{
BookCatagory bookCatagoryOBj = new BookCatagory();
bookCatagoryOBj.cID = int.Parse(cIDTextBox.Text);
bookCatagoryOBj.catagoryName = cNameTextBox.Text;
bookCatagoryOBj.catagoryDetails = detailsTextBox.Text;
BookCatagoryBL bCatBLOBj = new BookCatagoryBL();
bool result = bCatBLOBj.DeleteCatagoryAndSendToBL(bookCatagoryOBj);
if (result)
{
MessageBox.Show("Succesfuly Deleted!!!!");
this.PopulateGridView();
IntitialButtonMood();
CleanTextBar();
}
else
{
MessageBox.Show("ERROR!!");
}
}
private BookCatagory BuildEntity(BookCatagory obj)
{
if (!string.IsNullOrEmpty(hhdId.Value))
{
obj.Id = long.Parse(hhdId.Value);
}
obj.Name = txtName.Text;
return(obj);
}
public void Save(BookCatagory bookCategory)
{
Database db;
string sqlCommand;
DbCommand dbCommand;
db = DatabaseFactory.CreateDatabase();
sqlCommand = "BookCatagoryInsert";
dbCommand = db.GetStoredProcCommand(sqlCommand);
db.DiscoverParameters(dbCommand);
dbCommand.Parameters["@Name"].Value = bookCategory.Name;
db.ExecuteNonQuery(dbCommand);
}
public bool DeleteCatagoryAndSendToBL(BookCatagory bCatagoryOBj)
{
if (bCatagoryOBj.cID == 0 || bCatagoryOBj.catagoryName == "" || bCatagoryOBj.catagoryDetails == "")
{
return(false);
}
else
{
BookCatagoryDA BookCatagoryDAOBj = new BookCatagoryDA();
bool result = BookCatagoryDAOBj.DeleteCatagoryFromDB(bCatagoryOBj);
return(result);
}
}
public bool ValidateNewCatagoryAndSendToBL(BookCatagory bCatagoryOBj)
{
if (bCatagoryOBj.cID == 0 || bCatagoryOBj.catagoryName == "" || bCatagoryOBj.catagoryDetails == "")
{
return(false);
}
else
{
BookCatagoryDA BookCatagoryDAOBj = new BookCatagoryDA();
bool result = BookCatagoryDAOBj.SaveNewCatagoryToDB(bCatagoryOBj);
return(result);
}
}
public bool DeleteCatagoryFromDB(BookCatagory bCatagoryOBj)
{
SqlConnection connection = DatabaseConnection.OpenAnSqlConnection();
string query = "DELETE FROM BookCatagory WHERE CID = " + bCatagoryOBj.cID + "";
SqlCommand command = new SqlCommand(query, connection);
int rowsAffected = command.ExecuteNonQuery();
if (rowsAffected == 1)
{
return(true);
}
else
{
return(false);
}
}
public bool UpdateCatagoryToDB(BookCatagory bCatagoryOBj)
{
SqlConnection connection = DatabaseConnection.OpenAnSqlConnection();
string query = "UPDATE BookCatagory SET Catagory ='" + bCatagoryOBj.catagoryName + "', Details ='" + bCatagoryOBj.catagoryDetails + "' WHERE CID = " + bCatagoryOBj.cID + "";
SqlCommand command = new SqlCommand(query, connection);
int rowsAffected = command.ExecuteNonQuery();
if (rowsAffected == 1)
{
return(true);
}
else
{
return(false);
}
}
public bool SaveNewCatagoryToDB(BookCatagory bCatagoryOBj)
{
SqlConnection connection = DatabaseConnection.OpenAnSqlConnection();
string query = "INSERT INTO BookCatagory VALUES(" + bCatagoryOBj.cID + ",'" + bCatagoryOBj.catagoryName + "','" + bCatagoryOBj.catagoryDetails + "')";
SqlCommand command = new SqlCommand(query, connection);
int rowsAffected = command.ExecuteNonQuery();
if (rowsAffected == 1)
{
return(true);
}
else
{
return(false);
}
}
public BookCatagory GetById(long categotyId)
{
Database db;
string sqlCommand;
DbCommand dbCommand;
BookCatagory instance = null;
db = DatabaseFactory.CreateDatabase();
sqlCommand = "BookCatagoryGetById";
dbCommand = db.GetStoredProcCommand(sqlCommand, categotyId);
// Get results.
using (IDataReader objReader = db.ExecuteReader(dbCommand))
{
while (objReader.Read())
{
instance = instance.ReadReader(objReader);
}
}
return(instance);
}
public List <BookCatagory> GetAll()
{
Database db;
string sqlCommand;
DbCommand dbCommand;
db = DatabaseFactory.CreateDatabase();
sqlCommand = "BookCatagoryGetAll";
dbCommand = db.GetStoredProcCommand(sqlCommand);
List <BookCatagory> objPrdList = new List <BookCatagory>();
using (IDataReader objReader = db.ExecuteReader(dbCommand))
{
while (objReader.Read())
{
BookCatagory obj = new BookCatagory();
objPrdList.Add(obj.ReadReader(objReader));
}
}
return(objPrdList);
}
void IBookInfoService.Delete(BookCatagory bookCategory)
{
throw new NotImplementedException();
}
public void Delete(BookCatagory bookCategory)
{
throw new NotImplementedException();
}
