public void Delete(int Id, out string Message, out System.Drawing.Color Color)
{
Object.Subject subject = new Object.Subject();
subject.Id = Id;
int resultNum = crud.Delete(subject);
message.Delete(resultNum, out Message, out Color);
}
public void Update(int Id, string SubjectName, out string Message, out System.Drawing.Color Color)
{
Object.Subject subject = new Object.Subject();
subject.Id = Id;
subject.SubjectName = SubjectName;
int resultNum = crud.Update(subject);
message.Update(resultNum, out Message, out Color);
}
public DataTable ReadWithSelectSubjectId(int Id)
{
//Gets the selected subject id value from gridview and displays teacher full name gridview
DataTable table = new DataTable();
table.Columns.Add("EGN");
table.Columns.Add("FullName");
Object.Subject subject = new Object.Subject();
subject.Id = Id;
return(crud.ReadWithSelectSubjectId(table, subject));
}
public int Delete(Object.Subject subject)
{
using (SqlConnection con = new SqlConnection(SharedMethods.getConnectionString()))
{
SqlCommand cmd = new SqlCommand("Delete From tblSubject Where Id = @Id", con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@Id", subject.Id);
con.Open();
return((int)cmd.ExecuteNonQuery());
}
}
public void Create(string SubjectName, out string Message, out System.Drawing.Color Color)
{
Object.Subject subject = new Object.Subject();
subject.SubjectName = SubjectName.Trim();
DataTable table = new DataTable();
table.Columns.Add("Id");
table.Columns.Add("SubjectName");
int resultNum = crud.Create(subject);
message.Create(resultNum, out Message, out Color);
}
public int Create(Object.Subject subject)
{
using (SqlConnection con = new SqlConnection(SharedMethods.getConnectionString()))
{
SqlCommand cmd = new SqlCommand("spAddSubject_tblSubject", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@SubjectName", subject.SubjectName);
SqlParameter Result = new SqlParameter("@ResultNumber", SqlDbType.Int);
Result.Direction = ParameterDirection.Output;
cmd.Parameters.Add(Result);
con.Open();
cmd.ExecuteScalar();
con.Close();
return((int)Result.Value);
}
}
public DataTable ReadWithSelectSubjectId(DataTable table, Object.Subject subject)
{
using (SqlConnection con = new SqlConnection(SharedMethods.getConnectionString()))
{
SqlCommand cmd = new SqlCommand("Select EGN,FullName From vwTeacherInfo_tblTeacherInfo Where SubjectId = @SubjectId", con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@SubjectId", subject.Id);
con.Open();
using (SqlDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
DataRow row = table.NewRow();
row["EGN"] = rdr["EGN"];
row["FullName"] = rdr["FullName"];
table.Rows.Add(row);
}
return(table);
}
}
}
