public object Execute(ExecutorContext context)
{
var cmdletContext = context as CmdletContext;
// create request
var request = new Amazon.IoT.Model.CreateOTAUpdateRequest();
if (cmdletContext.AdditionalParameter != null)
{
request.AdditionalParameters = cmdletContext.AdditionalParameter;
}
// populate AwsJobAbortConfig
var requestAwsJobAbortConfigIsNull = true;
request.AwsJobAbortConfig = new Amazon.IoT.Model.AwsJobAbortConfig();
List <Amazon.IoT.Model.AwsJobAbortCriteria> requestAwsJobAbortConfig_awsJobAbortConfig_AbortCriteriaList = null;
if (cmdletContext.AwsJobAbortConfig_AbortCriteriaList != null)
{
requestAwsJobAbortConfig_awsJobAbortConfig_AbortCriteriaList = cmdletContext.AwsJobAbortConfig_AbortCriteriaList;
}
if (requestAwsJobAbortConfig_awsJobAbortConfig_AbortCriteriaList != null)
{
request.AwsJobAbortConfig.AbortCriteriaList = requestAwsJobAbortConfig_awsJobAbortConfig_AbortCriteriaList;
requestAwsJobAbortConfigIsNull = false;
}
// determine if request.AwsJobAbortConfig should be set to null
if (requestAwsJobAbortConfigIsNull)
{
request.AwsJobAbortConfig = null;
}
// populate AwsJobExecutionsRolloutConfig
var requestAwsJobExecutionsRolloutConfigIsNull = true;
request.AwsJobExecutionsRolloutConfig = new Amazon.IoT.Model.AwsJobExecutionsRolloutConfig();
System.Int32?requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_MaximumPerMinute = null;
if (cmdletContext.AwsJobExecutionsRolloutConfig_MaximumPerMinute != null)
{
requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_MaximumPerMinute = cmdletContext.AwsJobExecutionsRolloutConfig_MaximumPerMinute.Value;
}
if (requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_MaximumPerMinute != null)
{
request.AwsJobExecutionsRolloutConfig.MaximumPerMinute = requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_MaximumPerMinute.Value;
requestAwsJobExecutionsRolloutConfigIsNull = false;
}
Amazon.IoT.Model.AwsJobExponentialRolloutRate requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRate = null;
// populate ExponentialRate
var requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRateIsNull = true;
requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRate = new Amazon.IoT.Model.AwsJobExponentialRolloutRate();
System.Int32?requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRate_exponentialRate_BaseRatePerMinute = null;
if (cmdletContext.ExponentialRate_BaseRatePerMinute != null)
{
requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRate_exponentialRate_BaseRatePerMinute = cmdletContext.ExponentialRate_BaseRatePerMinute.Value;
}
if (requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRate_exponentialRate_BaseRatePerMinute != null)
{
requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRate.BaseRatePerMinute = requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRate_exponentialRate_BaseRatePerMinute.Value;
requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRateIsNull = false;
}
System.Double?requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRate_exponentialRate_IncrementFactor = null;
if (cmdletContext.ExponentialRate_IncrementFactor != null)
{
requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRate_exponentialRate_IncrementFactor = cmdletContext.ExponentialRate_IncrementFactor.Value;
}
if (requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRate_exponentialRate_IncrementFactor != null)
{
requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRate.IncrementFactor = requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRate_exponentialRate_IncrementFactor.Value;
requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRateIsNull = false;
}
Amazon.IoT.Model.AwsJobRateIncreaseCriteria requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRate_awsJobExecutionsRolloutConfig_ExponentialRate_RateIncreaseCriteria = null;
// populate RateIncreaseCriteria
var requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRate_awsJobExecutionsRolloutConfig_ExponentialRate_RateIncreaseCriteriaIsNull = true;
requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRate_awsJobExecutionsRolloutConfig_ExponentialRate_RateIncreaseCriteria = new Amazon.IoT.Model.AwsJobRateIncreaseCriteria();
System.Int32?requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRate_awsJobExecutionsRolloutConfig_ExponentialRate_RateIncreaseCriteria_rateIncreaseCriteria_NumberOfNotifiedThing = null;
if (cmdletContext.RateIncreaseCriteria_NumberOfNotifiedThing != null)
{
requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRate_awsJobExecutionsRolloutConfig_ExponentialRate_RateIncreaseCriteria_rateIncreaseCriteria_NumberOfNotifiedThing = cmdletContext.RateIncreaseCriteria_NumberOfNotifiedThing.Value;
}
if (requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRate_awsJobExecutionsRolloutConfig_ExponentialRate_RateIncreaseCriteria_rateIncreaseCriteria_NumberOfNotifiedThing != null)
{
requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRate_awsJobExecutionsRolloutConfig_ExponentialRate_RateIncreaseCriteria.NumberOfNotifiedThings = requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRate_awsJobExecutionsRolloutConfig_ExponentialRate_RateIncreaseCriteria_rateIncreaseCriteria_NumberOfNotifiedThing.Value;
requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRate_awsJobExecutionsRolloutConfig_ExponentialRate_RateIncreaseCriteriaIsNull = false;
}
System.Int32?requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRate_awsJobExecutionsRolloutConfig_ExponentialRate_RateIncreaseCriteria_rateIncreaseCriteria_NumberOfSucceededThing = null;
if (cmdletContext.RateIncreaseCriteria_NumberOfSucceededThing != null)
{
requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRate_awsJobExecutionsRolloutConfig_ExponentialRate_RateIncreaseCriteria_rateIncreaseCriteria_NumberOfSucceededThing = cmdletContext.RateIncreaseCriteria_NumberOfSucceededThing.Value;
}
if (requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRate_awsJobExecutionsRolloutConfig_ExponentialRate_RateIncreaseCriteria_rateIncreaseCriteria_NumberOfSucceededThing != null)
{
requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRate_awsJobExecutionsRolloutConfig_ExponentialRate_RateIncreaseCriteria.NumberOfSucceededThings = requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRate_awsJobExecutionsRolloutConfig_ExponentialRate_RateIncreaseCriteria_rateIncreaseCriteria_NumberOfSucceededThing.Value;
requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRate_awsJobExecutionsRolloutConfig_ExponentialRate_RateIncreaseCriteriaIsNull = false;
}
// determine if requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRate_awsJobExecutionsRolloutConfig_ExponentialRate_RateIncreaseCriteria should be set to null
if (requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRate_awsJobExecutionsRolloutConfig_ExponentialRate_RateIncreaseCriteriaIsNull)
{
requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRate_awsJobExecutionsRolloutConfig_ExponentialRate_RateIncreaseCriteria = null;
}
if (requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRate_awsJobExecutionsRolloutConfig_ExponentialRate_RateIncreaseCriteria != null)
{
requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRate.RateIncreaseCriteria = requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRate_awsJobExecutionsRolloutConfig_ExponentialRate_RateIncreaseCriteria;
requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRateIsNull = false;
}
// determine if requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRate should be set to null
if (requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRateIsNull)
{
requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRate = null;
}
if (requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRate != null)
{
request.AwsJobExecutionsRolloutConfig.ExponentialRate = requestAwsJobExecutionsRolloutConfig_awsJobExecutionsRolloutConfig_ExponentialRate;
requestAwsJobExecutionsRolloutConfigIsNull = false;
}
// determine if request.AwsJobExecutionsRolloutConfig should be set to null
if (requestAwsJobExecutionsRolloutConfigIsNull)
{
request.AwsJobExecutionsRolloutConfig = null;
}
// populate AwsJobPresignedUrlConfig
var requestAwsJobPresignedUrlConfigIsNull = true;
request.AwsJobPresignedUrlConfig = new Amazon.IoT.Model.AwsJobPresignedUrlConfig();
System.Int64?requestAwsJobPresignedUrlConfig_awsJobPresignedUrlConfig_ExpiresInSec = null;
if (cmdletContext.AwsJobPresignedUrlConfig_ExpiresInSec != null)
{
requestAwsJobPresignedUrlConfig_awsJobPresignedUrlConfig_ExpiresInSec = cmdletContext.AwsJobPresignedUrlConfig_ExpiresInSec.Value;
}
if (requestAwsJobPresignedUrlConfig_awsJobPresignedUrlConfig_ExpiresInSec != null)
{
request.AwsJobPresignedUrlConfig.ExpiresInSec = requestAwsJobPresignedUrlConfig_awsJobPresignedUrlConfig_ExpiresInSec.Value;
requestAwsJobPresignedUrlConfigIsNull = false;
}
// determine if request.AwsJobPresignedUrlConfig should be set to null
if (requestAwsJobPresignedUrlConfigIsNull)
{
request.AwsJobPresignedUrlConfig = null;
}
// populate AwsJobTimeoutConfig
var requestAwsJobTimeoutConfigIsNull = true;
request.AwsJobTimeoutConfig = new Amazon.IoT.Model.AwsJobTimeoutConfig();
System.Int64?requestAwsJobTimeoutConfig_awsJobTimeoutConfig_InProgressTimeoutInMinute = null;
if (cmdletContext.AwsJobTimeoutConfig_InProgressTimeoutInMinute != null)
{
requestAwsJobTimeoutConfig_awsJobTimeoutConfig_InProgressTimeoutInMinute = cmdletContext.AwsJobTimeoutConfig_InProgressTimeoutInMinute.Value;
}
if (requestAwsJobTimeoutConfig_awsJobTimeoutConfig_InProgressTimeoutInMinute != null)
{
request.AwsJobTimeoutConfig.InProgressTimeoutInMinutes = requestAwsJobTimeoutConfig_awsJobTimeoutConfig_InProgressTimeoutInMinute.Value;
requestAwsJobTimeoutConfigIsNull = false;
}
// determine if request.AwsJobTimeoutConfig should be set to null
if (requestAwsJobTimeoutConfigIsNull)
{
request.AwsJobTimeoutConfig = null;
}
if (cmdletContext.Description != null)
{
request.Description = cmdletContext.Description;
}
if (cmdletContext.File != null)
{
request.Files = cmdletContext.File;
}
if (cmdletContext.OtaUpdateId != null)
{
request.OtaUpdateId = cmdletContext.OtaUpdateId;
}
if (cmdletContext.Protocol != null)
{
request.Protocols = cmdletContext.Protocol;
}
if (cmdletContext.RoleArn != null)
{
request.RoleArn = cmdletContext.RoleArn;
}
if (cmdletContext.Tag != null)
{
request.Tags = cmdletContext.Tag;
}
if (cmdletContext.Target != null)
{
request.Targets = cmdletContext.Target;
}
if (cmdletContext.TargetSelection != null)
{
request.TargetSelection = cmdletContext.TargetSelection;
}
CmdletOutput output;
// issue call
var client = Client ?? CreateClient(_CurrentCredentials, _RegionEndpoint);
try
{
var response = CallAWSServiceOperation(client, request);
object pipelineOutput = null;
pipelineOutput = cmdletContext.Select(response, this);
output = new CmdletOutput
{
PipelineOutput = pipelineOutput,
ServiceResponse = response
};
}
catch (Exception e)
{
output = new CmdletOutput {
ErrorResponse = e
};
}
return(output);
}
protected void MapFrom(DataRow dr)
{
PSSkillId = dr["PS_SkillId"] != DBNull.Value ? Convert.ToInt64(dr["PS_SkillId"]) : PSSkillId = null;
PSSchoolId = dr["PS_SchoolId"] != DBNull.Value ? Convert.ToInt64(dr["PS_SchoolId"]) : PSSchoolId = null;
PSSchoolSubId = dr["PS_SchoolSubId"] != DBNull.Value ? Convert.ToInt64(dr["PS_SchoolSubId"]) : PSSchoolSubId = null;
PSSubjectId = dr["PS_SubjectId"] != DBNull.Value ? Convert.ToInt64(dr["PS_SubjectId"]) : PSSubjectId = null;
PSFacultyId = dr["PS_FacultyId"] != DBNull.Value ? Convert.ToInt64(dr["PS_FacultyId"]) : PSFacultyId = null;
PSSkillName = dr["PS_SkillName"] != DBNull.Value ? Convert.ToString(dr["PS_SkillName"]) : PSSkillName = null;
PSSkillDescription = dr["PS_SkillDescription"] != DBNull.Value ? Convert.ToString(dr["PS_SkillDescription"]) : PSSkillDescription = null;
PSExtra = dr["PS_Extra"] != DBNull.Value ? Convert.ToString(dr["PS_Extra"]) : PSExtra = null;
PSDate = dr["PS_Date"] != DBNull.Value ? Convert.ToDateTime(dr["PS_Date"]) : PSDate = null;
PSStatus = dr["PS_Status"] != DBNull.Value ? Convert.ToInt32(dr["PS_Status"]) : PSStatus = null;
}
protected void MapFrom(DataRow dr)
{
ECEventId = dr["EC_EventId"] != DBNull.Value ? Convert.ToInt64(dr["EC_EventId"]) : ECEventId = null;
ECDepartmentId = dr["EC_DepartmentId"] != DBNull.Value ? Convert.ToInt64(dr["EC_DepartmentId"]) : ECDepartmentId = null;
ECFacultyId = dr["EC_FacultyId"] != DBNull.Value ? Convert.ToInt64(dr["EC_FacultyId"]) : ECFacultyId = null;
ECSchoolCategoryId = dr["EC_SchoolCategoryId"] != DBNull.Value ? Convert.ToInt64(dr["EC_SchoolCategoryId"]) : ECSchoolCategoryId = null;
ECSubSchoolCategoryId = dr["EC_SubSchoolCategoryId"] != DBNull.Value ? Convert.ToInt64(dr["EC_SubSchoolCategoryId"]) : ECSubSchoolCategoryId = null;
ECEventName = dr["EC_EventName"] != DBNull.Value ? Convert.ToString(dr["EC_EventName"]) : ECEventName = null;
ECEventDescriptionOne = dr["EC_EventDescriptionOne"] != DBNull.Value ? Convert.ToString(dr["EC_EventDescriptionOne"]) : ECEventDescriptionOne = null;
ECEventDescriptionTwo = dr["EC_EventDescriptionTwo"] != DBNull.Value ? Convert.ToString(dr["EC_EventDescriptionTwo"]) : ECEventDescriptionTwo = null;
ECEventYear = dr["EC_EventYear"] != DBNull.Value ? Convert.ToString(dr["EC_EventYear"]) : ECEventYear = null;
ECEventStartTime = dr["EC_EventStartTime"] != DBNull.Value ? Convert.ToString(dr["EC_EventStartTime"]) : ECEventStartTime = null;
ECEventEndTime = dr["EC_EventEndTime"] != DBNull.Value ? Convert.ToString(dr["EC_EventEndTime"]) : ECEventEndTime = null;
ECEventStartDate = dr["EC_EventStartDate"] != DBNull.Value ? Convert.ToDateTime(dr["EC_EventStartDate"]) : ECEventStartDate = null;
ECEventEndDate = dr["EC_EventEndDate"] != DBNull.Value ? Convert.ToDateTime(dr["EC_EventEndDate"]) : ECEventEndDate = null;
ECEventImageOne = dr["EC_EventImageOne"] != DBNull.Value ? Convert.ToString(dr["EC_EventImageOne"]) : ECEventImageOne = null;
ECEventImageTwo = dr["EC_EventImageTwo"] != DBNull.Value ? Convert.ToString(dr["EC_EventImageTwo"]) : ECEventImageTwo = null;
ECEventAddDate = dr["EC_EventAddDate"] != DBNull.Value ? Convert.ToDateTime(dr["EC_EventAddDate"]) : ECEventAddDate = null;
ECEventAddedby = dr["EC_EventAddedby"] != DBNull.Value ? Convert.ToInt64(dr["EC_EventAddedby"]) : ECEventAddedby = null;
ECStatus = dr["EC_Status"] != DBNull.Value ? Convert.ToInt32(dr["EC_Status"]) : ECStatus = null;
}
protected void MapFrom(DataRow dr)
{
EMDDevelopmentId = dr["EMD_DevelopmentId"] != DBNull.Value ? Convert.ToInt64(dr["EMD_DevelopmentId"]) : EMDDevelopmentId = null;
EMDSchoolId = dr["EMD_SchoolId"] != DBNull.Value ? Convert.ToInt64(dr["EMD_SchoolId"]) : EMDSchoolId = null;
EMDSchoolSubId = dr["EMD_SchoolSubId"] != DBNull.Value ? Convert.ToInt64(dr["EMD_SchoolSubId"]) : EMDSchoolSubId = null;
EMDStudentLoginId = dr["EMD_StudentLoginId"] != DBNull.Value ? Convert.ToInt64(dr["EMD_StudentLoginId"]) : EMDStudentLoginId = null;
EMDAlertandRemeber = dr["EMD_AlertandRemeber"] != DBNull.Value ? Convert.ToString(dr["EMD_AlertandRemeber"]) : EMDAlertandRemeber = null;
EMDKickThrowBall = dr["EMD_KickThrowBall"] != DBNull.Value ? Convert.ToString(dr["EMD_KickThrowBall"]) : EMDKickThrowBall = null;
EMDHopJumpRun = dr["EMD_HopJumpRun"] != DBNull.Value ? Convert.ToString(dr["EMD_HopJumpRun"]) : EMDHopJumpRun = null;
EMDKeenObserver = dr["EMD_KeenObserver"] != DBNull.Value ? Convert.ToString(dr["EMD_KeenObserver"]) : EMDKeenObserver = null;
EMDCommunicateClearly = dr["EMD_CommunicateClearly"] != DBNull.Value ? Convert.ToString(dr["EMD_CommunicateClearly"]) : EMDCommunicateClearly = null;
EMDGripWithPencil = dr["EMD_GripWithPencil"] != DBNull.Value ? Convert.ToString(dr["EMD_GripWithPencil"]) : EMDGripWithPencil = null;
EMDMyBalanceHandEye = dr["EMD_MyBalanceHandEye"] != DBNull.Value ? Convert.ToString(dr["EMD_MyBalanceHandEye"]) : EMDMyBalanceHandEye = null;
EMDPicesOfPuzzle = dr["EMD_PicesOfPuzzle"] != DBNull.Value ? Convert.ToString(dr["EMD_PicesOfPuzzle"]) : EMDPicesOfPuzzle = null;
EMDAddedByType = dr["EMD_AddedByType"] != DBNull.Value ? Convert.ToString(dr["EMD_AddedByType"]) : EMDAddedByType = null;
EMDAddedByLoginId = dr["EMD_AddedByLoginId"] != DBNull.Value ? Convert.ToInt64(dr["EMD_AddedByLoginId"]) : EMDAddedByLoginId = null;
EMDDate = dr["EMD_Date"] != DBNull.Value ? Convert.ToDateTime(dr["EMD_Date"]) : EMDDate = null;
EMDStatus = dr["EMD_Status"] != DBNull.Value ? Convert.ToInt32(dr["EMD_Status"]) : EMDStatus = null;
}
/// <summary>
/// Delete current TMSNews from database.
/// </summary>
/// <param name="transaction">optional SQL Transaction</param>
public void Delete(DbTransaction transaction)
{
Database db;
string sqlCommand;
DbCommand dbCommand;
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSNews_DELETE";
dbCommand = db.GetStoredProcCommand(sqlCommand, NwId);
// Execute.
if (transaction != null)
{
db.ExecuteNonQuery(dbCommand, transaction);
}
else
{
db.ExecuteNonQuery(dbCommand);
}
this.NwId = null;
}
protected void MapFrom(DataRow dr)
{
FSNTTypeId = dr["FSNT_TypeId"] != DBNull.Value ? Convert.ToInt64(dr["FSNT_TypeId"]) : FSNTTypeId = null;
FSNTNewsTypeName = dr["FSNT_NewsTypeName"] != DBNull.Value ? Convert.ToString(dr["FSNT_NewsTypeName"]) : FSNTNewsTypeName = null;
FSNTDate = dr["FSNT_Date"] != DBNull.Value ? Convert.ToDateTime(dr["FSNT_Date"]) : FSNTDate = null;
FSNTStatus = dr["FSNT_Status"] != DBNull.Value ? Convert.ToInt32(dr["FSNT_Status"]) : FSNTStatus = null;
}
public void Insert(System.Int64? tcTeacherID, System.Int64? tcSyllabusID, System.String tcDescription, System.DateTime? tcStartDate, System.DateTime? tcEndDate, System.String tcpcpStatus, System.Int32? tcStatus, DbTransaction transaction)
{
Database db;
string sqlCommand;
DbCommand dbCommand;
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSTeacherCourceSyllabus_INSERT";
dbCommand = db.GetStoredProcCommand(sqlCommand, tcTeacherID, tcSyllabusID, tcDescription, tcStartDate, tcEndDate, tcpcpStatus, tcStatus);
if (transaction == null)
this.TCTeacherSyllabusID = Convert.ToInt64(db.ExecuteScalar(dbCommand));
else
this.TCTeacherSyllabusID = Convert.ToInt64(db.ExecuteScalar(dbCommand, transaction));
return;
}
public static void Delete(System.Int64?etActivityTypeID)
{
Delete(
etActivityTypeID);
}
public static DataSet GetSearch(System.Int64?bsdStaffId, System.Int64?bsdTransportManagerID, System.String bsdStaffType, System.String bsdStaffName, System.String bsdImage, System.Int64?bsdAddressId, System.DateTime?bsdDateOfJoining, System.String bsdLicenceNo, System.DateTime?bsdDate, System.Int32?bsdStatus, System.String bsdBusStaffId, System.String bsdBusLicenceImage)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSBusStaffDetails_SEARCH";
dbCommand = db.GetStoredProcCommand(sqlCommand, bsdStaffId, bsdTransportManagerID, bsdStaffType, bsdStaffName, bsdImage, bsdAddressId, bsdDateOfJoining, bsdLicenceNo, bsdDate, bsdStatus, bsdBusStaffId, bsdBusLicenceImage);
ds = db.ExecuteDataSet(dbCommand);
return(ds);
}
public static TMSBusDetails[] Search(System.Int64?bdBusDetailsId, System.String bdBusId, System.String bdBusType, System.Int64?bdTransportManagerID, System.String bdBusName, System.String bdBusNumber, System.String bdTotalNoOfSeats, System.String bdBusKMTravels, System.String bdMiledge, System.String bdCost, System.String bdMonthlyMaintanceCost, System.String bdFuel, System.String bdServicing, System.String bdOtherBusParts, System.String bdCostNeeded, System.String bdTransport, System.String bdDescription, System.String bdVia, System.String bdPrbFacing, System.String bdAddedBy, System.DateTime?bdDate, System.Int32?bdStatus)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSBusDetails_SEARCH";
dbCommand = db.GetStoredProcCommand(sqlCommand, bdBusDetailsId, bdBusId, bdBusType, bdTransportManagerID, bdBusName, bdBusNumber, bdTotalNoOfSeats, bdBusKMTravels, bdMiledge, bdCost, bdMonthlyMaintanceCost, bdFuel, bdServicing, bdOtherBusParts, bdCostNeeded, bdTransport, bdDescription, bdVia, bdPrbFacing, bdAddedBy, bdDate, bdStatus);
ds = db.ExecuteDataSet(dbCommand);
ds.Tables[0].TableName = TABLE_NAME;
return(TMSBusDetails.MapFrom(ds));
}
public static void Update(System.Int64?etActivityTypeID, System.String etActivityType, System.DateTime?etDate, System.Int32?etStatus)
{
Update(etActivityTypeID, etActivityType, etDate, etStatus, null);
}
public static void Delete(System.Int64?bdBusDetailsId)
{
Delete(
bdBusDetailsId);
}
public static void Update(System.Int64?bdBusDetailsId, System.String bdBusId, System.String bdBusType, System.Int64?bdTransportManagerID, System.String bdBusName, System.String bdBusNumber, System.String bdTotalNoOfSeats, System.String bdBusKMTravels, System.String bdMiledge, System.String bdCost, System.String bdMonthlyMaintanceCost, System.String bdFuel, System.String bdServicing, System.String bdOtherBusParts, System.String bdCostNeeded, System.String bdTransport, System.String bdDescription, System.String bdVia, System.String bdPrbFacing, System.String bdAddedBy, System.DateTime?bdDate)
{
Update(bdBusDetailsId, bdBusId, bdBusType, bdTransportManagerID, bdBusName, bdBusNumber, bdTotalNoOfSeats, bdBusKMTravels, bdMiledge, bdCost, bdMonthlyMaintanceCost, bdFuel, bdServicing, bdOtherBusParts, bdCostNeeded, bdTransport, bdDescription, bdVia, bdPrbFacing, bdAddedBy, bdDate, null);
}
public static void Update(System.Int64?bdBusDetailsId, System.String bdBusId, System.String bdBusType, System.Int64?bdTransportManagerID, System.String bdBusName, System.String bdBusNumber, System.String bdTotalNoOfSeats, System.String bdBusKMTravels, System.String bdMiledge, System.String bdCost, System.String bdMonthlyMaintanceCost, System.String bdFuel, System.String bdServicing, System.String bdOtherBusParts, System.String bdCostNeeded, System.String bdTransport, System.String bdDescription, System.String bdVia, System.String bdPrbFacing, System.String bdAddedBy, System.DateTime?bdDate, DbTransaction transaction)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSBusDetails_UPDATE";
dbCommand = db.GetStoredProcCommand(sqlCommand);
db.DiscoverParameters(dbCommand);
dbCommand.Parameters["@bdBusDetailsId"].Value = bdBusDetailsId;
dbCommand.Parameters["@bdBusType"].Value = bdBusId;
dbCommand.Parameters["@bdTransportManagerID"].Value = bdBusType;
dbCommand.Parameters["@bdBusName"].Value = bdTransportManagerID;
dbCommand.Parameters["@bdBusNumber"].Value = bdBusName;
dbCommand.Parameters["@bdTotalNoOfSeats"].Value = bdBusNumber;
dbCommand.Parameters["@bdBusKMTravels"].Value = bdTotalNoOfSeats;
dbCommand.Parameters["@bdMiledge"].Value = bdBusKMTravels;
dbCommand.Parameters["@bdCost"].Value = bdMiledge;
dbCommand.Parameters["@bdMonthlyMaintanceCost"].Value = bdCost;
dbCommand.Parameters["@bdFuel"].Value = bdMonthlyMaintanceCost;
dbCommand.Parameters["@bdServicing"].Value = bdFuel;
dbCommand.Parameters["@bdOtherBusParts"].Value = bdServicing;
dbCommand.Parameters["@bdCostNeeded"].Value = bdOtherBusParts;
dbCommand.Parameters["@bdTransport"].Value = bdCostNeeded;
dbCommand.Parameters["@bdDescription"].Value = bdTransport;
dbCommand.Parameters["@bdVia"].Value = bdDescription;
dbCommand.Parameters["@bdPrbFacing"].Value = bdVia;
dbCommand.Parameters["@bdAddedBy"].Value = bdPrbFacing;
dbCommand.Parameters["@bdDate"].Value = bdAddedBy;
dbCommand.Parameters["@bdStatus"].Value = bdDate;
if (transaction == null)
{
db.ExecuteNonQuery(dbCommand);
}
else
{
db.ExecuteNonQuery(dbCommand, transaction);
}
return;
}
protected void MapFrom(DataRow dr)
{
LTDTimeId = dr["LTD_TimeId"] != DBNull.Value ? Convert.ToInt64(dr["LTD_TimeId"]) : LTDTimeId = null;
LTDStartTime = dr["LTD_StartTime"] != DBNull.Value ? Convert.ToString(dr["LTD_StartTime"]) : LTDStartTime = null;
LTDEndTime = dr["LTD_EndTime"] != DBNull.Value ? Convert.ToString(dr["LTD_EndTime"]) : LTDEndTime = null;
LTDSchoolCatId = dr["LTD_SchoolCatId"] != DBNull.Value ? Convert.ToInt64(dr["LTD_SchoolCatId"]) : LTDSchoolCatId = null;
LTDSubCategoryId = dr["LTD_SubCategoryId"] != DBNull.Value ? Convert.ToInt64(dr["LTD_SubCategoryId"]) : LTDSubCategoryId = null;
LTDDate = dr["LTD_Date"] != DBNull.Value ? Convert.ToDateTime(dr["LTD_Date"]) : LTDDate = null;
LTDStatus = dr["LTD_Status"] != DBNull.Value ? Convert.ToInt32(dr["LTD_Status"]) : LTDStatus = null;
}
public static DataSet FillTMSrtransportSearchbyStudent(System.Int64?SchoolCategoryId, System.Int64?SchoolSubCatId, System.String FirstName, System.String BusNumber, System.String StartRoute)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSrtransportSearchbyStudent";
dbCommand = db.GetStoredProcCommand(sqlCommand, SchoolCategoryId, SchoolSubCatId, FirstName, BusNumber, StartRoute);
ds = db.ExecuteDataSet(dbCommand);
return(ds);
}
protected void MapFrom(DataRow dr)
{
STTypeId = dr["ST_TypeId"] != DBNull.Value ? Convert.ToInt64(dr["ST_TypeId"]) : STTypeId = null;
STSTTypeName = dr["ST_ST_TypeName"] != DBNull.Value ? Convert.ToString(dr["ST_ST_TypeName"]) : STSTTypeName = null;
STStatus = dr["ST_Status"] != DBNull.Value ? Convert.ToInt32(dr["ST_Status"]) : STStatus = null;
}
public void Insert(System.Int64?mdSkillTypeId, System.Int64?mdSkillTitleId, System.Int64?mdSchoolId, System.Int64?mdSchoolSubId, System.Int64?mdStudentLoginId, System.Int64?mdGradeId, System.Int32?mdGradePoint, System.String mdGradeName, System.String mdObtainMarks, System.String mdTotalMarks, System.String mdDescription, System.DateTime?mdDate, System.Int64?mdAddedById, System.String mdAddedByType, System.Int32?mdStatus, DbTransaction transaction)
{
Database db;
string sqlCommand;
DbCommand dbCommand;
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSCoScholasticMarksDetails_INSERT";
dbCommand = db.GetStoredProcCommand(sqlCommand, mdSkillTypeId, mdSkillTitleId, mdSchoolId, mdSchoolSubId, mdStudentLoginId, mdGradeId, mdGradePoint, mdGradeName, mdObtainMarks, mdTotalMarks, mdDescription, mdDate, mdAddedById, mdAddedByType, mdStatus);
if (transaction == null)
{
this.MDMarksDetailsId = Convert.ToInt64(db.ExecuteScalar(dbCommand));
}
else
{
this.MDMarksDetailsId = Convert.ToInt64(db.ExecuteScalar(dbCommand, transaction));
}
return;
}
protected override void SetData(IDataRecord reader)
{
_COAKey = reader.GetInt64("COAKey");
_COAID = reader.GetInt64("COAKey");
_ParentKey = reader.GetNulableInt64("ParentKey");
_COACode = reader.GetString("COACode");
_COACodeClient = reader.GetString("COACodeClient");
_COAName = reader.GetString("COAName");
_COALevel = reader.GetInt32("COALevel");
_IsActive = reader.GetBoolean("IsActive");
_IsPostingHead = reader.GetBoolean("IsPostingHead");
_IsDefaultCash = reader.GetBoolean("IsDefaultCash");
_IsCash = reader.GetBoolean("IsCash");
_CostCenterID = reader.GetInt32("CostCenterID");
SetUnchanged();
}
public static void Update(System.Int64?mdMarksDetailsId, System.Int64?mdSkillTypeId, System.Int64?mdSkillTitleId, System.Int64?mdSchoolId, System.Int64?mdSchoolSubId, System.Int64?mdStudentLoginId, System.Int64?mdGradeId, System.Int32?mdGradePoint, System.String mdGradeName, System.String mdObtainMarks, System.String mdTotalMarks, System.String mdDescription, System.DateTime?mdDate, System.Int64?mdAddedById, System.String mdAddedByType, System.Int32?mdStatus, DbTransaction transaction)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSCoScholasticMarksDetails_UPDATE";
dbCommand = db.GetStoredProcCommand(sqlCommand);
db.DiscoverParameters(dbCommand);
dbCommand.Parameters["@mdMarksDetailsId"].Value = mdMarksDetailsId;
dbCommand.Parameters["@mdSkillTypeId"].Value = mdSkillTypeId;
dbCommand.Parameters["@mdSkillTitleId"].Value = mdSkillTitleId;
dbCommand.Parameters["@mdSchoolId"].Value = mdSchoolId;
dbCommand.Parameters["@mdSchoolSubId"].Value = mdSchoolSubId;
dbCommand.Parameters["@mdStudentLoginId"].Value = mdStudentLoginId;
dbCommand.Parameters["@mdGradeId"].Value = mdGradeId;
dbCommand.Parameters["@mdGradePoint"].Value = mdGradePoint;
dbCommand.Parameters["@mdGradeName"].Value = mdGradeName;
dbCommand.Parameters["@mdObtainMarks"].Value = mdObtainMarks;
dbCommand.Parameters["@mdTotalMarks"].Value = mdTotalMarks;
dbCommand.Parameters["@mdDescription"].Value = mdDescription;
dbCommand.Parameters["@mdDate"].Value = mdDate;
dbCommand.Parameters["@mdAddedById"].Value = mdAddedById;
dbCommand.Parameters["@mdAddedByType"].Value = mdAddedByType;
dbCommand.Parameters["@mdStatus"].Value = mdStatus;
if (transaction == null)
{
db.ExecuteNonQuery(dbCommand);
}
else
{
db.ExecuteNonQuery(dbCommand, transaction);
}
return;
}
protected void MapFrom(DataRow dr)
{
EGADAwarnessId = dr["EGAD_AwarnessId"] != DBNull.Value ? Convert.ToInt64(dr["EGAD_AwarnessId"]) : EGADAwarnessId = null;
EGADSchoolId = dr["EGAD_SchoolId"] != DBNull.Value ? Convert.ToInt64(dr["EGAD_SchoolId"]) : EGADSchoolId = null;
EGADSchoolSubId = dr["EGAD_SchoolSubId"] != DBNull.Value ? Convert.ToInt64(dr["EGAD_SchoolSubId"]) : EGADSchoolSubId = null;
EGADStudentLoginId = dr["EGAD_StudentLoginId"] != DBNull.Value ? Convert.ToInt64(dr["EGAD_StudentLoginId"]) : EGADStudentLoginId = null;
EGADMySurrounding = dr["EGAD_MySurrounding"] != DBNull.Value ? Convert.ToString(dr["EGAD_MySurrounding"]) : EGADMySurrounding = null;
EGADMyMotherName = dr["EGAD_MyMotherName"] != DBNull.Value ? Convert.ToString(dr["EGAD_MyMotherName"]) : EGADMyMotherName = null;
EGADMyFatherName = dr["EGAD_MyFatherName"] != DBNull.Value ? Convert.ToString(dr["EGAD_MyFatherName"]) : EGADMyFatherName = null;
EGADMyHomeAddress = dr["EGAD_MyHomeAddress"] != DBNull.Value ? Convert.ToString(dr["EGAD_MyHomeAddress"]) : EGADMyHomeAddress = null;
EGADMyPhoneNumber = dr["EGAD_MyPhoneNumber"] != DBNull.Value ? Convert.ToString(dr["EGAD_MyPhoneNumber"]) : EGADMyPhoneNumber = null;
EGADMySchoolName = dr["EGAD_MySchoolName"] != DBNull.Value ? Convert.ToString(dr["EGAD_MySchoolName"]) : EGADMySchoolName = null;
EGADAddedByType = dr["EGAD_AddedByType"] != DBNull.Value ? Convert.ToString(dr["EGAD_AddedByType"]) : EGADAddedByType = null;
EGADAddedByLoginId = dr["EGAD_AddedByLoginId"] != DBNull.Value ? Convert.ToInt64(dr["EGAD_AddedByLoginId"]) : EGADAddedByLoginId = null;
EGADDate = dr["EGAD_Date"] != DBNull.Value ? Convert.ToDateTime(dr["EGAD_Date"]) : EGADDate = null;
EGADStatus = dr["EGAD_Status"] != DBNull.Value ? Convert.ToInt32(dr["EGAD_Status"]) : EGADStatus = null;
}
public static void Update(System.Int64?mdMarksDetailsId, System.Int64?mdSkillTypeId, System.Int64?mdSkillTitleId, System.Int64?mdSchoolId, System.Int64?mdSchoolSubId, System.Int64?mdStudentLoginId, System.Int64?mdGradeId, System.Int32?mdGradePoint, System.String mdGradeName, System.String mdObtainMarks, System.String mdTotalMarks, System.String mdDescription, System.DateTime?mdDate, System.Int64?mdAddedById, System.String mdAddedByType, System.Int32?mdStatus)
{
Update(mdMarksDetailsId, mdSkillTypeId, mdSkillTitleId, mdSchoolId, mdSchoolSubId, mdStudentLoginId, mdGradeId, mdGradePoint, mdGradeName, mdObtainMarks, mdTotalMarks, mdDescription, mdDate, mdAddedById, mdAddedByType, mdStatus, null);
}
protected void MapFrom(DataRow dr)
{
BIDBookId = dr["BID_BookId"] != DBNull.Value ? Convert.ToInt64(dr["BID_BookId"]) : BIDBookId = null;
BIDLibraryManagerId = dr["BID_LibraryManagerId"] != DBNull.Value ? Convert.ToInt64(dr["BID_LibraryManagerId"]) : BIDLibraryManagerId = null;
BIDUserLoginId = dr["BID_UserLoginId"] != DBNull.Value ? Convert.ToInt64(dr["BID_UserLoginId"]) : BIDUserLoginId = null;
BIDSubjectId = dr["BID_SubjectId"] != DBNull.Value ? Convert.ToInt64(dr["BID_SubjectId"]) : BIDSubjectId = null;
BIDStandardId = dr["BID_StandardId"] != DBNull.Value ? Convert.ToInt64(dr["BID_StandardId"]) : BIDStandardId = null;
BIDDivisionId = dr["BID_DivisionId"] != DBNull.Value ? Convert.ToInt64(dr["BID_DivisionId"]) : BIDDivisionId = null;
BIDBookDetailsId = dr["BID_BookDetailsId"] != DBNull.Value ? Convert.ToInt64(dr["BID_BookDetailsId"]) : BIDBookDetailsId = null;
BIDBookIssuedDate = dr["BID_BookIssuedDate"] != DBNull.Value ? Convert.ToDateTime(dr["BID_BookIssuedDate"]) : BIDBookIssuedDate = null;
BIDBookSubmitDate = dr["BID_BookSubmitDate"] != DBNull.Value ? Convert.ToDateTime(dr["BID_BookSubmitDate"]) : BIDBookSubmitDate = null;
BIDBookLateFees = dr["BID_BookLateFees"] != DBNull.Value ? Convert.ToDouble(dr["BID_BookLateFees"]) : BIDBookLateFees = null;
BIDBookDeposite = dr["BID_BookDeposite"] != DBNull.Value ? Convert.ToDouble(dr["BID_BookDeposite"]) : BIDBookDeposite = null;
BIDBookOhterCharges = dr["BID_BookOhterCharges"] != DBNull.Value ? Convert.ToDouble(dr["BID_BookOhterCharges"]) : BIDBookOhterCharges = null;
BIDBookSubmittedStatus = dr["BID_BookSubmittedStatus"] != DBNull.Value ? Convert.ToString(dr["BID_BookSubmittedStatus"]) : BIDBookSubmittedStatus = null;
BIDBookExtraColumn1 = dr["BID_BookExtraColumn1"] != DBNull.Value ? Convert.ToString(dr["BID_BookExtraColumn1"]) : BIDBookExtraColumn1 = null;
BIDBookExtraColumn2 = dr["BID_BookExtraColumn2"] != DBNull.Value ? Convert.ToString(dr["BID_BookExtraColumn2"]) : BIDBookExtraColumn2 = null;
BIDBookExtraColumn3 = dr["BID_BookExtraColumn3"] != DBNull.Value ? Convert.ToString(dr["BID_BookExtraColumn3"]) : BIDBookExtraColumn3 = null;
BIDBookExtraColumn4 = dr["BID_BookExtraColumn4"] != DBNull.Value ? Convert.ToString(dr["BID_BookExtraColumn4"]) : BIDBookExtraColumn4 = null;
BIDBookExtraFees1 = dr["BID_BookExtraFees1"] != DBNull.Value ? Convert.ToDouble(dr["BID_BookExtraFees1"]) : BIDBookExtraFees1 = null;
BIDBookExtraFees2 = dr["BID_BookExtraFees2"] != DBNull.Value ? Convert.ToDouble(dr["BID_BookExtraFees2"]) : BIDBookExtraFees2 = null;
BIDBookExtraDate1 = dr["BID_BookExtraDate1"] != DBNull.Value ? Convert.ToDateTime(dr["BID_BookExtraDate1"]) : BIDBookExtraDate1 = null;
BIDBookExtraDate2 = dr["BID_BookExtraDate2"] != DBNull.Value ? Convert.ToDateTime(dr["BID_BookExtraDate2"]) : BIDBookExtraDate2 = null;
BIDStatus = dr["BID_Status"] != DBNull.Value ? Convert.ToBoolean(dr["BID_Status"]) : BIDStatus = null;
}
public static void Delete(System.Int64?mdMarksDetailsId)
{
Delete(
mdMarksDetailsId);
}
protected void MapFrom(DataRow dr)
{
NwId = dr["NW_ID"] != DBNull.Value ? Convert.ToInt64(dr["NW_ID"]) : NwId = null;
NDHeading = dr["ND_Heading"] != DBNull.Value ? Convert.ToString(dr["ND_Heading"]) : NDHeading = null;
NDImagePath = dr["ND_ImagePath"] != DBNull.Value ? Convert.ToString(dr["ND_ImagePath"]) : NDImagePath = null;
NDDescription = dr["ND_Description"] != DBNull.Value ? Convert.ToString(dr["ND_Description"]) : NDDescription = null;
NDCreatedDate = dr["ND_CreatedDate"] != DBNull.Value ? Convert.ToDateTime(dr["ND_CreatedDate"]) : NDCreatedDate = null;
NDStatus = dr["ND_Status"] != DBNull.Value ? Convert.ToInt32(dr["ND_Status"]) : NDStatus = null;
}
public static TMSCoScholasticMarksDetails[] Search(System.Int64?mdMarksDetailsId, System.Int64?mdSkillTypeId, System.Int64?mdSkillTitleId, System.Int64?mdSchoolId, System.Int64?mdSchoolSubId, System.Int64?mdStudentLoginId, System.Int64?mdGradeId, System.Int32?mdGradePoint, System.String mdGradeName, System.String mdObtainMarks, System.String mdTotalMarks, System.String mdDescription, System.DateTime?mdDate, System.Int64?mdAddedById, System.String mdAddedByType, System.Int32?mdStatus)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSCoScholasticMarksDetails_SEARCH";
dbCommand = db.GetStoredProcCommand(sqlCommand, mdMarksDetailsId, mdSkillTypeId, mdSkillTitleId, mdSchoolId, mdSchoolSubId, mdStudentLoginId, mdGradeId, mdGradePoint, mdGradeName, mdObtainMarks, mdTotalMarks, mdDescription, mdDate, mdAddedById, mdAddedByType, mdStatus);
ds = db.ExecuteDataSet(dbCommand);
ds.Tables[0].TableName = TABLE_NAME;
return(TMSCoScholasticMarksDetails.MapFrom(ds));
}
protected void MapFrom(DataRow dr)
{
EGDGrowthId = dr["EGD_GrowthId"] != DBNull.Value ? Convert.ToInt64(dr["EGD_GrowthId"]) : EGDGrowthId = null;
EGDSchoolId = dr["EGD_SchoolId"] != DBNull.Value ? Convert.ToInt64(dr["EGD_SchoolId"]) : EGDSchoolId = null;
EGDSchoolSubId = dr["EGD_SchoolSubId"] != DBNull.Value ? Convert.ToInt64(dr["EGD_SchoolSubId"]) : EGDSchoolSubId = null;
EGDStudentLoginId = dr["EGD_StudentLoginId"] != DBNull.Value ? Convert.ToInt64(dr["EGD_StudentLoginId"]) : EGDStudentLoginId = null;
EGDMudAndSandPlay = dr["EGD_MudAndSandPlay"] != DBNull.Value ? Convert.ToString(dr["EGD_MudAndSandPlay"]) : EGDMudAndSandPlay = null;
EGDSplashPool = dr["EGD_SplashPool"] != DBNull.Value ? Convert.ToString(dr["EGD_SplashPool"]) : EGDSplashPool = null;
EGDLikeColourPainting = dr["EGD_LikeColourPainting"] != DBNull.Value ? Convert.ToString(dr["EGD_LikeColourPainting"]) : EGDLikeColourPainting = null;
EGDPatternWriting = dr["EGD_PatternWriting"] != DBNull.Value ? Convert.ToString(dr["EGD_PatternWriting"]) : EGDPatternWriting = null;
EGDPaperTearingPastingCraftWork = dr["EGD_PaperTearingPastingCraftWork"] != DBNull.Value ? Convert.ToString(dr["EGD_PaperTearingPastingCraftWork"]) : EGDPaperTearingPastingCraftWork = null;
EGDInterestArtActivites = dr["EGD_InterestArtActivites"] != DBNull.Value ? Convert.ToString(dr["EGD_InterestArtActivites"]) : EGDInterestArtActivites = null;
EGDInterestMusicDramaActivites = dr["EGD_InterestMusicDramaActivites"] != DBNull.Value ? Convert.ToString(dr["EGD_InterestMusicDramaActivites"]) : EGDInterestMusicDramaActivites = null;
EGDInterestPhysicalActivites = dr["EGD_InterestPhysicalActivites"] != DBNull.Value ? Convert.ToString(dr["EGD_InterestPhysicalActivites"]) : EGDInterestPhysicalActivites = null;
EGDAddedByType = dr["EGD_AddedByType"] != DBNull.Value ? Convert.ToString(dr["EGD_AddedByType"]) : EGDAddedByType = null;
EGDAddedByLoginId = dr["EGD_AddedByLoginId"] != DBNull.Value ? Convert.ToInt64(dr["EGD_AddedByLoginId"]) : EGDAddedByLoginId = null;
EGDDate = dr["EGD_Date"] != DBNull.Value ? Convert.ToDateTime(dr["EGD_Date"]) : EGDDate = null;
EGDStatus = dr["EGD_Status"] != DBNull.Value ? Convert.ToInt32(dr["EGD_Status"]) : EGDStatus = null;
}
public object Execute(ExecutorContext context)
{
var cmdletContext = context as CmdletContext;
// create request
var request = new Amazon.SecretsManager.Model.RotateSecretRequest();
if (cmdletContext.ClientRequestToken != null)
{
request.ClientRequestToken = cmdletContext.ClientRequestToken;
}
if (cmdletContext.RotationLambdaARN != null)
{
request.RotationLambdaARN = cmdletContext.RotationLambdaARN;
}
// populate RotationRules
var requestRotationRulesIsNull = true;
request.RotationRules = new Amazon.SecretsManager.Model.RotationRulesType();
System.Int64?requestRotationRules_rotationRules_AutomaticallyAfterDay = null;
if (cmdletContext.RotationRules_AutomaticallyAfterDay != null)
{
requestRotationRules_rotationRules_AutomaticallyAfterDay = cmdletContext.RotationRules_AutomaticallyAfterDay.Value;
}
if (requestRotationRules_rotationRules_AutomaticallyAfterDay != null)
{
request.RotationRules.AutomaticallyAfterDays = requestRotationRules_rotationRules_AutomaticallyAfterDay.Value;
requestRotationRulesIsNull = false;
}
// determine if request.RotationRules should be set to null
if (requestRotationRulesIsNull)
{
request.RotationRules = null;
}
if (cmdletContext.SecretId != null)
{
request.SecretId = cmdletContext.SecretId;
}
CmdletOutput output;
// issue call
var client = Client ?? CreateClient(_CurrentCredentials, _RegionEndpoint);
try
{
var response = CallAWSServiceOperation(client, request);
object pipelineOutput = null;
pipelineOutput = cmdletContext.Select(response, this);
output = new CmdletOutput
{
PipelineOutput = pipelineOutput,
ServiceResponse = response
};
}
catch (Exception e)
{
output = new CmdletOutput {
ErrorResponse = e
};
}
return(output);
}
protected void MapFrom(DataRow dr)
{
LbId = dr["LB_ID"] != DBNull.Value ? Convert.ToInt64(dr["LB_ID"]) : LbId = null;
LBLoginID = dr["LB_LoginID"] != DBNull.Value ? Convert.ToInt64(dr["LB_LoginID"]) : LBLoginID = null;
LBUsertype = dr["LB_Usertype"] != DBNull.Value ? Convert.ToInt64(dr["LB_Usertype"]) : LBUsertype = null;
LBFirstName = dr["LB_FirstName"] != DBNull.Value ? Convert.ToString(dr["LB_FirstName"]) : LBFirstName = null;
LBMiddleName = dr["LB_MiddleName"] != DBNull.Value ? Convert.ToString(dr["LB_MiddleName"]) : LBMiddleName = null;
LBLastName = dr["LB_LastName"] != DBNull.Value ? Convert.ToString(dr["LB_LastName"]) : LBLastName = null;
LBPhoto = dr["LB_Photo"] != DBNull.Value ? Convert.ToString(dr["LB_Photo"]) : LBPhoto = null;
LbDob = dr["LB_DOB"] != DBNull.Value ? Convert.ToDateTime(dr["LB_DOB"]) : LbDob = null;
LBCaste = dr["LB_Caste"] != DBNull.Value ? Convert.ToString(dr["LB_Caste"]) : LBCaste = null;
LBSubCaste = dr["LB_SubCaste"] != DBNull.Value ? Convert.ToString(dr["LB_SubCaste"]) : LBSubCaste = null;
LBBirthPlace = dr["LB_BirthPlace"] != DBNull.Value ? Convert.ToString(dr["LB_BirthPlace"]) : LBBirthPlace = null;
LBGender = dr["LB_Gender"] != DBNull.Value ? Convert.ToString(dr["LB_Gender"]) : LBGender = null;
LBBloodGroup = dr["LB_BloodGroup"] != DBNull.Value ? Convert.ToString(dr["LB_BloodGroup"]) : LBBloodGroup = null;
LBMotherTongue = dr["LB_MotherTongue"] != DBNull.Value ? Convert.ToString(dr["LB_MotherTongue"]) : LBMotherTongue = null;
LbDoj = dr["LB_DOJ"] != DBNull.Value ? Convert.ToDateTime(dr["LB_DOJ"]) : LbDoj = null;
LBHighestDegree = dr["LB_HighestDegree"] != DBNull.Value ? Convert.ToString(dr["LB_HighestDegree"]) : LBHighestDegree = null;
LBCompletedYear = dr["LB_CompletedYear"] != DBNull.Value ? Convert.ToString(dr["LB_CompletedYear"]) : LBCompletedYear = null;
LBUniversity = dr["LB_University"] != DBNull.Value ? Convert.ToString(dr["LB_University"]) : LBUniversity = null;
LBAddressId = dr["LB_AddressId"] != DBNull.Value ? Convert.ToInt64(dr["LB_AddressId"]) : LBAddressId = null;
LBAgeproof = dr["LB_Ageproof"] != DBNull.Value ? Convert.ToString(dr["LB_Ageproof"]) : LBAgeproof = null;
LBReleavingLetter = dr["LB_ReleavingLetter"] != DBNull.Value ? Convert.ToString(dr["LB_ReleavingLetter"]) : LBReleavingLetter = null;
LBResume = dr["LB_Resume"] != DBNull.Value ? Convert.ToString(dr["LB_Resume"]) : LBResume = null;
LBStatus = dr["LB_Status"] != DBNull.Value ? Convert.ToInt32(dr["LB_Status"]) : LBStatus = null;
}
public object Execute(ExecutorContext context)
{
var cmdletContext = context as CmdletContext;
// create request
var request = new Amazon.IoT.Model.CreateJobRequest();
// populate AbortConfig
var requestAbortConfigIsNull = true;
request.AbortConfig = new Amazon.IoT.Model.AbortConfig();
List <Amazon.IoT.Model.AbortCriteria> requestAbortConfig_abortConfig_CriteriaList = null;
if (cmdletContext.AbortConfig_CriteriaList != null)
{
requestAbortConfig_abortConfig_CriteriaList = cmdletContext.AbortConfig_CriteriaList;
}
if (requestAbortConfig_abortConfig_CriteriaList != null)
{
request.AbortConfig.CriteriaList = requestAbortConfig_abortConfig_CriteriaList;
requestAbortConfigIsNull = false;
}
// determine if request.AbortConfig should be set to null
if (requestAbortConfigIsNull)
{
request.AbortConfig = null;
}
if (cmdletContext.Description != null)
{
request.Description = cmdletContext.Description;
}
if (cmdletContext.Document != null)
{
request.Document = cmdletContext.Document;
}
if (cmdletContext.DocumentSource != null)
{
request.DocumentSource = cmdletContext.DocumentSource;
}
// populate JobExecutionsRolloutConfig
var requestJobExecutionsRolloutConfigIsNull = true;
request.JobExecutionsRolloutConfig = new Amazon.IoT.Model.JobExecutionsRolloutConfig();
Amazon.IoT.Model.ExponentialRolloutRate requestJobExecutionsRolloutConfig_jobExecutionsRolloutConfig_ExponentialRate = null;
if (cmdletContext.JobExecutionsRolloutConfig_ExponentialRate != null)
{
requestJobExecutionsRolloutConfig_jobExecutionsRolloutConfig_ExponentialRate = cmdletContext.JobExecutionsRolloutConfig_ExponentialRate;
}
if (requestJobExecutionsRolloutConfig_jobExecutionsRolloutConfig_ExponentialRate != null)
{
request.JobExecutionsRolloutConfig.ExponentialRate = requestJobExecutionsRolloutConfig_jobExecutionsRolloutConfig_ExponentialRate;
requestJobExecutionsRolloutConfigIsNull = false;
}
System.Int32?requestJobExecutionsRolloutConfig_jobExecutionsRolloutConfig_MaximumPerMinute = null;
if (cmdletContext.JobExecutionsRolloutConfig_MaximumPerMinute != null)
{
requestJobExecutionsRolloutConfig_jobExecutionsRolloutConfig_MaximumPerMinute = cmdletContext.JobExecutionsRolloutConfig_MaximumPerMinute.Value;
}
if (requestJobExecutionsRolloutConfig_jobExecutionsRolloutConfig_MaximumPerMinute != null)
{
request.JobExecutionsRolloutConfig.MaximumPerMinute = requestJobExecutionsRolloutConfig_jobExecutionsRolloutConfig_MaximumPerMinute.Value;
requestJobExecutionsRolloutConfigIsNull = false;
}
// determine if request.JobExecutionsRolloutConfig should be set to null
if (requestJobExecutionsRolloutConfigIsNull)
{
request.JobExecutionsRolloutConfig = null;
}
if (cmdletContext.JobId != null)
{
request.JobId = cmdletContext.JobId;
}
if (cmdletContext.NamespaceId != null)
{
request.NamespaceId = cmdletContext.NamespaceId;
}
// populate PresignedUrlConfig
var requestPresignedUrlConfigIsNull = true;
request.PresignedUrlConfig = new Amazon.IoT.Model.PresignedUrlConfig();
System.Int64?requestPresignedUrlConfig_presignedUrlConfig_ExpiresInSec = null;
if (cmdletContext.PresignedUrlConfig_ExpiresInSec != null)
{
requestPresignedUrlConfig_presignedUrlConfig_ExpiresInSec = cmdletContext.PresignedUrlConfig_ExpiresInSec.Value;
}
if (requestPresignedUrlConfig_presignedUrlConfig_ExpiresInSec != null)
{
request.PresignedUrlConfig.ExpiresInSec = requestPresignedUrlConfig_presignedUrlConfig_ExpiresInSec.Value;
requestPresignedUrlConfigIsNull = false;
}
System.String requestPresignedUrlConfig_presignedUrlConfig_RoleArn = null;
if (cmdletContext.PresignedUrlConfig_RoleArn != null)
{
requestPresignedUrlConfig_presignedUrlConfig_RoleArn = cmdletContext.PresignedUrlConfig_RoleArn;
}
if (requestPresignedUrlConfig_presignedUrlConfig_RoleArn != null)
{
request.PresignedUrlConfig.RoleArn = requestPresignedUrlConfig_presignedUrlConfig_RoleArn;
requestPresignedUrlConfigIsNull = false;
}
// determine if request.PresignedUrlConfig should be set to null
if (requestPresignedUrlConfigIsNull)
{
request.PresignedUrlConfig = null;
}
if (cmdletContext.Tag != null)
{
request.Tags = cmdletContext.Tag;
}
if (cmdletContext.Target != null)
{
request.Targets = cmdletContext.Target;
}
if (cmdletContext.TargetSelection != null)
{
request.TargetSelection = cmdletContext.TargetSelection;
}
// populate TimeoutConfig
var requestTimeoutConfigIsNull = true;
request.TimeoutConfig = new Amazon.IoT.Model.TimeoutConfig();
System.Int64?requestTimeoutConfig_timeoutConfig_InProgressTimeoutInMinute = null;
if (cmdletContext.TimeoutConfig_InProgressTimeoutInMinute != null)
{
requestTimeoutConfig_timeoutConfig_InProgressTimeoutInMinute = cmdletContext.TimeoutConfig_InProgressTimeoutInMinute.Value;
}
if (requestTimeoutConfig_timeoutConfig_InProgressTimeoutInMinute != null)
{
request.TimeoutConfig.InProgressTimeoutInMinutes = requestTimeoutConfig_timeoutConfig_InProgressTimeoutInMinute.Value;
requestTimeoutConfigIsNull = false;
}
// determine if request.TimeoutConfig should be set to null
if (requestTimeoutConfigIsNull)
{
request.TimeoutConfig = null;
}
CmdletOutput output;
// issue call
var client = Client ?? CreateClient(_CurrentCredentials, _RegionEndpoint);
try
{
var response = CallAWSServiceOperation(client, request);
object pipelineOutput = null;
pipelineOutput = cmdletContext.Select(response, this);
output = new CmdletOutput
{
PipelineOutput = pipelineOutput,
ServiceResponse = response
};
}
catch (Exception e)
{
output = new CmdletOutput {
ErrorResponse = e
};
}
return(output);
}
public void Insert(System.String ltdStartTime, System.String ltdEndTime, System.Int64? ltdSchoolCatId, System.Int64? ltdSubCategoryId, System.DateTime? ltdDate, System.Int32? ltdStatus, DbTransaction transaction)
{
Database db;
string sqlCommand;
DbCommand dbCommand;
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSLeactureTimeDetails_INSERT";
dbCommand = db.GetStoredProcCommand(sqlCommand, ltdStartTime, ltdEndTime, ltdSchoolCatId, ltdSubCategoryId, ltdDate, ltdStatus);
if (transaction == null)
this.LTDTimeId = Convert.ToInt64(db.ExecuteScalar(dbCommand));
else
this.LTDTimeId = Convert.ToInt64(db.ExecuteScalar(dbCommand, transaction));
return;
}
public void Insert(System.Int64?vdVendorManagerId, System.String vdVendorName, System.String vdReleaventShop, System.String vdContactNo, System.String vdAlternateNumber, System.Int64?vdAddressId, System.String vdShopImage, System.String vdShopMap, System.String vdVendorImage, System.String vdVendorForPrePrimary, System.String vdVendorForPrimary, System.String vdVendorForHighSchool, System.String vdVendorForHouseUniform, System.String vdVendorSchoolUniform, System.String vdVendorSchoolShoes, System.String vdVendorSchoolBooks, System.String vdVendorSchoolBags, System.String vdVendorForBoys, System.String vdVendorForGirls, System.DateTime?vdDate, System.String vdWebsite, System.Int32?vdStatus, DbTransaction transaction)
{
Database db;
string sqlCommand;
DbCommand dbCommand;
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSVendorDetails_INSERT";
dbCommand = db.GetStoredProcCommand(sqlCommand, vdVendorManagerId, vdVendorName, vdReleaventShop, vdContactNo, vdAlternateNumber, vdAddressId, vdShopImage, vdShopMap, vdVendorImage, vdVendorForPrePrimary, vdVendorForPrimary, vdVendorForHighSchool, vdVendorForHouseUniform, vdVendorSchoolUniform, vdVendorSchoolShoes, vdVendorSchoolBooks, vdVendorSchoolBags, vdVendorForBoys, vdVendorForGirls, vdDate, vdWebsite, vdStatus);
if (transaction == null)
{
this.VDVendorId = Convert.ToInt64(db.ExecuteScalar(dbCommand));
}
else
{
this.VDVendorId = Convert.ToInt64(db.ExecuteScalar(dbCommand, transaction));
}
return;
}
public void Insert(System.String ststTypeName, System.Int32? stStatus, DbTransaction transaction)
{
Database db;
string sqlCommand;
DbCommand dbCommand;
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSSchoolType_INSERT";
dbCommand = db.GetStoredProcCommand(sqlCommand, ststTypeName, stStatus);
if (transaction == null)
this.STTypeId = Convert.ToInt64(db.ExecuteScalar(dbCommand));
else
this.STTypeId = Convert.ToInt64(db.ExecuteScalar(dbCommand, transaction));
return;
}
public static void Update(System.Int64?vdVendorId, System.Int64?vdVendorManagerId, System.String vdVendorDetailsId, System.String vdVendorName, System.String vdReleaventShop, System.String vdContactNo, System.String vdAlternateNumber, System.Int64?vdAddressId, System.String vdShopImage, System.String vdShopMap, System.String vdVendorImage, System.String vdVendorForPrePrimary, System.String vdVendorForPrimary, System.String vdVendorForHighSchool, System.String vdVendorForHouseUniform, System.String vdVendorSchoolUniform, System.String vdVendorSchoolShoes, System.String vdVendorSchoolBooks, System.String vdVendorSchoolBags, System.String vdVendorForBoys, System.String vdVendorForGirls, System.DateTime?vdDate, System.String vdWebsite, System.Int32?vdStatus, DbTransaction transaction)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSVendorDetails_UPDATE";
dbCommand = db.GetStoredProcCommand(sqlCommand);
db.DiscoverParameters(dbCommand);
dbCommand.Parameters["@vdVendorId"].Value = vdVendorId;
dbCommand.Parameters["@vdVendorManagerId"].Value = vdVendorManagerId;
//dbCommand.Parameters["@vdVendorDetailsId"].Value = vdVendorDetailsId;
dbCommand.Parameters["@vdVendorName"].Value = vdVendorName;
dbCommand.Parameters["@vdReleaventShop"].Value = vdReleaventShop;
dbCommand.Parameters["@vdContactNo"].Value = vdContactNo;
dbCommand.Parameters["@vdAlternateNumber"].Value = vdAlternateNumber;
dbCommand.Parameters["@vdAddressId"].Value = vdAddressId;
dbCommand.Parameters["@vdShopImage"].Value = vdShopImage;
dbCommand.Parameters["@vdShopMap"].Value = vdShopMap;
dbCommand.Parameters["@vdVendorImage"].Value = vdVendorImage;
dbCommand.Parameters["@vdVendorForPrePrimary"].Value = vdVendorForPrePrimary;
dbCommand.Parameters["@vdVendorForPrimary"].Value = vdVendorForPrimary;
dbCommand.Parameters["@vdVendorForHighSchool"].Value = vdVendorForHighSchool;
dbCommand.Parameters["@vdVendorForHouseUniform"].Value = vdVendorForHouseUniform;
dbCommand.Parameters["@vdVendorSchoolUniform"].Value = vdVendorSchoolUniform;
dbCommand.Parameters["@vdVendorSchoolShoes"].Value = vdVendorSchoolShoes;
dbCommand.Parameters["@vdVendorSchoolBooks"].Value = vdVendorSchoolBooks;
dbCommand.Parameters["@vdVendorSchoolBags"].Value = vdVendorSchoolBags;
dbCommand.Parameters["@vdVendorForBoys"].Value = vdVendorForBoys;
dbCommand.Parameters["@vdVendorForGirls"].Value = vdVendorForGirls;
dbCommand.Parameters["@vdDate"].Value = vdDate;
dbCommand.Parameters["@vdWebsite"].Value = vdWebsite;
dbCommand.Parameters["@vdStatus"].Value = vdStatus;
if (transaction == null)
{
db.ExecuteNonQuery(dbCommand);
}
else
{
db.ExecuteNonQuery(dbCommand, transaction);
}
return;
}
public void Insert(System.String fsntNewsTypeName, System.DateTime? fsntDate, System.Int32? fsntStatus, DbTransaction transaction)
{
Database db;
string sqlCommand;
DbCommand dbCommand;
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSFunStuffNewsType_INSERT";
dbCommand = db.GetStoredProcCommand(sqlCommand, fsntNewsTypeName, fsntDate, fsntStatus);
if (transaction == null)
this.FSNTTypeId = Convert.ToInt64(db.ExecuteScalar(dbCommand));
else
this.FSNTTypeId = Convert.ToInt64(db.ExecuteScalar(dbCommand, transaction));
return;
}
public static void Update(System.Int64?vdVendorId, System.Int64?vdVendorManagerId, System.String vdVendorDetailsId, System.String vdVendorName, System.String vdReleaventShop, System.String vdContactNo, System.String vdAlternateNumber, System.Int64?vdAddressId, System.String vdShopImage, System.String vdShopMap, System.String vdVendorImage, System.String vdVendorForPrePrimary, System.String vdVendorForPrimary, System.String vdVendorForHighSchool, System.String vdVendorForHouseUniform, System.String vdVendorSchoolUniform, System.String vdVendorSchoolShoes, System.String vdVendorSchoolBooks, System.String vdVendorSchoolBags, System.String vdVendorForBoys, System.String vdVendorForGirls, System.DateTime?vdDate, System.String vdWebsite, System.Int32?vdStatus)
{
Update(vdVendorId, vdVendorManagerId, vdVendorDetailsId, vdVendorName, vdReleaventShop, vdContactNo, vdAlternateNumber, vdAddressId, vdShopImage, vdShopMap, vdVendorImage, vdVendorForPrePrimary, vdVendorForPrimary, vdVendorForHighSchool, vdVendorForHouseUniform, vdVendorSchoolUniform, vdVendorSchoolShoes, vdVendorSchoolBooks, vdVendorSchoolBags, vdVendorForBoys, vdVendorForGirls, vdDate, vdWebsite, vdStatus, null);
}
protected void MapFrom(DataRow dr)
{
CAFDAssignId = dr["CAFD_AssignId"] != DBNull.Value ? Convert.ToInt64(dr["CAFD_AssignId"]) : CAFDAssignId = null;
CAFDFacultyId = dr["CAFD_FacultyId"] != DBNull.Value ? Convert.ToInt64(dr["CAFD_FacultyId"]) : CAFDFacultyId = null;
CAFDSchoolId = dr["CAFD_SchoolId"] != DBNull.Value ? Convert.ToInt64(dr["CAFD_SchoolId"]) : CAFDSchoolId = null;
CAFDSchoolSubCategoryId = dr["CAFD_SchoolSubCategoryId"] != DBNull.Value ? Convert.ToInt64(dr["CAFD_SchoolSubCategoryId"]) : CAFDSchoolSubCategoryId = null;
CAFDDepartmentId = dr["CAFD_DepartmentId"] != DBNull.Value ? Convert.ToInt64(dr["CAFD_DepartmentId"]) : CAFDDepartmentId = null;
CAFDSubjectId = dr["CAFD_SubjectId"] != DBNull.Value ? Convert.ToInt64(dr["CAFD_SubjectId"]) : CAFDSubjectId = null;
CAFDAssignType = dr["CAFD_AssignType"] != DBNull.Value ? Convert.ToString(dr["CAFD_AssignType"]) : CAFDAssignType = null;
CAFDDate = dr["CAFD_Date"] != DBNull.Value ? Convert.ToDateTime(dr["CAFD_Date"]) : CAFDDate = null;
CAFDStatus = dr["CAFD_Status"] != DBNull.Value ? Convert.ToInt32(dr["CAFD_Status"]) : CAFDStatus = null;
}
public static void Delete(System.Int64?vdVendorId)
{
Delete(
vdVendorId);
}
/// <summary>
/// Delete current TMSTeacherCourceSyllabus from database.
/// </summary>
/// <param name="transaction">optional SQL Transaction</param>
public void Delete(DbTransaction transaction)
{
Database db;
string sqlCommand;
DbCommand dbCommand;
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSTeacherCourceSyllabus_DELETE";
dbCommand = db.GetStoredProcCommand(sqlCommand, TCTeacherSyllabusID);
// Execute.
if (transaction != null)
{
db.ExecuteNonQuery(dbCommand, transaction);
}
else
{
db.ExecuteNonQuery(dbCommand);
}
this.TCTeacherSyllabusID = null;
}
public static TMSVendorDetails[] Search(System.Int64?vdVendorId, System.Int64?vdVendorManagerId, System.String vdVendorDetailsId, System.String vdVendorName, System.String vdReleaventShop, System.String vdContactNo, System.String vdAlternateNumber, System.Int64?vdAddressId, System.String vdShopImage, System.String vdShopMap, System.String vdVendorImage, System.String vdVendorForPrePrimary, System.String vdVendorForPrimary, System.String vdVendorForHighSchool, System.String vdVendorForHouseUniform, System.String vdVendorSchoolUniform, System.String vdVendorSchoolShoes, System.String vdVendorSchoolBooks, System.String vdVendorSchoolBags, System.String vdVendorForBoys, System.String vdVendorForGirls, System.DateTime?vdDate, System.String vdWebsite, System.Int32?vdStatus)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSVendorDetails_SEARCH";
dbCommand = db.GetStoredProcCommand(sqlCommand, vdVendorId, vdVendorManagerId, vdVendorDetailsId, vdVendorName, vdReleaventShop, vdContactNo, vdAlternateNumber, vdAddressId, vdShopImage, vdShopMap, vdVendorImage, vdVendorForPrePrimary, vdVendorForPrimary, vdVendorForHighSchool, vdVendorForHouseUniform, vdVendorSchoolUniform, vdVendorSchoolShoes, vdVendorSchoolBooks, vdVendorSchoolBags, vdVendorForBoys, vdVendorForGirls, vdDate, vdWebsite, vdStatus);
ds = db.ExecuteDataSet(dbCommand);
ds.Tables[0].TableName = TABLE_NAME;
return(TMSVendorDetails.MapFrom(ds));
}
protected void MapFrom(DataRow dr)
{
TCTeacherSyllabusID = dr["TC_TeacherSyllabusID"] != DBNull.Value ? Convert.ToInt64(dr["TC_TeacherSyllabusID"]) : TCTeacherSyllabusID = null;
TCTeacherID = dr["TC_TeacherID"] != DBNull.Value ? Convert.ToInt64(dr["TC_TeacherID"]) : TCTeacherID = null;
TCSyllabusID = dr["TC_SyllabusID"] != DBNull.Value ? Convert.ToInt64(dr["TC_SyllabusID"]) : TCSyllabusID = null;
TCDescription = dr["TC_Description"] != DBNull.Value ? Convert.ToString(dr["TC_Description"]) : TCDescription = null;
TCStartDate = dr["TC_StartDate"] != DBNull.Value ? Convert.ToDateTime(dr["TC_StartDate"]) : TCStartDate = null;
TCEndDate = dr["TC_EndDate"] != DBNull.Value ? Convert.ToDateTime(dr["TC_EndDate"]) : TCEndDate = null;
TCPCPStatus = dr["TC_PCPStatus"] != DBNull.Value ? Convert.ToString(dr["TC_PCPStatus"]) : TCPCPStatus = null;
TCStatus = dr["TC_Status"] != DBNull.Value ? Convert.ToInt32(dr["TC_Status"]) : TCStatus = null;
}
public void Insert(System.Int64?ecdSchoolId, System.Int64?ecdSchoolSubId, System.Int64?ecdStudentLoginId, System.String ecdSelfIntroduction, System.String ecdRhymesRecitation, System.String ecdFancyDress, System.String ecdSongAndDance, System.String ecdColouring, System.String ecdArtAndCraft, System.String ecdAnnualDay, System.String ecdSportsDay, System.String ecdOtherEvents, System.String ecdAddedByType, System.Int64?ecdAddedByLoginId, System.DateTime?ecdDate, System.Int32?ecdStatus, DbTransaction transaction)
{
Database db;
string sqlCommand;
DbCommand dbCommand;
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSEvolutionOfCompetitiveness_INSERT";
dbCommand = db.GetStoredProcCommand(sqlCommand, ecdSchoolId, ecdSchoolSubId, ecdStudentLoginId, ecdSelfIntroduction, ecdRhymesRecitation, ecdFancyDress, ecdSongAndDance, ecdColouring, ecdArtAndCraft, ecdAnnualDay, ecdSportsDay, ecdOtherEvents, ecdAddedByType, ecdAddedByLoginId, ecdDate, ecdStatus);
if (transaction == null)
{
this.ECDCompetitiveId = Convert.ToInt64(db.ExecuteScalar(dbCommand));
}
else
{
this.ECDCompetitiveId = Convert.ToInt64(db.ExecuteScalar(dbCommand, transaction));
}
return;
}
protected void MapFrom(DataRow dr)
{
VIDDetailsId = dr["VID_DetailsId"] != DBNull.Value ? Convert.ToInt64(dr["VID_DetailsId"]) : VIDDetailsId = null;
VIDVendorId = dr["VID_VendorId"] != DBNull.Value ? Convert.ToInt64(dr["VID_VendorId"]) : VIDVendorId = null;
VIDItemType = dr["VID_ItemType"] != DBNull.Value ? Convert.ToString(dr["VID_ItemType"]) : VIDItemType = null;
VIDSchoolType = dr["VID_SchoolType"] != DBNull.Value ? Convert.ToString(dr["VID_SchoolType"]) : VIDSchoolType = null;
VIDSchoolSubType = dr["VID_SchoolSubType"] != DBNull.Value ? Convert.ToString(dr["VID_SchoolSubType"]) : VIDSchoolSubType = null;
VIDBoys = dr["VID_Boys"] != DBNull.Value ? Convert.ToString(dr["VID_Boys"]) : VIDBoys = null;
VIDGirls = dr["VID_Girls"] != DBNull.Value ? Convert.ToString(dr["VID_Girls"]) : VIDGirls = null;
VIDItemName = dr["VID_ItemName"] != DBNull.Value ? Convert.ToString(dr["VID_ItemName"]) : VIDItemName = null;
VIDBookName = dr["VID_BookName"] != DBNull.Value ? Convert.ToString(dr["VID_BookName"]) : VIDBookName = null;
VIDItemColor = dr["VID_ItemColor"] != DBNull.Value ? Convert.ToString(dr["VID_ItemColor"]) : VIDItemColor = null;
VIDItemBookAuthor = dr["VID_ItemBookAuthor"] != DBNull.Value ? Convert.ToString(dr["VID_ItemBookAuthor"]) : VIDItemBookAuthor = null;
VIDItemBookPublication = dr["VID_ItemBookPublication"] != DBNull.Value ? Convert.ToString(dr["VID_ItemBookPublication"]) : VIDItemBookPublication = null;
VIDItemSize = dr["VID_ItemSize"] != DBNull.Value ? Convert.ToString(dr["VID_ItemSize"]) : VIDItemSize = null;
VIDItemCost = dr["VID_ItemCost"] != DBNull.Value ? Convert.ToString(dr["VID_ItemCost"]) : VIDItemCost = null;
VIDItemStatus = dr["VID_ItemStatus"] != DBNull.Value ? Convert.ToString(dr["VID_ItemStatus"]) : VIDItemStatus = null;
VIDDate = dr["VID_Date"] != DBNull.Value ? Convert.ToDateTime(dr["VID_Date"]) : VIDDate = null;
VIDStatus = dr["VID_Status"] != DBNull.Value ? Convert.ToInt32(dr["VID_Status"]) : VIDStatus = null;
}
public static void Update(System.Int64?ecdCompetitiveId, System.Int64?ecdSchoolId, System.Int64?ecdSchoolSubId, System.Int64?ecdStudentLoginId, System.String ecdSelfIntroduction, System.String ecdRhymesRecitation, System.String ecdFancyDress, System.String ecdSongAndDance, System.String ecdColouring, System.String ecdArtAndCraft, System.String ecdAnnualDay, System.String ecdSportsDay, System.String ecdOtherEvents, System.String ecdAddedByType, System.Int64?ecdAddedByLoginId, System.DateTime?ecdDate, System.Int32?ecdStatus, DbTransaction transaction)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSEvolutionOfCompetitiveness_UPDATE";
dbCommand = db.GetStoredProcCommand(sqlCommand);
db.DiscoverParameters(dbCommand);
dbCommand.Parameters["@ecdCompetitiveId"].Value = ecdCompetitiveId;
dbCommand.Parameters["@ecdSchoolId"].Value = ecdSchoolId;
dbCommand.Parameters["@ecdSchoolSubId"].Value = ecdSchoolSubId;
dbCommand.Parameters["@ecdStudentLoginId"].Value = ecdStudentLoginId;
dbCommand.Parameters["@ecdSelfIntroduction"].Value = ecdSelfIntroduction;
dbCommand.Parameters["@ecdRhymesRecitation"].Value = ecdRhymesRecitation;
dbCommand.Parameters["@ecdFancyDress"].Value = ecdFancyDress;
dbCommand.Parameters["@ecdSongAndDance"].Value = ecdSongAndDance;
dbCommand.Parameters["@ecdColouring"].Value = ecdColouring;
dbCommand.Parameters["@ecdArtAndCraft"].Value = ecdArtAndCraft;
dbCommand.Parameters["@ecdAnnualDay"].Value = ecdAnnualDay;
dbCommand.Parameters["@ecdSportsDay"].Value = ecdSportsDay;
dbCommand.Parameters["@ecdOtherEvents"].Value = ecdOtherEvents;
dbCommand.Parameters["@ecdAddedByType"].Value = ecdAddedByType;
dbCommand.Parameters["@ecdAddedByLoginId"].Value = ecdAddedByLoginId;
dbCommand.Parameters["@ecdDate"].Value = ecdDate;
dbCommand.Parameters["@ecdStatus"].Value = ecdStatus;
if (transaction == null)
{
db.ExecuteNonQuery(dbCommand);
}
else
{
db.ExecuteNonQuery(dbCommand, transaction);
}
return;
}
protected void MapFrom(DataRow dr)
{
PDParentId = dr["PD_ParentId"] != DBNull.Value ? Convert.ToInt64(dr["PD_ParentId"]) : PDParentId = null;
PDStudentDetailsId = dr["PD_StudentDetailsId"] != DBNull.Value ? Convert.ToInt64(dr["PD_StudentDetailsId"]) : PDStudentDetailsId = null;
PDParentRefId = dr["PD_ParentRefId"] != DBNull.Value ? Convert.ToString(dr["PD_ParentRefId"]) : PDParentRefId = null;
PDFatherLoginId = dr["PD_FatherLoginId"] != DBNull.Value ? Convert.ToInt64(dr["PD_FatherLoginId"]) : PDFatherLoginId = null;
PDMotherLoginId = dr["PD_MotherLoginId"] != DBNull.Value ? Convert.ToInt64(dr["PD_MotherLoginId"]) : PDMotherLoginId = null;
PDFatherFullName = dr["PD_FatherFullName"] != DBNull.Value ? Convert.ToString(dr["PD_FatherFullName"]) : PDFatherFullName = null;
PDFatherPhoto = dr["PD_FatherPhoto"] != DBNull.Value ? Convert.ToString(dr["PD_FatherPhoto"]) : PDFatherPhoto = null;
PDFatherEduQualification = dr["PD_FatherEduQualification"] != DBNull.Value ? Convert.ToString(dr["PD_FatherEduQualification"]) : PDFatherEduQualification = null;
PDFatherOccupation = dr["PD_FatherOccupation"] != DBNull.Value ? Convert.ToString(dr["PD_FatherOccupation"]) : PDFatherOccupation = null;
PDFatherAddressId = dr["PD_FatherAddressId"] != DBNull.Value ? Convert.ToInt64(dr["PD_FatherAddressId"]) : PDFatherAddressId = null;
PDFatherOrgName = dr["PD_FatherOrgName"] != DBNull.Value ? Convert.ToString(dr["PD_FatherOrgName"]) : PDFatherOrgName = null;
PDFatherDsgtName = dr["PD_FatherDsgtName"] != DBNull.Value ? Convert.ToString(dr["PD_FatherDsgtName"]) : PDFatherDsgtName = null;
PDMotherFullName = dr["PD_MotherFullName"] != DBNull.Value ? Convert.ToString(dr["PD_MotherFullName"]) : PDMotherFullName = null;
PDMotherPhoto = dr["PD_MotherPhoto"] != DBNull.Value ? Convert.ToString(dr["PD_MotherPhoto"]) : PDMotherPhoto = null;
PDMotherEduQualification = dr["PD_MotherEduQualification"] != DBNull.Value ? Convert.ToString(dr["PD_MotherEduQualification"]) : PDMotherEduQualification = null;
PDMotherOccupation = dr["PD_MotherOccupation"] != DBNull.Value ? Convert.ToString(dr["PD_MotherOccupation"]) : PDMotherOccupation = null;
PDMotherAddressId = dr["PD_MotherAddressId"] != DBNull.Value ? Convert.ToInt64(dr["PD_MotherAddressId"]) : PDMotherAddressId = null;
PDMotherOrgName = dr["PD_MotherOrgName"] != DBNull.Value ? Convert.ToString(dr["PD_MotherOrgName"]) : PDMotherOrgName = null;
PDMotherDsgtName = dr["PD_MotherDsgtName"] != DBNull.Value ? Convert.ToString(dr["PD_MotherDsgtName"]) : PDMotherDsgtName = null;
PDDate = dr["PD_Date"] != DBNull.Value ? Convert.ToDateTime(dr["PD_Date"]) : PDDate = null;
PDStatus = dr["PD_Status"] != DBNull.Value ? Convert.ToInt32(dr["PD_Status"]) : PDStatus = null;
}
public static void Update(System.Int64?ecdCompetitiveId, System.Int64?ecdSchoolId, System.Int64?ecdSchoolSubId, System.Int64?ecdStudentLoginId, System.String ecdSelfIntroduction, System.String ecdRhymesRecitation, System.String ecdFancyDress, System.String ecdSongAndDance, System.String ecdColouring, System.String ecdArtAndCraft, System.String ecdAnnualDay, System.String ecdSportsDay, System.String ecdOtherEvents, System.String ecdAddedByType, System.Int64?ecdAddedByLoginId, System.DateTime?ecdDate, System.Int32?ecdStatus)
{
Update(ecdCompetitiveId, ecdSchoolId, ecdSchoolSubId, ecdStudentLoginId, ecdSelfIntroduction, ecdRhymesRecitation, ecdFancyDress, ecdSongAndDance, ecdColouring, ecdArtAndCraft, ecdAnnualDay, ecdSportsDay, ecdOtherEvents, ecdAddedByType, ecdAddedByLoginId, ecdDate, ecdStatus, null);
}
protected void MapFrom(DataRow dr)
{
CTDClassTeacherId = dr["CTD_ClassTeacherId"] != DBNull.Value ? Convert.ToInt64(dr["CTD_ClassTeacherId"]) : CTDClassTeacherId = null;
CTDSchoolCatId = dr["CTD_SchoolCatId"] != DBNull.Value ? Convert.ToInt64(dr["CTD_SchoolCatId"]) : CTDSchoolCatId = null;
CTDSchoolSubCatId = dr["CTD_SchoolSubCatId"] != DBNull.Value ? Convert.ToInt64(dr["CTD_SchoolSubCatId"]) : CTDSchoolSubCatId = null;
CTDSubjectId = dr["CTD_SubjectId"] != DBNull.Value ? Convert.ToInt64(dr["CTD_SubjectId"]) : CTDSubjectId = null;
CTDFacultyId = dr["CTD_FacultyId"] != DBNull.Value ? Convert.ToInt64(dr["CTD_FacultyId"]) : CTDFacultyId = null;
CTDAssignBy = dr["CTD_AssignBy"] != DBNull.Value ? Convert.ToString(dr["CTD_AssignBy"]) : CTDAssignBy = null;
CTDDate = dr["CTD_Date"] != DBNull.Value ? Convert.ToDateTime(dr["CTD_Date"]) : CTDDate = null;
CTDStatus = dr["CTD_Status"] != DBNull.Value ? Convert.ToInt32(dr["CTD_Status"]) : CTDStatus = null;
}
public static void Delete(System.Int64?ecdCompetitiveId)
{
Delete(
ecdCompetitiveId);
}
public void Insert(System.String ndHeading, System.String ndImagePath, System.String ndDescription, System.DateTime? ndCreatedDate, System.Int32? ndStatus, DbTransaction transaction)
{
Database db;
string sqlCommand;
DbCommand dbCommand;
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSNews_INSERT";
dbCommand = db.GetStoredProcCommand(sqlCommand, ndHeading, ndImagePath, ndDescription, ndCreatedDate, ndStatus);
if (transaction == null)
this.NwId = Convert.ToInt64(db.ExecuteScalar(dbCommand));
else
this.NwId = Convert.ToInt64(db.ExecuteScalar(dbCommand, transaction));
return;
}
public static TMSEvolutionOfCompetitiveness[] Search(System.Int64?ecdCompetitiveId, System.Int64?ecdSchoolId, System.Int64?ecdSchoolSubId, System.Int64?ecdStudentLoginId, System.String ecdSelfIntroduction, System.String ecdRhymesRecitation, System.String ecdFancyDress, System.String ecdSongAndDance, System.String ecdColouring, System.String ecdArtAndCraft, System.String ecdAnnualDay, System.String ecdSportsDay, System.String ecdOtherEvents, System.String ecdAddedByType, System.Int64?ecdAddedByLoginId, System.DateTime?ecdDate, System.Int32?ecdStatus)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSEvolutionOfCompetitiveness_SEARCH";
dbCommand = db.GetStoredProcCommand(sqlCommand, ecdCompetitiveId, ecdSchoolId, ecdSchoolSubId, ecdStudentLoginId, ecdSelfIntroduction, ecdRhymesRecitation, ecdFancyDress, ecdSongAndDance, ecdColouring, ecdArtAndCraft, ecdAnnualDay, ecdSportsDay, ecdOtherEvents, ecdAddedByType, ecdAddedByLoginId, ecdDate, ecdStatus);
ds = db.ExecuteDataSet(dbCommand);
ds.Tables[0].TableName = TABLE_NAME;
return(TMSEvolutionOfCompetitiveness.MapFrom(ds));
}
protected void MapFrom(DataRow dr)
{
SASDAssignId = dr["SASD_AssignId"] != DBNull.Value ? Convert.ToInt64(dr["SASD_AssignId"]) : SASDAssignId = null;
SASDSchoolId = dr["SASD_SchoolId"] != DBNull.Value ? Convert.ToInt64(dr["SASD_SchoolId"]) : SASDSchoolId = null;
SASDSchoolSubId = dr["SASD_SchoolSubId"] != DBNull.Value ? Convert.ToInt64(dr["SASD_SchoolSubId"]) : SASDSchoolSubId = null;
SASDSubjectId = dr["SASD_SubjectId"] != DBNull.Value ? Convert.ToInt64(dr["SASD_SubjectId"]) : SASDSubjectId = null;
SASDDepartmentId = dr["SASD_DepartmentId"] != DBNull.Value ? Convert.ToInt64(dr["SASD_DepartmentId"]) : SASDDepartmentId = null;
SASDAssignType = dr["SASD_AssignType"] != DBNull.Value ? Convert.ToString(dr["SASD_AssignType"]) : SASDAssignType = null;
SASDDate = dr["SASD_Date"] != DBNull.Value ? Convert.ToDateTime(dr["SASD_Date"]) : SASDDate = null;
SASDStatus = dr["SASD_Status"] != DBNull.Value ? Convert.ToInt32(dr["SASD_Status"]) : SASDStatus = null;
}
public static DataSet GetSearch(System.Int64?bdBlogId, System.Int64?bdParentLoginId, System.Int64?bdFacultyLoginId, System.String bdTitle, System.String bdDescription, System.String bdImage, System.Int64?bdReplyId, System.DateTime?bdDate, System.Int32?bdStatus)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSBlogDetails_SEARCH";
dbCommand = db.GetStoredProcCommand(sqlCommand, bdBlogId, bdParentLoginId, bdFacultyLoginId, bdTitle, bdDescription, bdImage, bdReplyId, bdDate, bdStatus);
ds = db.ExecuteDataSet(dbCommand);
return(ds);
}
protected void MapFrom(DataRow dr)
{
TpId = dr["TP_ID"] != DBNull.Value ? Convert.ToInt64(dr["TP_ID"]) : TpId = null;
TPLoginID = dr["TP_LoginID"] != DBNull.Value ? Convert.ToInt64(dr["TP_LoginID"]) : TPLoginID = null;
TPUsertype = dr["TP_Usertype"] != DBNull.Value ? Convert.ToInt64(dr["TP_Usertype"]) : TPUsertype = null;
TPFirstName = dr["TP_FirstName"] != DBNull.Value ? Convert.ToString(dr["TP_FirstName"]) : TPFirstName = null;
TPMiddleName = dr["TP_MiddleName"] != DBNull.Value ? Convert.ToString(dr["TP_MiddleName"]) : TPMiddleName = null;
TPLastName = dr["TP_LastName"] != DBNull.Value ? Convert.ToString(dr["TP_LastName"]) : TPLastName = null;
TPPhoto = dr["TP_Photo"] != DBNull.Value ? Convert.ToString(dr["TP_Photo"]) : TPPhoto = null;
TpDob = dr["TP_DOB"] != DBNull.Value ? Convert.ToDateTime(dr["TP_DOB"]) : TpDob = null;
TPCaste = dr["TP_Caste"] != DBNull.Value ? Convert.ToString(dr["TP_Caste"]) : TPCaste = null;
TPSubCaste = dr["TP_SubCaste"] != DBNull.Value ? Convert.ToString(dr["TP_SubCaste"]) : TPSubCaste = null;
TPBirthPlace = dr["TP_BirthPlace"] != DBNull.Value ? Convert.ToString(dr["TP_BirthPlace"]) : TPBirthPlace = null;
TPGender = dr["TP_Gender"] != DBNull.Value ? Convert.ToString(dr["TP_Gender"]) : TPGender = null;
TPBloodGroup = dr["TP_BloodGroup"] != DBNull.Value ? Convert.ToString(dr["TP_BloodGroup"]) : TPBloodGroup = null;
TPMotherTongue = dr["TP_MotherTongue"] != DBNull.Value ? Convert.ToString(dr["TP_MotherTongue"]) : TPMotherTongue = null;
TpDoj = dr["TP_DOJ"] != DBNull.Value ? Convert.ToDateTime(dr["TP_DOJ"]) : TpDoj = null;
TPHighestDegree = dr["TP_HighestDegree"] != DBNull.Value ? Convert.ToString(dr["TP_HighestDegree"]) : TPHighestDegree = null;
TPCompletedYear = dr["TP_CompletedYear"] != DBNull.Value ? Convert.ToString(dr["TP_CompletedYear"]) : TPCompletedYear = null;
TPUniversity = dr["TP_University"] != DBNull.Value ? Convert.ToString(dr["TP_University"]) : TPUniversity = null;
TPAddressId = dr["TP_AddressId"] != DBNull.Value ? Convert.ToInt64(dr["TP_AddressId"]) : TPAddressId = null;
TPAgeproof = dr["TP_Ageproof"] != DBNull.Value ? Convert.ToString(dr["TP_Ageproof"]) : TPAgeproof = null;
TPReleavingLetter = dr["TP_ReleavingLetter"] != DBNull.Value ? Convert.ToString(dr["TP_ReleavingLetter"]) : TPReleavingLetter = null;
TPResume = dr["TP_Resume"] != DBNull.Value ? Convert.ToString(dr["TP_Resume"]) : TPResume = null;
TPStatus = dr["TP_Status"] != DBNull.Value ? Convert.ToInt32(dr["TP_Status"]) : TPStatus = null;
}
public static DataSet GetMyBlogReplyDetails(System.Int64?facultyLoginId, System.Int64?parentLoginId, System.Int64?replyId)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].[TMS_SearchMyBlogReplyDetails]";
dbCommand = db.GetStoredProcCommand(sqlCommand, facultyLoginId, parentLoginId, replyId);
ds = db.ExecuteDataSet(dbCommand);
return(ds);
}
protected void MapFrom(DataRow dr)
{
ETTExamId = dr["ETT_ExamId"] != DBNull.Value ? Convert.ToInt64(dr["ETT_ExamId"]) : ETTExamId = null;
ETTExamCode = dr["ETT_ExamCode"] != DBNull.Value ? Convert.ToString(dr["ETT_ExamCode"]) : ETTExamCode = null;
ETTFacultyLoginId = dr["ETT_FacultyLoginId"] != DBNull.Value ? Convert.ToInt64(dr["ETT_FacultyLoginId"]) : ETTFacultyLoginId = null;
ETTExamType = dr["ETT_ExamType"] != DBNull.Value ? Convert.ToString(dr["ETT_ExamType"]) : ETTExamType = null;
ETTExamTestId = dr["ETT_ExamTestId"] != DBNull.Value ? Convert.ToInt64(dr["ETT_ExamTestId"]) : ETTExamTestId = null;
ETTSchoolId = dr["ETT_SchoolId"] != DBNull.Value ? Convert.ToInt64(dr["ETT_SchoolId"]) : ETTSchoolId = null;
ETTSchoolSubId = dr["ETT_SchoolSubId"] != DBNull.Value ? Convert.ToInt64(dr["ETT_SchoolSubId"]) : ETTSchoolSubId = null;
ETTSubjectId = dr["ETT_SubjectId"] != DBNull.Value ? Convert.ToInt64(dr["ETT_SubjectId"]) : ETTSubjectId = null;
ETTDepartmentID = dr["ETT_DepartmentID"] != DBNull.Value ? Convert.ToInt64(dr["ETT_DepartmentID"]) : ETTDepartmentID = null;
ETTExtra1 = dr["ETT_Extra1"] != DBNull.Value ? Convert.ToString(dr["ETT_Extra1"]) : ETTExtra1 = null;
ETTExamDate = dr["ETT_ExamDate"] != DBNull.Value ? Convert.ToDateTime(dr["ETT_ExamDate"]) : ETTExamDate = null;
ETTStartTime = dr["ETT_StartTime"] != DBNull.Value ? Convert.ToString(dr["ETT_StartTime"]) : ETTStartTime = null;
ETTEndTime = dr["ETT_EndTime"] != DBNull.Value ? Convert.ToString(dr["ETT_EndTime"]) : ETTEndTime = null;
ETTAddedById = dr["ETT_AddedById"] != DBNull.Value ? Convert.ToInt64(dr["ETT_AddedById"]) : ETTAddedById = null;
ETTAddedType = dr["ETT_AddedType"] != DBNull.Value ? Convert.ToString(dr["ETT_AddedType"]) : ETTAddedType = null;
ETTDate = dr["ETT_Date"] != DBNull.Value ? Convert.ToDateTime(dr["ETT_Date"]) : ETTDate = null;
ETTStatus = dr["ETT_Status"] != DBNull.Value ? Convert.ToInt32(dr["ETT_Status"]) : ETTStatus = null;
}
public static DataSet GetSearch(System.Int64?bidBookId, System.Int64?bidLibraryManagerId, System.Int64?bidUserLoginId, System.Int64?bidSubjectId, System.Int64?bidStandardId, System.Int64?bidDivisionId, System.Int64?bidBookDetailsId, System.DateTime?bidBookIssuedDate, System.DateTime?bidBookSubmitDate, System.Double?bidBookLateFees, System.Double?bidBookDeposite, System.Double?bidBookOhterCharges, System.String bidBookSubmittedStatus, System.String bidBookExtraColumn1, System.String bidBookExtraColumn2, System.String bidBookExtraColumn3, System.String bidBookExtraColumn4, System.Double?bidBookExtraFees1, System.Double?bidBookExtraFees2, System.DateTime?bidBookExtraDate1, System.DateTime?bidBookExtraDate2, System.Boolean?bidStatus)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSBookIssuedDetails_SEARCH";
dbCommand = db.GetStoredProcCommand(sqlCommand, bidBookId, bidLibraryManagerId, bidUserLoginId, bidSubjectId, bidStandardId, bidDivisionId, bidBookDetailsId, bidBookIssuedDate, bidBookSubmitDate, bidBookLateFees, bidBookDeposite, bidBookOhterCharges, bidBookSubmittedStatus, bidBookExtraColumn1, bidBookExtraColumn2, bidBookExtraColumn3, bidBookExtraColumn4, bidBookExtraFees1, bidBookExtraFees2, bidBookExtraDate1, bidBookExtraDate2, bidStatus);
ds = db.ExecuteDataSet(dbCommand);
return(ds);
}
protected void MapFrom(DataRow dr)
{
RDResultId = dr["RD_ResultId"] != DBNull.Value ? Convert.ToInt64(dr["RD_ResultId"]) : RDResultId = null;
RDSchoolId = dr["RD_SchoolId"] != DBNull.Value ? Convert.ToInt64(dr["RD_SchoolId"]) : RDSchoolId = null;
RDSchoolSubId = dr["RD_SchoolSubId"] != DBNull.Value ? Convert.ToInt64(dr["RD_SchoolSubId"]) : RDSchoolSubId = null;
RDStudentId = dr["RD_StudentId"] != DBNull.Value ? Convert.ToInt64(dr["RD_StudentId"]) : RDStudentId = null;
RDSubjectId = dr["RD_SubjectId"] != DBNull.Value ? Convert.ToInt64(dr["RD_SubjectId"]) : RDSubjectId = null;
RDExamType = dr["RD_ExamType"] != DBNull.Value ? Convert.ToString(dr["RD_ExamType"]) : RDExamType = null;
RDExamId = dr["RD_ExamId"] != DBNull.Value ? Convert.ToInt64(dr["RD_ExamId"]) : RDExamId = null;
RDExamName = dr["RD_ExamName"] != DBNull.Value ? Convert.ToString(dr["RD_ExamName"]) : RDExamName = null;
RDResultText = dr["RD_ResultText"] != DBNull.Value ? Convert.ToString(dr["RD_ResultText"]) : RDResultText = null;
RDMarks = dr["RD_Marks"] != DBNull.Value ? Convert.ToInt32(dr["RD_Marks"]) : RDMarks = null;
RDGrade = dr["RD_Grade"] != DBNull.Value ? Convert.ToString(dr["RD_Grade"]) : RDGrade = null;
RDResultDate = dr["RD_ResultDate"] != DBNull.Value ? Convert.ToDateTime(dr["RD_ResultDate"]) : RDResultDate = null;
RDResultAddedBy = dr["RD_ResultAddedBy"] != DBNull.Value ? Convert.ToInt64(dr["RD_ResultAddedBy"]) : RDResultAddedBy = null;
RDResultStatus = dr["RD_ResultStatus"] != DBNull.Value ? Convert.ToString(dr["RD_ResultStatus"]) : RDResultStatus = null;
RDDate = dr["RD_Date"] != DBNull.Value ? Convert.ToDateTime(dr["RD_Date"]) : RDDate = null;
RDStatus = dr["RD_Status"] != DBNull.Value ? Convert.ToInt32(dr["RD_Status"]) : RDStatus = null;
}
protected void MapFrom(DataRow dr)
{
EADTimelineId = dr["EAD_TimelineId"] != DBNull.Value ? Convert.ToInt64(dr["EAD_TimelineId"]) : EADTimelineId = null;
EADFacultyLoginId = dr["EAD_FacultyLoginId"] != DBNull.Value ? Convert.ToInt64(dr["EAD_FacultyLoginId"]) : EADFacultyLoginId = null;
EADStudentLoginId = dr["EAD_StudentLoginId"] != DBNull.Value ? Convert.ToInt64(dr["EAD_StudentLoginId"]) : EADStudentLoginId = null;
EADProgressType = dr["EAD_ProgressType"] != DBNull.Value ? Convert.ToString(dr["EAD_ProgressType"]) : EADProgressType = null;
EADExtraActivityId = dr["EAD_ExtraActivityId"] != DBNull.Value ? Convert.ToInt64(dr["EAD_ExtraActivityId"]) : EADExtraActivityId = null;
EADSchoolId = dr["EAD_SchoolId"] != DBNull.Value ? Convert.ToInt64(dr["EAD_SchoolId"]) : EADSchoolId = null;
EADSchoolSubId = dr["EAD_SchoolSubId"] != DBNull.Value ? Convert.ToInt64(dr["EAD_SchoolSubId"]) : EADSchoolSubId = null;
EADExamTerm = dr["EAD_ExamTerm"] != DBNull.Value ? Convert.ToString(dr["EAD_ExamTerm"]) : EADExamTerm = null;
EADExtraActivity1 = dr["EAD_ExtraActivity1"] != DBNull.Value ? Convert.ToString(dr["EAD_ExtraActivity1"]) : EADExtraActivity1 = null;
EADExtraActivity2 = dr["EAD_ExtraActivity2"] != DBNull.Value ? Convert.ToString(dr["EAD_ExtraActivity2"]) : EADExtraActivity2 = null;
EADRemarks = dr["EAD_Remarks"] != DBNull.Value ? Convert.ToString(dr["EAD_Remarks"]) : EADRemarks = null;
EADAddeByType = dr["EAD_AddeByType"] != DBNull.Value ? Convert.ToString(dr["EAD_AddeByType"]) : EADAddeByType = null;
EADAddedById = dr["EAD_AddedById"] != DBNull.Value ? Convert.ToInt64(dr["EAD_AddedById"]) : EADAddedById = null;
EADDate = dr["EAD_Date"] != DBNull.Value ? Convert.ToDateTime(dr["EAD_Date"]) : EADDate = null;
EADStatus = dr["EAD_Status"] != DBNull.Value ? Convert.ToInt32(dr["EAD_Status"]) : EADStatus = null;
}
protected void MapFrom(DataRow dr)
{
BSDStaffId = dr["BSD_StaffId"] != DBNull.Value ? Convert.ToInt64(dr["BSD_StaffId"]) : BSDStaffId = null;
BSDTransportManagerID = dr["BSD_TransportManagerID"] != DBNull.Value ? Convert.ToInt64(dr["BSD_TransportManagerID"]) : BSDTransportManagerID = null;
BSDStaffType = dr["BSD_StaffType"] != DBNull.Value ? Convert.ToString(dr["BSD_StaffType"]) : BSDStaffType = null;
BSDStaffName = dr["BSD_StaffName"] != DBNull.Value ? Convert.ToString(dr["BSD_StaffName"]) : BSDStaffName = null;
BSDImage = dr["BSD_Image"] != DBNull.Value ? Convert.ToString(dr["BSD_Image"]) : BSDImage = null;
BSDAddressId = dr["BSD_AddressId"] != DBNull.Value ? Convert.ToInt64(dr["BSD_AddressId"]) : BSDAddressId = null;
BSDDateOfJoining = dr["BSD_DateOfJoining"] != DBNull.Value ? Convert.ToDateTime(dr["BSD_DateOfJoining"]) : BSDDateOfJoining = null;
BSDLicenceNo = dr["BSD_LicenceNo"] != DBNull.Value ? Convert.ToString(dr["BSD_LicenceNo"]) : BSDLicenceNo = null;
BSDDate = dr["BSD_Date"] != DBNull.Value ? Convert.ToDateTime(dr["BSD_Date"]) : BSDDate = null;
BSDStatus = dr["BSD_Status"] != DBNull.Value ? Convert.ToInt32(dr["BSD_Status"]) : BSDStatus = null;
BSDBusStaffId = dr["BSD_BusStaffId"] != DBNull.Value ? Convert.ToString(dr["BSD_BusStaffId"]) : BSDBusStaffId = null;
BSDBusLicenceImage = dr["BSD_BusLicenceImage"] != DBNull.Value ? Convert.ToString(dr["BSD_BusLicenceImage"]) : BSDBusLicenceImage = null;
}
public object Execute(ExecutorContext context)
{
var cmdletContext = context as CmdletContext;
#pragma warning disable CS0618, CS0612 //A class member was marked with the Obsolete attribute
var useParameterSelect = this.Select.StartsWith("^") || this.PassThru.IsPresent;
#pragma warning restore CS0618, CS0612 //A class member was marked with the Obsolete attribute
// create request and set iteration invariants
var request = new Amazon.Glue.Model.QuerySchemaVersionMetadataRequest();
if (cmdletContext.MaxResult != null)
{
request.MaxResults = cmdletContext.MaxResult.Value;
}
if (cmdletContext.MetadataList != null)
{
request.MetadataList = cmdletContext.MetadataList;
}
// populate SchemaId
var requestSchemaIdIsNull = true;
request.SchemaId = new Amazon.Glue.Model.SchemaId();
System.String requestSchemaId_schemaId_RegistryName = null;
if (cmdletContext.SchemaId_RegistryName != null)
{
requestSchemaId_schemaId_RegistryName = cmdletContext.SchemaId_RegistryName;
}
if (requestSchemaId_schemaId_RegistryName != null)
{
request.SchemaId.RegistryName = requestSchemaId_schemaId_RegistryName;
requestSchemaIdIsNull = false;
}
System.String requestSchemaId_schemaId_SchemaArn = null;
if (cmdletContext.SchemaId_SchemaArn != null)
{
requestSchemaId_schemaId_SchemaArn = cmdletContext.SchemaId_SchemaArn;
}
if (requestSchemaId_schemaId_SchemaArn != null)
{
request.SchemaId.SchemaArn = requestSchemaId_schemaId_SchemaArn;
requestSchemaIdIsNull = false;
}
System.String requestSchemaId_schemaId_SchemaName = null;
if (cmdletContext.SchemaId_SchemaName != null)
{
requestSchemaId_schemaId_SchemaName = cmdletContext.SchemaId_SchemaName;
}
if (requestSchemaId_schemaId_SchemaName != null)
{
request.SchemaId.SchemaName = requestSchemaId_schemaId_SchemaName;
requestSchemaIdIsNull = false;
}
// determine if request.SchemaId should be set to null
if (requestSchemaIdIsNull)
{
request.SchemaId = null;
}
if (cmdletContext.SchemaVersionId != null)
{
request.SchemaVersionId = cmdletContext.SchemaVersionId;
}
// populate SchemaVersionNumber
var requestSchemaVersionNumberIsNull = true;
request.SchemaVersionNumber = new Amazon.Glue.Model.SchemaVersionNumber();
System.Boolean?requestSchemaVersionNumber_schemaVersionNumber_LatestVersion = null;
if (cmdletContext.SchemaVersionNumber_LatestVersion != null)
{
requestSchemaVersionNumber_schemaVersionNumber_LatestVersion = cmdletContext.SchemaVersionNumber_LatestVersion.Value;
}
if (requestSchemaVersionNumber_schemaVersionNumber_LatestVersion != null)
{
request.SchemaVersionNumber.LatestVersion = requestSchemaVersionNumber_schemaVersionNumber_LatestVersion.Value;
requestSchemaVersionNumberIsNull = false;
}
System.Int64?requestSchemaVersionNumber_schemaVersionNumber_VersionNumber = null;
if (cmdletContext.SchemaVersionNumber_VersionNumber != null)
{
requestSchemaVersionNumber_schemaVersionNumber_VersionNumber = cmdletContext.SchemaVersionNumber_VersionNumber.Value;
}
if (requestSchemaVersionNumber_schemaVersionNumber_VersionNumber != null)
{
request.SchemaVersionNumber.VersionNumber = requestSchemaVersionNumber_schemaVersionNumber_VersionNumber.Value;
requestSchemaVersionNumberIsNull = false;
}
// determine if request.SchemaVersionNumber should be set to null
if (requestSchemaVersionNumberIsNull)
{
request.SchemaVersionNumber = null;
}
// Initialize loop variant and commence piping
var _nextToken = cmdletContext.NextToken;
var _userControllingPaging = this.NoAutoIteration.IsPresent || ParameterWasBound(nameof(this.NextToken));
var client = Client ?? CreateClient(_CurrentCredentials, _RegionEndpoint);
do
{
request.NextToken = _nextToken;
CmdletOutput output;
try
{
var response = CallAWSServiceOperation(client, request);
object pipelineOutput = null;
if (!useParameterSelect)
{
pipelineOutput = cmdletContext.Select(response, this);
}
output = new CmdletOutput
{
PipelineOutput = pipelineOutput,
ServiceResponse = response
};
_nextToken = response.NextToken;
}
catch (Exception e)
{
output = new CmdletOutput {
ErrorResponse = e
};
}
ProcessOutput(output);
} while (!_userControllingPaging && AutoIterationHelpers.HasValue(_nextToken));
if (useParameterSelect)
{
WriteObject(cmdletContext.Select(null, this));
}
return(null);
}
