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));
}
