internal List <CourseSetup> GetAllCourseList(string Code)
{
string Parameter = "";
if (Code != "")
{
Parameter = " where Code='" + Code + "' ";
}
string query = @"SELECT ID,[Code],[CourseName],[Credit] FROM [Course] " + Parameter;
SqlCommand command = new SqlCommand(query, con);
con.Open();
SqlDataReader reader = command.ExecuteReader();
CourseSetup acourse = null;
var CrstList = new List <CourseSetup>();
if (reader.HasRows)
{
while (reader.Read())
{
acourse = new CourseSetup();
acourse.ID = reader["ID"].ToString();
acourse.Code = reader["Code"].ToString();
acourse.Name = reader["CourseName"].ToString();
acourse.Credit = reader["Credit"].ToString();
CrstList.Add(acourse);
}
}
con.Close();
return(CrstList);
}
public ActionResult Course(CourseSetup aCourseSetup)
{
string Alart = _courseManager.SaveCourse(aCourseSetup);
ViewBag.Message = Alart;
DepartmentList();
return(View());
}
internal string UpdateDepartment(CourseSetup acourse)
{
string Query = @"UPDATE [Course]
SET [Code] ='" + acourse.Code + "' ,[CourseName] ='" + acourse.Name + "',[Credit] ='" + acourse.Credit + "' ,[Description] ='" + acourse.Description + "',[DepartmentID] ='" + acourse.DeptID + "' ,[SemesterID] ='" + acourse.Semester + "' ,[Updateby] ='Sojol',[Update] = GETDATE() WHERE ID='" + acourse.ID + "'";
int rowEffect = DataTransfection.ExecuteNonQuery(Query);
if (rowEffect > 0)
{
return("Record is/are Update Sucessfully....!!");
}
else
{
throw new Exception("Record Update Failed....!!! ");
}
}
public string SaveCourse(CourseSetup acourse)
{
if (acourse.Name == "")
{
throw new Exception("Enter name ....!!!!!");
}
if (acourse.Code == "")
{
throw new Exception("Enter Code ....!!!!!");
}
int aTest = aCourseGetway.GetValidation(acourse.Code);
if (aTest > 0)
{
throw new Exception("this Code already Existed....!!!!!");
}
return(aCourseGetway.SaveDepartment(acourse));
}
internal string SaveDepartment(CourseSetup acourse)
{
string Query = @"INSERT INTO [Course]
([Code]
,[CourseName]
,[Credit]
,[Description]
,[DepartmentID]
,[SemesterID]
,[Addby]
,[Adddate])
VALUES
('" + acourse.Code + "','" + acourse.Name + "','" + acourse.Credit + "','" + acourse.Description + "','" + acourse.DeptID + "','" + acourse.Semester + "','Sojol',GETDATE())";
int rowEffect = DataTransfection.ExecuteNonQuery(Query);
if (rowEffect > 0)
{
return("Record is/are Saved Sucessfully....!!");
}
else
{
throw new Exception("Record Save Failed....!!! ");
}
}
