//inserting data into database
public bool insertSubject(SubjectClass s)
{
//creating a default return type and setting its value to false
bool isSuccess = false;
//connect database
SQLiteConnection conn = new Classes.SqliteHelper().GetSQLiteConnection();
try
{
//creating a Sql query ti insert data
string sql = "Insert into Subject(OfferdYear,OfferdSemester,SubjectName,SubjectCode,NoOfLectureHours,NoOfTutorilaHours,NoOfLabHours,NoOfEvaluationHours) VALUES(@OfferdYear,@OfferdSemester,@SubjectName,@SubjectCode,@NoOfLectureHours,@NoOfTutorialHours,@NoOfLabHours,@NoOfEvaluationHours)";
//creatng a Sql command using sql and cmd
SQLiteCommand cmd = new SQLiteCommand(sql, conn);
cmd.Parameters.AddWithValue("@OfferdYear", s.OfferdYear);
cmd.Parameters.AddWithValue("@OfferdSemester", s.OfferdSemester);
cmd.Parameters.AddWithValue("@SubjectName", s.SubjectName);
cmd.Parameters.AddWithValue("@SubjectCode", s.SubjectCode);
cmd.Parameters.AddWithValue("@NoOfLectureHours", s.NoOfLectureHours);
cmd.Parameters.AddWithValue("@NoOfTutorialHours", s.NoOfTutorialHours);
cmd.Parameters.AddWithValue("@NoOfLabHours", s.NoOfLabHours);
cmd.Parameters.AddWithValue("@NoOfEvaluationHours", s.NoOfEvaluationHours);
// connection open here
conn.Open();
int rows = cmd.ExecuteNonQuery();
//if the queryrun successfully the the value of rows will be greater than zero slse if value will be 0
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
conn.Close();
}
return(isSuccess);
}
//method to update data in databse form our application
public bool UpdateSubject(SubjectClass s)
{
//create a default return type and set its default values to false
bool isSuccess = false;
SQLiteConnection conn = new Classes.SqliteHelper().GetSQLiteConnection();
try
{
string sql = "update Subject set OfferdYear = @OfferdYear, OfferdSemester = @OfferdSemester, SubjectName = @SubjectName, SubjectCode = @SubjectCode, NoOfLectureHours = @NoOfLectureHours, NoOfTutorilaHours = @NoOfTutorialHours,NoOfLabHours = @NoOfLabHours, NoOfEvaluationHours = @NoOfEvaluationHours where SubjectCode = @SubjectCode";
SQLiteCommand cmd = new SQLiteCommand(sql, conn);
//create paramters to add values
cmd.Parameters.AddWithValue("@OfferdYear", s.OfferdYear);
cmd.Parameters.AddWithValue("@OfferdSemester", s.OfferdSemester);
cmd.Parameters.AddWithValue("@SubjectName", s.SubjectName);
cmd.Parameters.AddWithValue("@SubjectCode", s.SubjectCode);
cmd.Parameters.AddWithValue("@NoOfLectureHours", s.NoOfLectureHours);
cmd.Parameters.AddWithValue("@NoOfTutorialHours", s.NoOfTutorialHours);
cmd.Parameters.AddWithValue("@NoOfLabHours", s.NoOfLabHours);
cmd.Parameters.AddWithValue("@NoOfEvaluationHours", s.NoOfEvaluationHours);
conn.Open();
int rows = cmd.ExecuteNonQuery();
//if the query run successfully the the value of rows will be greater than zero slse if value will be 0
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
conn.Close();
}
return(isSuccess);
}
public bool DeleteSubject(SubjectClass s)
{
//create a default value and set its value to false
bool isSuccess = false;
//creating Sql connection
SQLiteConnection conn = new Classes.SqliteHelper().GetSQLiteConnection();
try
{
//sql to delete Data
string sql = "Delete from Subject where SubjectCode = @SubjectCode";
//creating sql command
SQLiteCommand cmd = new SQLiteCommand(sql, conn);
cmd.Parameters.AddWithValue("@SubjectCode", s.SubjectCode);
//open connection
conn.Open();
int rows = cmd.ExecuteNonQuery();
////if the query run successfully the the value of rows will be greater than zero slse if value will be 0
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
//close the connection
conn.Close();
}
return(isSuccess);
}