public JsonResult AddCourseTitle(CourseTitle entity) { entity.Id = Guid.NewGuid(); var data = BaseEntityManager.AddEntity(entity); return(Json(data, JsonRequestBehavior.AllowGet)); }
public void CourseSelectOutput() { string splGetCourse = "SELECT * FROM Course"; try { using (SqlConnection conn = new SqlConnection(ConnectionString.connection)) { conn.Open(); using (SqlCommand cmSelectCourse = new SqlCommand(splGetCourse, conn)) { using (SqlDataReader drCourse = cmSelectCourse.ExecuteReader()) { Console.ForegroundColor = ConsoleColor.DarkMagenta; Console.WriteLine("----------------------------------------------------------------------------"); Console.WriteLine($"| {"TITLE",-8} | {"STREAM",-12} | {"COURSE",-14} | {"START DATE",-13} | {"END DATE",-13} |"); Console.WriteLine("----------------------------------------------------------------------------"); Console.WriteLine("----------------------------------------------------------------------------"); Console.ForegroundColor = ConsoleColor.White; while (drCourse.Read()) { CourseTitle = drCourse["CourseTitle"].ToString(); Stream = drCourse["Stream"].ToString(); CourseType = drCourse["CourseType"].ToString(); StartDate = drCourse["StartDate"].ToString(); EndDate = drCourse["EndDate"].ToString(); // Split the DATE string so as to get rid of the Time string[] StartDateList = StartDate.Split(' '); string[] EndDateList = EndDate.Split(' '); // Remove the unessessary empty space characters from inserted strings CourseTitle = CourseTitle.Replace(" ", string.Empty); Stream = Stream.Replace(" ", string.Empty); CourseType = CourseType.Replace(" ", string.Empty); StartDate = StartDate.Replace(" ", string.Empty); EndDate = EndDate.Replace(" ", string.Empty); Console.ForegroundColor = ConsoleColor.Magenta; Console.WriteLine($"| {CourseTitle,-8} | {Stream,-12} | {CourseType,-14} | {StartDateList[0],-13} | {EndDateList[0],-13} |"); Console.WriteLine("----------------------------------------------------------------------------"); Console.ForegroundColor = ConsoleColor.White; } Console.ForegroundColor = ConsoleColor.DarkMagenta; Console.WriteLine("----------------------------------------------------------------------------"); Console.WriteLine($"| {"TITLE",-8} | {"STREAM",-12} | {"COURSE",-14} | {"START DATE",-13} | {"END DATE",-13} |"); Console.WriteLine("----------------------------------------------------------------------------"); Console.ForegroundColor = ConsoleColor.White; } } } } catch (Exception ex) { Console.WriteLine(ex.Message); } }
public void Two_Instances_Have_The_Same_Hash_Code_If_The_Title_Is_The_Same() { var course1 = new CourseTitle("Philosophy"); var course2 = new CourseTitle("Philosophy"); Assert.Equal(course1.GetHashCode(), course2.GetHashCode()); }
public void Two_Instances_Are_Not_The_Same_If_The_Title_Is_Not_The_Same() { var course1 = new CourseTitle("Philosophy"); var course2 = new CourseTitle("Physics"); Assert.NotEqual(course1, course2); Assert.False(course1 == course2); }
public void Two_Instances_Are_The_Same_If_The_Title_Is_The_Same() { var course1 = new CourseTitle("Philosophy"); var course2 = new CourseTitle("Philosophy"); Assert.Equal(course1, course2); Assert.True(course1 == course2); }
public HttpResponseMessage UpdateCourseTitle(CourseTitle model) { try { Log.Info("QualificationController:UpdateCourseTitle", "Update CourseTitle START", string.Empty); UserContextModel objUser = new UserContextModel(); objUser.UserID = 1; objUser.CompanyCode = "devDB"; var data = _qualificationService.UpdateCourseTitle(model, objUser); Log.Info("QualificationController:UpdateCourseTitle", "Update CourseTitle END", string.Empty); return(this.Request.CreateResponse(HttpStatusCode.OK, data)); } catch (Exception ex) { var helper = new AppPresentationException(ex); return(helper.GetResponse(this)); } }
public ApplicationResponse UpdateCourseTitle(CourseTitle model, UserContextModel objUser) { try { var validationResponse = _titleValidation.Validate(CourseTypeValidation.ValidateAll_key, model, "Course title model can not be empty."); if (validationResponse.Messages != null && validationResponse.Messages.Count != 0) { throw new ValidationException(validationResponse); } model.CreatedBy = objUser.UserID; var data = _qualificationRepository.UpdateCourseTitle(model, objUser.CompanyCode); return(data); } catch (Exception ex) { var helper = new BusinessException(ex); throw helper.GetException(); } }
public ApplicationResponse AddCourseTitle(CourseTitle model, string DbName) { try { var parameters = new string[] { "TitleName", "CourseTypeId", "IsActive", "CreatedBy" }; var sqlParameterd = _dbHelper.CreateSqlParamByObj(model, parameters); DataTable dt = _dbHelper.GetDataTable(DbName, "[Common].[Master_AddCourseTitle]", sqlParameterd); return(new ApplicationResponse { Code = Convert.ToInt32(dt.Rows[0][0]), Message = Convert.ToString(dt.Rows[0][1]), }); } catch (Exception ex) { var helper = new Helpers.ExceptionHelper.DataException(ex); throw helper.GetException(); } }
public JsonResult ModifyCourseTitle(CourseTitle entity) { var data = BaseEntityManager.ModifyEntity(entity); return(Json(data, JsonRequestBehavior.AllowGet)); }