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