public bool DeletACourseFromDB(CourseO aCoursesInformation)
{
SqlConnection connection = DatabaseConnection.openAnanotherSqlConnection();
string query = "DELETE CoursesInformation WHERE CId ='" + aCoursesInformation.Id + "'";
SqlCommand command = new SqlCommand(query, connection);
int rowsAffected = command.ExecuteNonQuery();
if (rowsAffected == 1)
{
command.Dispose();
return true;
}
else
{
command.Dispose();
return false;
}
}
//public bool UpdateNewStudentToDB(Student aStudent)
//{
// SqlConnection connection = DatabaseConnection.openAnSqlConnection();
// string query = "Update Student SET Name ='" + aStudent.Name + "',Age = " + aStudent.Age + ",Faculty ='" + aStudent.Faculty + "', ParmanentAdress = '" + aStudent.ParmanentAdress + "', PresentAdress ='" + aStudent.PresentAdress + "', Gender ='" + aStudent.Gender
// + "',ContactNo = '" + aStudent.ContactNo + "',BloodGroup = '" + aStudent.Bloodgroup + "' Where Id ='" + aStudent.Id + "' ";
// SqlCommand command = new SqlCommand(query, connection);
// int rowsAffected = command.ExecuteNonQuery();
// if (rowsAffected == 1)
// {
// command.Dispose();
// return true;
// }
// else
// {
// command.Dispose();
// return false;
// }
//}
//public bool DeleteAStudentFromDB(Student aStudent)
//{
// SqlConnection connection = DatabaseConnection.openAnSqlConnection();
// string query = "DELETE FROM Student WHERE Id ='" + aStudent.Id + "'";
// SqlCommand command = new SqlCommand(query, connection);
// int rowsAffected = command.ExecuteNonQuery();
// if (rowsAffected == 1)
// {
// command.Dispose();
// return true;
// }
// else
// {
// command.Dispose();
// return false;
// }
//}
public bool UpdateNewCourseToDB(CourseO aCoursesInformation)
{
SqlConnection connection = DatabaseConnection.openAnanotherSqlConnection();
string query = "Update CoursesInformation SET CourseName ='" + aCoursesInformation.Name + "', CourseCredit = '" + aCoursesInformation.Credit + "', Semister ='" + aCoursesInformation.Semister + "',Teacher = '" + aCoursesInformation.Teacher + "', CourseFee = " + aCoursesInformation.CourseFee + " where CID='"+aCoursesInformation .Id+"' ";
SqlCommand command = new SqlCommand(query, connection);
int rowsAffected = command.ExecuteNonQuery();
if (rowsAffected == 1)
{
command.Dispose();
return true;
}
else
{
command.Dispose();
return false;
}
}
// private object aCoursesUI;
public bool SaveNewCourseToDB(CourseO aCoursesInformation)
{
SqlConnection connection = DatabaseConnection.openAnanotherSqlConnection();
string query = "INSERT INTO CoursesInformation VALUES('" + aCoursesInformation.Name+ "','" + aCoursesInformation.Id + "','" + aCoursesInformation.Credit + "','" + aCoursesInformation.Semister + "','" + aCoursesInformation.Teacher + "'," + aCoursesInformation.CourseFee+")";
SqlCommand command = new SqlCommand(query, connection);
int rowsAffected = command.ExecuteNonQuery();
if (rowsAffected == 1)
{
command.Dispose();
return true;
}
else
{
command.Dispose();
return false;
}
}
//private void backbutton1_Click(object sender, EventArgs e)
//{
// Courses CoursesUI = new Courses();
// CoursesUI.Show();
// this.Hide();
//}
private void confirmbutton1_Click(object sender, EventArgs e)
{
DAL.DAO.CourseO aCourseInfo = new DAL.DAO.CourseO();
aCourseInfo.Name = coursenametextBox.Text;
aCourseInfo.Id = courseidtextBox.Text;
aCourseInfo.Credit = 0;
double.TryParse(CredittextBox.Text, out aCourseInfo.Credit);
aCourseInfo.Semister = semistertextBox.Text;
aCourseInfo.Teacher = teachertextBox.Text;
aCourseInfo.CourseFee = coursefeetextBox.Text;
CourseBL CourseBLOBJ = new CourseBL();
bool result = CourseBLOBJ.ValidateNewCourseandSendToDA(aCourseInfo);
if (result)
{
MessageBox.Show("A NEW COURSE ADDED");
//this.populateDataGriedview();
this.PopulateDatagridview();
Updatebutton.Enabled = true;
deletcoursebutton.Enabled = true;
CANCELbutton1.Enabled = true;
confirmbutton1.Enabled = true;
coursenametextBox.Text = " ";
courseidtextBox.Text = " ";
CredittextBox.Text = " ";
semistertextBox.Text = " ";
teachertextBox.Text = " ";
coursefeetextBox.Text = " ";
}
else
{
MessageBox.Show("RESULT: " + CourseBLOBJ.Message);
}
}
private void deletcoursebutton_Click(object sender, EventArgs e)
{
DAL.DAO.CourseO aCourseInfo = new DAL.DAO.CourseO();
aCourseInfo.Name = coursenametextBox.Text;
aCourseInfo.Id = courseidtextBox.Text;
aCourseInfo.Credit = 0;
double.TryParse(CredittextBox.Text, out aCourseInfo.Credit);
aCourseInfo.Semister = semistertextBox.Text;
aCourseInfo.Teacher = teachertextBox.Text;
aCourseInfo.CourseFee = coursefeetextBox.Text;
CourseBL CourseBLOBJ = new CourseBL();
bool result = CourseBLOBJ.DeletACourseBL(aCourseInfo);
if (result)
{
MessageBox.Show("The Course is Delete FromDB...!!!");
this.PopulateDatagridview();
Updatebutton.Enabled = true;
deletcoursebutton.Enabled = true;
CANCELbutton1.Enabled = true;
confirmbutton1.Enabled = true;
coursenametextBox.Text = " ";
courseidtextBox.Text = " ";
CredittextBox.Text = " ";
semistertextBox.Text = " ";
teachertextBox.Text = " ";
coursefeetextBox.Text = " ";
}
else
{
MessageBox.Show("RESULT: " + CourseBLOBJ.Message);
}
}