/// <summary>
/// Points the of contact delete dal.
/// </summary>
/// <param name="_OrganizationRelation">The organization relation.</param>
/// <returns>System.Int32.</returns>
public int PointOfContact_DeleteDAL(PointsOfContact _OrganizationRelation)
{
return(ExecuteScalarInt32Sp("TMS_OrganizationRelationToPerson_Delete",
ParamBuilder.Par("ID", _OrganizationRelation.ID),
ParamBuilder.Par("PersonID", _OrganizationRelation.PersonID),
ParamBuilder.Par("OrganizationID", _OrganizationRelation.OrganizationID),
ParamBuilder.Par("UpdatedBy", _OrganizationRelation.UpdatedBy),
ParamBuilder.Par("UpdatedDate", _OrganizationRelation.UpdatedDate)
));
}
/// <summary>
/// Organizations the links update dal.
/// </summary>
/// <param name="_objLinks">The object links.</param>
/// <returns>System.Int32.</returns>
public int OrganizationLinks_UpdateDAL(Links _objLinks)
{
return(ExecuteScalarInt32Sp("TMS_Links_Update",
ParamBuilder.Par("ID", _objLinks.ID),
ParamBuilder.Par("Link", _objLinks.Link),
ParamBuilder.Par("Description", _objLinks.Description),
ParamBuilder.Par("LinkType", _objLinks.LinkType),
ParamBuilder.Par("UpdatedBy", _objLinks.UpdatedBy),
ParamBuilder.Par("UpdatedDate", _objLinks.UpdatedDate)));
}
/// <summary>
/// TMSs the groups update dal.
/// </summary>
/// <param name="_ObjTMS_Groups">The object TMS groups.</param>
/// <returns>System.Int32.</returns>
public int TMS_Groups_UpdateDAL(SecurityGroups _ObjTMS_Groups)
{
return(ExecuteScalarInt32Sp("TMS_Groups_Update",
ParamBuilder.Par("GroupId", _ObjTMS_Groups.GroupId),
ParamBuilder.Par("PrimaryGroupName", _ObjTMS_Groups.PrimaryGroupName),
ParamBuilder.Par("SecondaryGroupName", _ObjTMS_Groups.SecondaryGroupName),
ParamBuilder.Par("IsDeleteAllowed", _ObjTMS_Groups.IsDeleteAllowed),
ParamBuilder.Par("UpdatedBy", _ObjTMS_Groups.UpdatedBy),
ParamBuilder.Par("UpdatedDate", _ObjTMS_Groups.UpdatedDate)));
}
/// <summary>
/// TMSs the users TMS groups mapping create dal.
/// </summary>
/// <param name="_ObjTMS_Groups">The object TMS groups.</param>
/// <param name="CreatedBy">The created by.</param>
/// <returns>System.Int64.</returns>
public long TMS_Users_TMS_GroupsMapping_CreateDAL(LoginUserGroups _ObjTMS_Groups, long CreatedBy)
{
var parameters = new[] { ParamBuilder.Par("MappingId", 0) };
return(ExecuteInt64withOutPutparameterSp("TMS_Users_TMS_GroupsMapping_Create", parameters,
ParamBuilder.Par("GroupId", _ObjTMS_Groups.GroupId),
ParamBuilder.Par("UserID", _ObjTMS_Groups.Id),
ParamBuilder.Par("CreatedBy", CreatedBy),
ParamBuilder.Par("CreatedDate", System.DateTime.UtcNow)));
}
public long AssigementHistory_CreateDAL(CRM_UserMapping _mapping)
{
return(ExecuteScalarInt32Sp("CRM_ProspectsAssignmentHistory_Create",
ParamBuilder.Par("PersonID", _mapping.PersonID),
ParamBuilder.Par("UserID", _mapping.UserID),
ParamBuilder.Par("UpdatedBy", _mapping.UpdatedBy),
ParamBuilder.Par("UpdatedOn", _mapping.UpdatedOn)
));
}
/// <summary>
/// Persons the email address update dal.
/// </summary>
/// <param name="_objEmailAddresses">The object email addresses.</param>
/// <param name="PersonId">The person identifier.</param>
/// <returns>System.Int32.</returns>
public int PersonEmailAddress_UpdateDAL(EmailAddresses _objEmailAddresses, long PersonId)
{
return(ExecuteScalarInt32Sp("TMS_PersonEmailAddresses_Update",
ParamBuilder.Par("ID", _objEmailAddresses.ID),
ParamBuilder.Par("PersonID", PersonId),
ParamBuilder.Par("Email", _objEmailAddresses.Email),
ParamBuilder.Par("IsPrimary", _objEmailAddresses.IsPrimary),
ParamBuilder.Par("UpdatedDate", _objEmailAddresses.UpdatedDate),
ParamBuilder.Par("UpdatedBy", _objEmailAddresses.UpdatedBy)));
}
public int TMS_CourseCoordinate_DeleteDAL(CourseCoordinatorMapping _Coordinate, long CourseId)
{
return(ExecuteScalarInt32Sp("TMS_CourseCoordinator_Delete",
ParamBuilder.Par("ID", _Coordinate.ID),
ParamBuilder.Par("CourseID", CourseId),
ParamBuilder.Par("UpdatedBy", _Coordinate.ModifiedBy),
ParamBuilder.Par("UpdatedDate", _Coordinate.ModifiedDate)
));
}
public int ManageLogistic_DuplicationCheckDAL(CourseLogisticRequirementsMapping _objlogmap)
{
{
return(ExecuteScalarSPInt32("CourseLogisticMap_DuplicationCheck",
ParamBuilder.Par("ID", _objlogmap.ID),
ParamBuilder.Par("CourseLogisticRequirementID", _objlogmap.CourseLogisticRequirementID),
ParamBuilder.Par("CourseID", _objlogmap.CourseID)
));
}
}
/// <summary>
/// TMSs the sessions delete dal.
/// </summary>
/// <param name="_Sessions">The sessions.</param>
/// <returns>System.Int32.</returns>
public int TMS_Sessions_DeleteDAL(Sessions _Sessions)
{
return(ExecuteScalarInt32Sp("TMS_Sessions_Delete",
ParamBuilder.Par("ID", _Sessions.ID),
ParamBuilder.Par("UpdatedBy", _Sessions.UpdatedBy),
ParamBuilder.Par("UpdatedDate", _Sessions.UpdatedDate)
));
}
//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)));
}
/// <summary>
/// TMSs the classes delete dal.
/// </summary>
/// <param name="_Classes">The classes.</param>
/// <returns>System.Int32.</returns>
public int TMS_SessionLogistics_DeleteDAL(CourseLogisticRequirements _Logistics, long ClassID)
{
return(ExecuteScalarInt32Sp("TMS_SessionLogistics_Delete",
ParamBuilder.Par("ID", _Logistics.ID),
ParamBuilder.Par("ClassID", 20009),
ParamBuilder.Par("UpdatedBy", _Logistics.UpdatedBy),
ParamBuilder.Par("UpdatedDate", _Logistics.UpdatedDate)
));
}
public long TMS_SessionLogistics_CreateDAL(CourseLogisticRequirements _Logistics, long ClassID)
{
var parameters = new[] { ParamBuilder.Par("ID", 0) };
return(ExecuteInt64withOutPutparameterSp("TMS_SessionLogistic_Create", parameters,
ParamBuilder.Par("LogisticID", _Logistics.ID),
ParamBuilder.Par("ClassID", 20009),
ParamBuilder.Par("CreatedBy", _Logistics.CreatedBy),
ParamBuilder.Par("CreatedDate", _Logistics.CreatedDate)));
}
/// <summary>
/// Trainers the open mapping create by person ids dal.
/// </summary>
/// <param name="_Classes">The classes.</param>
/// <param name="PersonIds">The person ids.</param>
/// <returns>System.Int64.</returns>
public long TrainerOpenMapping_CreateByPersonIdsDAL(ClassTrainerMapping _Classes, string PersonIds)
{
var parameters = new[] { ParamBuilder.Par("ID", 0) };
return(ExecuteInt64withOutPutparameterSp("TrainerOpenMapping_CreateByPersonIds", parameters,
ParamBuilder.Par("OpenId", _Classes.ClassID),
ParamBuilder.Par("PersonID", PersonIds),
ParamBuilder.Par("CreatedBy", _Classes.CreatedBy),
ParamBuilder.Par("CreatedDate", _Classes.CreatedDate)));
}
/// <summary>
/// TMSs the classes delete dal.
/// </summary>
/// <param name="_Classes">The classes.</param>
/// <returns>System.Int32.</returns>
public int TMS_CourseLanguage_DeleteDAL(MapLanguage _Corelanguage, long CourseId)
{
return(ExecuteScalarInt32Sp("TMS_CourseLanguage_Delete",
ParamBuilder.Par("ID", _Corelanguage.ID),
ParamBuilder.Par("CourseID", CourseId),
ParamBuilder.Par("UpdatedBy", _Corelanguage.ModifiedBy),
ParamBuilder.Par("UpdatedDate", _Corelanguage.ModifiedDate)
));
}
public long TMS_CourseFocusArea_CreateDAL(FocusAreas _Coordinate, long CourseId)
{
var parameters = new[] { ParamBuilder.Par("ID", 0) };
return(ExecuteInt64withOutPutparameterSp("TMS_CourseFocus_Create", parameters,
ParamBuilder.Par("FocusID", _Coordinate.FocusID),
ParamBuilder.Par("CourseID", CourseId),
ParamBuilder.Par("CreatedBy", _Coordinate.CreatedBy),
ParamBuilder.Par("CreatedDate", _Coordinate.CreatedDate)));
}
/// <summary>
/// TMSs the attachment completed organization logo dal.
/// </summary>
/// <param name="_objTMS_Attachments">The object TMS attachments.</param>
/// <returns>System.Int32.</returns>
public int TMS_Attachment_CompletedOrganizationLogoDAL(TMS_Attachments _objTMS_Attachments)
{
return(ExecuteScalarInt32Sp("TMS_Attachment_CompletedOrganizationLogo",
ParamBuilder.Par("ID", _objTMS_Attachments.ID),
ParamBuilder.Par("OpenID", _objTMS_Attachments.OpenID),
ParamBuilder.Par("OpenType", _objTMS_Attachments.OpenType),
ParamBuilder.Par("FileParentRootFolder", _objTMS_Attachments.FileParentRootFolder),
ParamBuilder.Par("FilePath", _objTMS_Attachments.FilePath),
ParamBuilder.Par("CompletedDate", _objTMS_Attachments.CompletedDate)));
}
public int TMS_CourseFocusArea_DeleteDAL(FocusAreas _Coordinate, long CourseId)
{
return(ExecuteScalarInt32Sp("TMS_CourseFocus_Delete",
ParamBuilder.Par("ID", _Coordinate.ID),
ParamBuilder.Par("CourseID", CourseId),
ParamBuilder.Par("UpdatedBy", _Coordinate.UpdatedBy),
ParamBuilder.Par("UpdatedDate", _Coordinate.UpdatedDate)
));
}
public long ReassignProspectDAL(CRM_UserMapping _mapping)
{
return(ExecuteScalarInt32Sp("CRM_UserMapping_Create",
ParamBuilder.Par("PersonID", _mapping.PersonID),
ParamBuilder.Par("UserID", _mapping.UserID),
ParamBuilder.Par("UpdatedBy", _mapping.UpdatedBy),
ParamBuilder.Par("UpdatedOn", _mapping.UpdatedOn)
));
}
/// <summary>
/// Updates the user locked out.
/// </summary>
/// <param name="Email">The email.</param>
/// <param name="UserID">The user identifier.</param>
/// <param name="LockedOutAttempt">The locked out attempt.</param>
/// <param name="IsLockedOut">if set to <c>true</c> [is locked out].</param>
/// <returns>System.Int32.</returns>
public int UpdateUserLockedOut(string Email, long UserID, int LockedOutAttempt, bool IsLockedOut)
{
return(ExecuteScalarSP("TMS_Users_LockedOut", System.Data.CommandType.StoredProcedure,
ParamBuilder.Par("UserID", UserID),
ParamBuilder.Par("Email", Email),
ParamBuilder.Par("LockedOutAttempt", LockedOutAttempt),
ParamBuilder.Par("IsLockedOut", IsLockedOut),
ParamBuilder.Par("LockedOutDate", System.DateTime.Now)
));
}
public int CourseUpdateDAL(CRMCourses _courses)
{
return(ExecuteScalarInt32Sp("CRM_CourseUpdate",
ParamBuilder.Par("ID", _courses.ID),
ParamBuilder.Par("PrimaryCourseName", _courses.PrimaryCourseName),
ParamBuilder.Par("SecondaryCourseName", _courses.SecondaryCourseName),
ParamBuilder.Par("Description", _courses.Description),
ParamBuilder.Par("ModifiedBy", _courses.ModifiedBy),
ParamBuilder.Par("ModifiedDate", _courses.ModifiedOn)));
}
/// <summary>
/// Organizations the links delete dal.
/// </summary>
/// <param name="_objLinks">The object links.</param>
/// <param name="OrganizationId">The organization identifier.</param>
/// <returns><c>true</c> if XXXX, <c>false</c> otherwise.</returns>
public bool OrganizationLinks_DeleteDAL(Links _objLinks, long OrganizationId)
{
var parameters = new[] { ParamBuilder.Par("IsDeleted", false) };
return(ExecuteBoolwithOutPutparameterSp("TMS_OrganizationLinks_Delete", parameters,
ParamBuilder.Par("LinkID", _objLinks.ID),
ParamBuilder.Par("OrganizationID", OrganizationId),
ParamBuilder.Par("UpdatedBy", _objLinks.UpdatedBy),
ParamBuilder.Par("UpdatedDate", _objLinks.UpdatedDate)));
}
/// <summary>
/// TMSs the classes create dal.
/// </summary>
/// <param name="_Classes">The classes.</param>
/// <returns>System.Int64.</returns>
public long TMS_CourseLanguage_CreateDAL(MapLanguage _Corelanguage, long CourseId)
{
var parameters = new[] { ParamBuilder.Par("ID", 0) };
return(ExecuteInt64withOutPutparameterSp("TMS_CourseLanguage_Create", parameters,
ParamBuilder.Par("LanguageID", _Corelanguage.LanguageID),
ParamBuilder.Par("CourseID", CourseId),
ParamBuilder.Par("CreatedBy", _Corelanguage.CreatedBy),
ParamBuilder.Par("CreatedDate", _Corelanguage.CreatedDate)));
}
/// <summary>
/// Persons the levels create dal.
/// </summary>
/// <param name="_objPersonLevels">The object person levels.</param>
/// <returns>System.Int64.</returns>
public long PersonLevels_CreateDAL(PersonLevels _objPersonLevels)
{
var parameters = new[] { ParamBuilder.Par("ID", 0) };
return(ExecuteInt64withOutPutparameterSp("TMS_PersonLevels_Create", parameters,
ParamBuilder.Par("PersonID", _objPersonLevels.PersonID),
ParamBuilder.Par("Name", _objPersonLevels.Name),
ParamBuilder.Par("Description", _objPersonLevels.Description),
ParamBuilder.Par("CreatedBy", _objPersonLevels.CreatedBy),
ParamBuilder.Par("CreatedDate", _objPersonLevels.CreatedDate)));
}
public long ManageCourseClassMeterialMap_CreateDAL(ClassMeterialsMapping _mapping)
{
var parameters = new[] { ParamBuilder.Par("ID", 0) };
return(ExecuteInt64withOutPutparameterSp("ManageClassCourseMeterialMap_Create", parameters,
ParamBuilder.Par("CourseMaterialID", _mapping.CourseMaterialID),
ParamBuilder.Par("ClassID", _mapping.ClassID),
ParamBuilder.Par("CreatedBy", _mapping.CreatedBy),
ParamBuilder.Par("CreatedDate", _mapping.CreatedOn)
));
}
public int TMS_ClassLogistics_UpdateDAL(CourseLogisticRequirements _Logistics, long ClassID)
{
return(ExecuteScalarInt32Sp("TMS_ClassLogistic_Update",
ParamBuilder.Par("ID", _Logistics.ID),
ParamBuilder.Par("LogisticsID", _Logistics.ID),
ParamBuilder.Par("ClassID", ClassID),
ParamBuilder.Par("ModifiedBy", _Logistics.UpdatedBy),
ParamBuilder.Par("ModifiedDate", _Logistics.UpdatedDate)
));
}
public long ManageLogisticMap_CreateDAL(CourseLogisticRequirementsMapping _mapping)
{
var parameters = new[] { ParamBuilder.Par("ID", 0) };
return(ExecuteInt64withOutPutparameterSp("CourseLogisticMapping_Create", parameters,
ParamBuilder.Par("CourseLogisticRequirementID", _mapping.CourseLogisticRequirementID),
ParamBuilder.Par("CourseID", _mapping.CourseID),
ParamBuilder.Par("CreatedBy", _mapping.CreatedBy),
ParamBuilder.Par("CreatedDate", _mapping.CreatedDate)
));
}
/// <summary>
/// Persons the availability create dal.
/// </summary>
/// <param name="_objPersonAvailability">The object person availability.</param>
/// <returns>System.Int64.</returns>
public long PersonAvailability_CreateDAL(PersonAvailability _objPersonAvailability)
{
var parameters = new[] { ParamBuilder.Par("ID", 0) };
return(ExecuteInt64withOutPutparameterSp("TMS_PersonAvailability_Create", parameters,
ParamBuilder.Par("PersonID", _objPersonAvailability.PersonID),
ParamBuilder.Par("FromDate", _objPersonAvailability.FromDate),
ParamBuilder.Par("ToDate", _objPersonAvailability.ToDate),
ParamBuilder.Par("CreatedBy", _objPersonAvailability.CreatedBy),
ParamBuilder.Par("CreatedDate", _objPersonAvailability.CreatedDate)));
}
/// <summary>
/// Persons the email address create dal.
/// </summary>
/// <param name="_objEmailAddresses">The object email addresses.</param>
/// <param name="PersonId">The person identifier.</param>
/// <returns>System.Int64.</returns>
public long PersonEmailAddress_CreateDAL(EmailAddresses _objEmailAddresses, long PersonId)
{
var parameters = new[] { ParamBuilder.Par("ID", 0) };
return(ExecuteInt64withOutPutparameterSp("TMS_PersonEmailAddresses_Create", parameters,
ParamBuilder.Par("PersonID", PersonId),
ParamBuilder.Par("Email", _objEmailAddresses.Email),
ParamBuilder.Par("IsPrimary", _objEmailAddresses.IsPrimary),
ParamBuilder.Par("CreatedDate", _objEmailAddresses.CreatedDate),
ParamBuilder.Par("CreatedBy", _objEmailAddresses.CreatedBy)));
}
/// <summary>
/// Courses the materials create dal.
/// </summary>
/// <param name="_objCourseMaterials">The object course materials.</param>
/// <returns>System.Int64.</returns>
public long CourseMaterials_CreateDAL(CourseMaterials _objCourseMaterials)
{
var parameters = new[] { ParamBuilder.Par("ID", 0) };
return(ExecuteInt64withOutPutparameterSp("TMS_CourseMaterials_Create", parameters,
ParamBuilder.Par("PrimaryMaterial", _objCourseMaterials.PrimaryMaterial),
ParamBuilder.Par("SecondaryMaterial", _objCourseMaterials.SecondaryMaterial),
ParamBuilder.Par("OrganizationID", _objCourseMaterials.OrganizationID),
ParamBuilder.Par("CreatedBy", _objCourseMaterials.CreatedBy),
ParamBuilder.Par("CreatedDate", _objCourseMaterials.CreatedDate)));
}
/// <summary>
/// Persons the skills interest create dal.
/// </summary>
/// <param name="_objPersonSkillsInterest">The object person skills interest.</param>
/// <returns>System.Int64.</returns>
public long PersonSkillsInterest_CreateDAL(string PersonIds, long user, string date, long cid, long OrganizationID)
{
var parameters = new[] { ParamBuilder.Par("ID", 0) };
return(ExecuteInt64withOutPutparameterSp("TMS_PersonSkillInterestfocus_Create", parameters,
ParamBuilder.Par("OrganizationID", OrganizationID),
ParamBuilder.Par("FocusID", PersonIds),
ParamBuilder.Par("CreatedBy", user),
ParamBuilder.Par("CreatedDate", date),
ParamBuilder.Par("PersonID", cid)));
}
