public int TMS_CourseCoordinate_UpdateDAL(CourseCoordinatorMapping _Coordinate, long CourseId)
{
return(ExecuteScalarInt32Sp("TMS_CourseCoordinator_Update",
ParamBuilder.Par("ID", _Coordinate.ID),
ParamBuilder.Par("CoordinateID", _Coordinate.ID),
ParamBuilder.Par("CourseID", CourseId),
ParamBuilder.Par("ModifiedBy", _Coordinate.ModifiedBy),
ParamBuilder.Par("ModifiedDate", _Coordinate.ModifiedDate)));
}
//public List<CourseCoordinate> CourseCoordinatorMapping(long CourseID)
//{
// List<CourseCoordinate> Course = new List<CourseCoordinate>();
// using (var conn = new SqlConnection(DBHelper.ConnectionString))
// {
// conn.Open();
// DynamicParameters dbParams = new DynamicParameters();
// dbParams.AddDynamicParams(new { CourseID = CourseID });
// using (var multi = conn.QueryMultiple("TMS_CourseCoordinator_GetAll", dbParams, commandType: System.Data.CommandType.StoredProcedure))
// {
// Course = multi.Read<CourseCoordinate>().AsList<CourseCoordinate>();
// // Total = multi.Read<int>().FirstOrDefault<int>();
// }
// conn.Close();
// }
// return Course.ToList();
//}
/// <returns>List<Classes>.</returns>
//public IList<CourseCoordinatorMapping> TMS_CourseCoordinator_GetAllDAL(long CourseId)
//{
// //var _CourseLanguageData = ExecuteListSp<CourseCoordinatorMapping>(@"TMS_CourseCoordinator_GetAll", ParamBuilder.Par("CourseID", CourseId));
// //return _CourseLanguageData;
// //List<CourseCoordinatorMapping> LoginUserList = new List<CourseCoordinatorMapping>();
// //var conString = DBHelper.ConnectionString;
// //using (var conn = new SqlConnection(conString))
// //{
// // conn.Open();
// // string qry = @"TMS_CourseCoordinator_GetAll";
// // DynamicParameters param = new DynamicParameters(new { CourseID = CourseId });
// // var ClassTraineeMappingDictionary = new Dictionary<long, CourseCoordinatorMapping>();
// // LoginUserList = conn.Query<CourseCoordinatorMapping, Person, CourseCoordinatorMapping>(
// // qry, (loginUsers, person) =>
// // {
// // CourseCoordinatorMapping ClassTraineeMappingEntry;
// // if (!ClassTraineeMappingDictionary.TryGetValue(loginUsers.ID, out ClassTraineeMappingEntry))
// // {
// // ClassTraineeMappingEntry = loginUsers;
// // ClassTraineeMappingEntry.Person = new List<Person>();
// // ClassTraineeMappingDictionary.Add(ClassTraineeMappingEntry.ID, ClassTraineeMappingEntry);
// // }
// // if (person != null)
// // ClassTraineeMappingEntry.Person.Add(person);
// // return ClassTraineeMappingEntry;
// // }, param, commandType: System.Data.CommandType.StoredProcedure,
// // splitOn: "CoordinateIDs")
// // .Distinct()
// // .ToList();
// // conn.Close();
// //}
// //LoginUserList.FirstOrDefault().DisplayName = LoginUserList.FirstOrDefault().Person.FirstOrDefault().P_DisplayName;
// //return LoginUserList;
// List<CourseCoordinatorMapping> LoginUserList = new List<CourseCoordinatorMapping>();
// var conString = DBHelper.ConnectionString;
// using (var conn = new SqlConnection(conString))
// {
// conn.Open();
// string qry = @"TMS_CourseCoordinator_GetAll";
// DynamicParameters param = new DynamicParameters();
// param.Add("@CourseID", CourseId);
// var LoginUsersDictionary = new Dictionary<long, CourseCoordinatorMapping>();
// LoginUserList = conn.Query<CourseCoordinatorMapping, Person, CourseCoordinatorMapping>(
// qry, (loginUsers, Groups) =>
// {
// CourseCoordinatorMapping loginUsersEntry;
// if (!LoginUsersDictionary.TryGetValue(loginUsers.ID, out loginUsersEntry))
// {
// loginUsersEntry = loginUsers;
// loginUsersEntry.Person = new List<Person>();
// LoginUsersDictionary.Add(loginUsersEntry.ID, loginUsersEntry);
// }
// if (Groups != null)
// loginUsersEntry.Person.Add(Groups);
// return loginUsersEntry;
// }, param, commandType: System.Data.CommandType.StoredProcedure,
// splitOn: "ID")
// .Distinct()
// .ToList();
// conn.Close();
// }
// LoginUserList.FirstOrDefault().DisplayName = LoginUserList.FirstOrDefault().Person.FirstOrDefault().P_DisplayName;
// return LoginUserList;
//}
public long TMS_CourseCoordinate_CreateDAL(CourseCoordinatorMapping _Coordinate, long CourseId)
{
var parameters = new[] { ParamBuilder.Par("ID", 0) };
return(ExecuteInt64withOutPutparameterSp("TMS_CourseCoordinator_Create", parameters,
ParamBuilder.Par("CoordinateID", _Coordinate.CoordinateID),
ParamBuilder.Par("CourseID", CourseId),
ParamBuilder.Par("CreatedBy", _Coordinate.CreatedBy),
ParamBuilder.Par("CreatedDate", _Coordinate.CreatedDate)));
}
public int TMS_CourseCoordinate_DeleteDAL(CourseCoordinatorMapping _Coordinate, long CourseId)
{
return(_CourseDAL.TMS_CourseCoordinate_DeleteDAL(_Coordinate, CourseId));
}
public long TMS_CourseCoordinate_CreateBAL(CourseCoordinatorMapping _Coordinate, long CourseId)
{
return(_CourseDAL.TMS_CourseCoordinate_CreateDAL(_Coordinate, CourseId));
}