public double GetRemainingCredit(int id)
{
CourseAssaign course = courseAssaign.GetCreditInformation(id);
double credit = course.RemainingCredit;
return(credit);
}
public double GetCreditToBeTaken(int id)
{
CourseAssaign course = courseAssaign.GetCreditInformation(id);
double credit = course.CreditToBeTaken;
return(credit);
}
public ActionResult Save(CourseAssaign assaign)
{
ViewBag.Message = courseAssaign.SetCourseAssaignInformation(assaign);
ViewBag.Departments = courseAssaign.GetDepartmentDropdownList();
return(View());
}
public string SetCourseAssaignInformation(CourseAssaign courseAssaign)
{
if (IsCourseExist(courseAssaign.CourseID))
{
return("1");
// return "<h3 class='alert alert-danger'>This Course Already Assaign to a teacher</h3>";
}
else if (courseAssaignToTeacherGateway.SetCourseAssaignInformation(courseAssaign))
{
return("2");
// return "<h3 class='alert alert-success'>The Course Assaign Information Saved Successfully</h3>";
}
else
{
return("3");
// return "<h3 class='alert alert-danger'>Error While Entering data into database</h3>";
}
}
public CourseAssaign GetCreditInformation(int id)
{
string name = "";
GenarateConnection();
using (Connection)
{
string querys = "select * from Teacher where ID =@Id ;";
Command = new SqlCommand(querys, Connection);
Command.Parameters.Clear();
Connection.Open();
Command.Parameters.Add("@Id", SqlDbType.Int);
Command.Parameters["@Id"].Value = id;
Reader = Command.ExecuteReader();
while (Reader.Read())
{
name = Reader["Name"].ToString();
}
Reader.Close();
Connection.Close();
}
CourseAssaign courseAssaign = new CourseAssaign();
GenarateConnection();
using (Connection)
{
string query = "select * from CourseAssaign where Teacher =@Teacher and Visible = @Visible ;";
Command = new SqlCommand(query, Connection);
Command.Parameters.Clear();
Connection.Open();
Command.Parameters.Add("@Teacher", SqlDbType.VarChar);
Command.Parameters["@Teacher"].Value = name;
Command.Parameters.Add("@Visible", SqlDbType.VarChar);
Command.Parameters["@Visible"].Value = 1;
Reader = Command.ExecuteReader();
if (Reader.HasRows)
{
while (Reader.Read())
{
courseAssaign.CreditToBeTaken = Convert.ToDouble(Reader["CreditToBeTaken"].ToString());
courseAssaign.RemainingCredit = Convert.ToDouble(Reader["RemainingCredit"].ToString());
}
Reader.Close();
}
else
{
Connection.Close();
string querys = "select * from Teacher where ID =@Id ;";
Command = new SqlCommand(querys, Connection);
Command.Parameters.Clear();
Connection.Open();
Command.Parameters.Add("@Id", SqlDbType.Int);
Command.Parameters["@Id"].Value = id;
Reader = Command.ExecuteReader();
if (Reader.HasRows)
{
while (Reader.Read())
{
courseAssaign.CreditToBeTaken = Convert.ToDouble(Reader["CreditToBeTaken"].ToString());
courseAssaign.RemainingCredit = Convert.ToDouble(Reader["CreditToBeTaken"].ToString());
}
}
Reader.Close();
}
Connection.Close();
}
return(courseAssaign);
}
public bool SetCourseAssaignInformation(CourseAssaign courseAssaign)
{
string name = "";
GenarateConnection();
using (Connection)
{
string querys = "select * from Teacher where ID =@Id ;";
Command = new SqlCommand(querys, Connection);
Command.Parameters.Clear();
Connection.Open();
Command.Parameters.Add("@Id", SqlDbType.Int);
Command.Parameters["@Id"].Value = courseAssaign.Teacher;
Reader = Command.ExecuteReader();
while (Reader.Read())
{
name = Reader["Name"].ToString();
}
Reader.Close();
Connection.Close();
}
GenarateConnection();
using (Connection)
{
Connection.Open();
string query =
"insert into CourseAssaign(Department,Teacher,CourseID,CourseName,Credit,CreditToBeTaken,RemainingCredit,Visible) values (@Department,@Teacher,@CourseID,@CourseName,@Credit,@CreditToBeTaken,@RemainingCredit,@Visible);";
Command = new SqlCommand(query, Connection);
Command.Parameters.Clear();
Command.Parameters.Add("@Department", SqlDbType.VarChar);
Command.Parameters["@Department"].Value = courseAssaign.Department;
Command.Parameters.Add("@Teacher", SqlDbType.VarChar);
Command.Parameters["@Teacher"].Value = name;
Command.Parameters.Add("@CourseID", SqlDbType.VarChar);
Command.Parameters["@CourseID"].Value = courseAssaign.CourseID;
Command.Parameters.Add("@CourseName", SqlDbType.VarChar);
Command.Parameters["@CourseName"].Value = courseAssaign.Name;
Command.Parameters.Add("@Credit", SqlDbType.Decimal);
Command.Parameters["@Credit"].Value = courseAssaign.Credit;
Command.Parameters.Add("@CreditToBeTaken", SqlDbType.Decimal);
Command.Parameters["@CreditToBeTaken"].Value = courseAssaign.CreditToBeTaken;
double remainingCredit = courseAssaign.RemainingCredit - courseAssaign.Credit;
Command.Parameters.Add("@RemainingCredit", SqlDbType.Decimal);
Command.Parameters["@RemainingCredit"].Value = remainingCredit;
int visible = 1;
Command.Parameters.Add("@Visible", SqlDbType.Decimal);
Command.Parameters["@Visible"].Value = visible;
try
{
Command.ExecuteNonQuery();
Connection.Close();
return(true);
}
catch (Exception)
{
throw new Exception("Error While Entering data into database");
}
}
}
