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....!!! "); } }