public virtual string fn_CreateMaHD()
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[1]));
global::System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open))
{
command.Connection.Open();
}
try {
command.ExecuteNonQuery();
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
if (((command.Parameters[0].Value == null) ||
(command.Parameters[0].Value.GetType() == typeof(global::System.DBNull))))
{
return(null);
}
else
{
return((string)(command.Parameters[0].Value));
}
}
public virtual int spr_VASServiceMembership_NewsContent_Delete(global::System.Nullable <int> FK_NewsContentID)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((FK_NewsContentID.HasValue == true))
{
command.Parameters[1].Value = ((int)(FK_NewsContentID.Value));
}
else
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
global::System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open))
{
command.Connection.Open();
}
int returnValue;
try {
returnValue = command.ExecuteNonQuery();
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
return(returnValue);
}
public virtual int spr_CategoryVASService_Insert(string Title)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[1]));
if ((Title == null))
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[1].Value = ((string)(Title));
}
global::System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open))
{
command.Connection.Open();
}
int returnValue;
try {
returnValue = command.ExecuteNonQuery();
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
return(returnValue);
}
public virtual int RemoveEmployeePunchedHours(global::System.Nullable <int> TransactionID)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((TransactionID.HasValue == true))
{
command.Parameters[1].Value = ((int)(TransactionID.Value));
}
else
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
global::System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open))
{
command.Connection.Open();
}
int returnValue;
try {
returnValue = command.ExecuteNonQuery();
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
return(returnValue);
}
public virtual int usr_proc123(global::System.Nullable<global::System.DateTime> d1, global::System.Nullable<global::System.DateTime> d2) {
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((d1.HasValue == true)) {
command.Parameters[1].Value = ((System.DateTime)(d1.Value));
}
else {
command.Parameters[1].Value = global::System.DBNull.Value;
}
if ((d2.HasValue == true)) {
command.Parameters[2].Value = ((System.DateTime)(d2.Value));
}
else {
command.Parameters[2].Value = global::System.DBNull.Value;
}
global::System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open)) {
command.Connection.Open();
}
int returnValue;
try {
returnValue = command.ExecuteNonQuery();
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
command.Connection.Close();
}
}
return returnValue;
}
public virtual int NumberOfUnpaidBillByCustomer(global::System.Nullable <int> num)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((num.HasValue == true))
{
command.Parameters[1].Value = ((int)(num.Value));
}
else
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
global::System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open))
{
command.Connection.Open();
}
int returnValue;
try {
returnValue = command.ExecuteNonQuery();
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
return(returnValue);
}
public virtual int InsertMaterialSheetType(string SheetType)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((SheetType == null))
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[1].Value = ((string)(SheetType));
}
global::System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open))
{
command.Connection.Open();
}
int returnValue;
try {
returnValue = command.ExecuteNonQuery();
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
return(returnValue);
}
public virtual int priceWithOrderId(global::System.Nullable <long> orderId)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((orderId.HasValue == true))
{
command.Parameters[1].Value = ((long)(orderId.Value));
}
else
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
global::System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open))
{
command.Connection.Open();
}
int returnValue;
try {
returnValue = command.ExecuteNonQuery();
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
return(returnValue);
}
public virtual int dtngay(string ngay)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((ngay == null))
{
throw new global::System.ArgumentNullException("ngay");
}
else
{
command.Parameters[0].Value = ((string)(ngay));
}
global::System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open))
{
command.Connection.Open();
}
int returnValue;
try {
returnValue = command.ExecuteNonQuery();
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
return(returnValue);
}
public virtual int Rep_Prc_SubjetPrice(global::System.Nullable <int> AgreementID)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((AgreementID.HasValue == true))
{
command.Parameters[1].Value = ((int)(AgreementID.Value));
}
else
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
global::System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open))
{
command.Connection.Open();
}
int returnValue;
try {
returnValue = command.ExecuteNonQuery();
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
return(returnValue);
}
public virtual int UpdatePassword2(string old, string _new, ref global::System.Nullable <int> prov)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((old == null))
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[1].Value = ((string)(old));
}
if ((_new == null))
{
command.Parameters[2].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[2].Value = ((string)(_new));
}
if ((prov.HasValue == true))
{
command.Parameters[3].Value = ((int)(prov.Value));
}
else
{
command.Parameters[3].Value = global::System.DBNull.Value;
}
global::System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open))
{
command.Connection.Open();
}
int returnValue;
try {
returnValue = command.ExecuteNonQuery();
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
if (((command.Parameters[3].Value == null) ||
(command.Parameters[3].Value.GetType() == typeof(global::System.DBNull))))
{
prov = new global::System.Nullable <int>();
}
else
{
prov = new global::System.Nullable <int>(((int)(command.Parameters[3].Value)));
}
return(returnValue);
}
public virtual int UpdateAlohaTimePunches(global::System.Nullable <int> TransactionID, global::System.Nullable <global::System.DateTime> StartDate, global::System.Nullable <global::System.DateTime> EndDate, global::System.Nullable <decimal> DailyHours)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((TransactionID.HasValue == true))
{
command.Parameters[1].Value = ((int)(TransactionID.Value));
}
else
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
if ((StartDate.HasValue == true))
{
command.Parameters[2].Value = ((System.DateTime)(StartDate.Value));
}
else
{
command.Parameters[2].Value = global::System.DBNull.Value;
}
if ((EndDate.HasValue == true))
{
command.Parameters[3].Value = ((System.DateTime)(EndDate.Value));
}
else
{
command.Parameters[3].Value = global::System.DBNull.Value;
}
if ((DailyHours.HasValue == true))
{
command.Parameters[4].Value = ((decimal)(DailyHours.Value));
}
else
{
command.Parameters[4].Value = global::System.DBNull.Value;
}
global::System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open))
{
command.Connection.Open();
}
int returnValue;
try {
returnValue = command.ExecuteNonQuery();
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
return(returnValue);
}
public virtual int InsertPurchaseRequestDocumentation(global::System.Nullable <int> PONumber, global::System.Nullable <global::System.DateTime> TransactionDate, global::System.Nullable <int> EmployeeID, string DocumentPath)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((PONumber.HasValue == true))
{
command.Parameters[1].Value = ((int)(PONumber.Value));
}
else
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
if ((TransactionDate.HasValue == true))
{
command.Parameters[2].Value = ((System.DateTime)(TransactionDate.Value));
}
else
{
command.Parameters[2].Value = global::System.DBNull.Value;
}
if ((EmployeeID.HasValue == true))
{
command.Parameters[3].Value = ((int)(EmployeeID.Value));
}
else
{
command.Parameters[3].Value = global::System.DBNull.Value;
}
if ((DocumentPath == null))
{
command.Parameters[4].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[4].Value = ((string)(DocumentPath));
}
global::System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open))
{
command.Connection.Open();
}
int returnValue;
try {
returnValue = command.ExecuteNonQuery();
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
return(returnValue);
}
public virtual int spr_CRM_Update(global::System.Nullable <int> ID, global::System.Nullable <byte> Status, global::System.Nullable <global::System.DateTime> ResponseDate, string ResponseRemarks)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[2]));
if ((ID.HasValue == true))
{
command.Parameters[1].Value = ((int)(ID.Value));
}
else
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
if ((Status.HasValue == true))
{
command.Parameters[2].Value = ((byte)(Status.Value));
}
else
{
command.Parameters[2].Value = global::System.DBNull.Value;
}
if ((ResponseDate.HasValue == true))
{
command.Parameters[3].Value = ((System.DateTime)(ResponseDate.Value));
}
else
{
command.Parameters[3].Value = global::System.DBNull.Value;
}
if ((ResponseRemarks == null))
{
command.Parameters[4].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[4].Value = ((string)(ResponseRemarks));
}
global::System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open))
{
command.Connection.Open();
}
int returnValue;
try {
returnValue = command.ExecuteNonQuery();
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
return(returnValue);
}
public virtual int InsertTowMotorInspectionProblem(global::System.Nullable <int> InspectionID, global::System.Nullable <int> EmployeeID, string TowMotorProblem, string TowMotorProblemUpdate)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((InspectionID.HasValue == true))
{
command.Parameters[1].Value = ((int)(InspectionID.Value));
}
else
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
if ((EmployeeID.HasValue == true))
{
command.Parameters[2].Value = ((int)(EmployeeID.Value));
}
else
{
command.Parameters[2].Value = global::System.DBNull.Value;
}
if ((TowMotorProblem == null))
{
command.Parameters[3].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[3].Value = ((string)(TowMotorProblem));
}
if ((TowMotorProblemUpdate == null))
{
command.Parameters[4].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[4].Value = ((string)(TowMotorProblemUpdate));
}
global::System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open))
{
command.Connection.Open();
}
int returnValue;
try {
returnValue = command.ExecuteNonQuery();
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
return(returnValue);
}
public virtual int InsertRentalTrackingUpdate(global::System.Nullable <int> RentalTrackingID, global::System.Nullable <global::System.DateTime> TransactionDate, global::System.Nullable <int> EmployeeID, string UpdateNotes)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((RentalTrackingID.HasValue == true))
{
command.Parameters[1].Value = ((int)(RentalTrackingID.Value));
}
else
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
if ((TransactionDate.HasValue == true))
{
command.Parameters[2].Value = ((System.DateTime)(TransactionDate.Value));
}
else
{
command.Parameters[2].Value = global::System.DBNull.Value;
}
if ((EmployeeID.HasValue == true))
{
command.Parameters[3].Value = ((int)(EmployeeID.Value));
}
else
{
command.Parameters[3].Value = global::System.DBNull.Value;
}
if ((UpdateNotes == null))
{
command.Parameters[4].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[4].Value = ((string)(UpdateNotes));
}
global::System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open))
{
command.Connection.Open();
}
int returnValue;
try {
returnValue = command.ExecuteNonQuery();
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
return(returnValue);
}
public virtual int InsertFuelCard(global::System.Nullable <int> EmployeeID, global::System.Nullable <global::System.DateTime> DateAssigned, global::System.Nullable <int> FuelCardAssignment, global::System.Nullable <bool> CodeActive)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((EmployeeID.HasValue == true))
{
command.Parameters[1].Value = ((int)(EmployeeID.Value));
}
else
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
if ((DateAssigned.HasValue == true))
{
command.Parameters[2].Value = ((System.DateTime)(DateAssigned.Value));
}
else
{
command.Parameters[2].Value = global::System.DBNull.Value;
}
if ((FuelCardAssignment.HasValue == true))
{
command.Parameters[3].Value = ((int)(FuelCardAssignment.Value));
}
else
{
command.Parameters[3].Value = global::System.DBNull.Value;
}
if ((CodeActive.HasValue == true))
{
command.Parameters[4].Value = ((bool)(CodeActive.Value));
}
else
{
command.Parameters[4].Value = global::System.DBNull.Value;
}
global::System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open))
{
command.Connection.Open();
}
int returnValue;
try {
returnValue = command.ExecuteNonQuery();
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
return(returnValue);
}
public virtual int UpdateVehicleProblemResolution(global::System.Nullable <int> intProblemID, global::System.Nullable <global::System.DateTime> datResolutionDate, string strResolution, global::System.Nullable <int> intInvoiceID)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((intProblemID.HasValue == true))
{
command.Parameters[1].Value = ((int)(intProblemID.Value));
}
else
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
if ((datResolutionDate.HasValue == true))
{
command.Parameters[2].Value = ((System.DateTime)(datResolutionDate.Value));
}
else
{
command.Parameters[2].Value = global::System.DBNull.Value;
}
if ((strResolution == null))
{
command.Parameters[3].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[3].Value = ((string)(strResolution));
}
if ((intInvoiceID.HasValue == true))
{
command.Parameters[4].Value = ((int)(intInvoiceID.Value));
}
else
{
command.Parameters[4].Value = global::System.DBNull.Value;
}
global::System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open))
{
command.Connection.Open();
}
int returnValue;
try {
returnValue = command.ExecuteNonQuery();
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
return(returnValue);
}
public virtual int InsertEmployeeTimeClockEntry(global::System.Nullable <int> intEmployeeID, global::System.Nullable <int> intPayID, global::System.Nullable <global::System.DateTime> datPunchTime, string strPunchStatus)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((intEmployeeID.HasValue == true))
{
command.Parameters[1].Value = ((int)(intEmployeeID.Value));
}
else
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
if ((intPayID.HasValue == true))
{
command.Parameters[2].Value = ((int)(intPayID.Value));
}
else
{
command.Parameters[2].Value = global::System.DBNull.Value;
}
if ((datPunchTime.HasValue == true))
{
command.Parameters[3].Value = ((System.DateTime)(datPunchTime.Value));
}
else
{
command.Parameters[3].Value = global::System.DBNull.Value;
}
if ((strPunchStatus == null))
{
command.Parameters[4].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[4].Value = ((string)(strPunchStatus));
}
global::System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open))
{
command.Connection.Open();
}
int returnValue;
try {
returnValue = command.ExecuteNonQuery();
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
return(returnValue);
}
public virtual int InsertEmployeePunchedHours(global::System.Nullable <global::System.DateTime> datTransactionDate, global::System.Nullable <int> intEmployeeID, global::System.Nullable <int> intPayID, global::System.Nullable <decimal> decHours)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((datTransactionDate.HasValue == true))
{
command.Parameters[1].Value = ((System.DateTime)(datTransactionDate.Value));
}
else
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
if ((intEmployeeID.HasValue == true))
{
command.Parameters[2].Value = ((int)(intEmployeeID.Value));
}
else
{
command.Parameters[2].Value = global::System.DBNull.Value;
}
if ((intPayID.HasValue == true))
{
command.Parameters[3].Value = ((int)(intPayID.Value));
}
else
{
command.Parameters[3].Value = global::System.DBNull.Value;
}
if ((decHours.HasValue == true))
{
command.Parameters[4].Value = ((decimal)(decHours.Value));
}
else
{
command.Parameters[4].Value = global::System.DBNull.Value;
}
global::System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open))
{
command.Connection.Open();
}
int returnValue;
try {
returnValue = command.ExecuteNonQuery();
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
return(returnValue);
}
public virtual int TMS_Attendances_GetReportData(global::System.Nullable <long> CourseID, global::System.Nullable <long> ClassID, global::System.Nullable <global::System.DateTime> WeekStartDate, global::System.Nullable <global::System.DateTime> WeekEndDate)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((CourseID.HasValue == true))
{
command.Parameters[1].Value = ((long)(CourseID.Value));
}
else
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
if ((ClassID.HasValue == true))
{
command.Parameters[2].Value = ((long)(ClassID.Value));
}
else
{
command.Parameters[2].Value = global::System.DBNull.Value;
}
if ((WeekStartDate.HasValue == true))
{
command.Parameters[3].Value = ((System.DateTime)(WeekStartDate.Value));
}
else
{
command.Parameters[3].Value = global::System.DBNull.Value;
}
if ((WeekEndDate.HasValue == true))
{
command.Parameters[4].Value = ((System.DateTime)(WeekEndDate.Value));
}
else
{
command.Parameters[4].Value = global::System.DBNull.Value;
}
global::System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open))
{
command.Connection.Open();
}
int returnValue;
try {
returnValue = command.ExecuteNonQuery();
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
return(returnValue);
}
public virtual int UpdateTrailerCurrentLoad(global::System.Nullable <int> intTrailerID, global::System.Nullable <int> intPartID, string strReelNumber, global::System.Nullable <int> intCurrentFootage)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((intTrailerID.HasValue == true))
{
command.Parameters[1].Value = ((int)(intTrailerID.Value));
}
else
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
if ((intPartID.HasValue == true))
{
command.Parameters[2].Value = ((int)(intPartID.Value));
}
else
{
command.Parameters[2].Value = global::System.DBNull.Value;
}
if ((strReelNumber == null))
{
command.Parameters[3].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[3].Value = ((string)(strReelNumber));
}
if ((intCurrentFootage.HasValue == true))
{
command.Parameters[4].Value = ((int)(intCurrentFootage.Value));
}
else
{
command.Parameters[4].Value = global::System.DBNull.Value;
}
global::System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open))
{
command.Connection.Open();
}
int returnValue;
try {
returnValue = command.ExecuteNonQuery();
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
return(returnValue);
}
public virtual int InsertCellPhone(string PhoneNumber, global::System.Nullable <int> EmployeeID, global::System.Nullable <int> WarehouseID, string PhoneNotes)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((PhoneNumber == null))
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[1].Value = ((string)(PhoneNumber));
}
if ((EmployeeID.HasValue == true))
{
command.Parameters[2].Value = ((int)(EmployeeID.Value));
}
else
{
command.Parameters[2].Value = global::System.DBNull.Value;
}
if ((WarehouseID.HasValue == true))
{
command.Parameters[3].Value = ((int)(WarehouseID.Value));
}
else
{
command.Parameters[3].Value = global::System.DBNull.Value;
}
if ((PhoneNotes == null))
{
command.Parameters[4].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[4].Value = ((string)(PhoneNotes));
}
global::System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open))
{
command.Connection.Open();
}
int returnValue;
try {
returnValue = command.ExecuteNonQuery();
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
return(returnValue);
}
public virtual int lecture_table_for_dept(global::System.Nullable <int> clas_id, global::System.Nullable <int> lev_id, global::System.Nullable <int> sem_num, global::System.Nullable <int> dept_id)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((clas_id.HasValue == true))
{
command.Parameters[1].Value = ((int)(clas_id.Value));
}
else
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
if ((lev_id.HasValue == true))
{
command.Parameters[2].Value = ((int)(lev_id.Value));
}
else
{
command.Parameters[2].Value = global::System.DBNull.Value;
}
if ((sem_num.HasValue == true))
{
command.Parameters[3].Value = ((int)(sem_num.Value));
}
else
{
command.Parameters[3].Value = global::System.DBNull.Value;
}
if ((dept_id.HasValue == true))
{
command.Parameters[4].Value = ((int)(dept_id.Value));
}
else
{
command.Parameters[4].Value = global::System.DBNull.Value;
}
global::System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open))
{
command.Connection.Open();
}
int returnValue;
try {
returnValue = command.ExecuteNonQuery();
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
return(returnValue);
}
public virtual int spr_VASServiceOnDemand_Insert(global::System.Nullable <int> FK_VASServiceID, global::System.Nullable <byte> theType, string theKey, global::System.Nullable <bool> IsSystematic)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((FK_VASServiceID.HasValue == true))
{
command.Parameters[1].Value = ((int)(FK_VASServiceID.Value));
}
else
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
if ((theType.HasValue == true))
{
command.Parameters[2].Value = ((byte)(theType.Value));
}
else
{
command.Parameters[2].Value = global::System.DBNull.Value;
}
if ((theKey == null))
{
command.Parameters[3].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[3].Value = ((string)(theKey));
}
if ((IsSystematic.HasValue == true))
{
command.Parameters[4].Value = ((bool)(IsSystematic.Value));
}
else
{
command.Parameters[4].Value = global::System.DBNull.Value;
}
global::System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open))
{
command.Connection.Open();
}
int returnValue;
try {
returnValue = command.ExecuteNonQuery();
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
return(returnValue);
}
public virtual int InsertServerEventLog(global::System.Nullable <global::System.DateTime> TransactionDate, string EventCategory, string EventNotes, global::System.Nullable <global::System.DateTime> ImportDate)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((TransactionDate.HasValue == true))
{
command.Parameters[1].Value = ((System.DateTime)(TransactionDate.Value));
}
else
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
if ((EventCategory == null))
{
command.Parameters[2].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[2].Value = ((string)(EventCategory));
}
if ((EventNotes == null))
{
command.Parameters[3].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[3].Value = ((string)(EventNotes));
}
if ((ImportDate.HasValue == true))
{
command.Parameters[4].Value = ((System.DateTime)(ImportDate.Value));
}
else
{
command.Parameters[4].Value = global::System.DBNull.Value;
}
global::System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open))
{
command.Connection.Open();
}
int returnValue;
try {
returnValue = command.ExecuteNonQuery();
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
return(returnValue);
}
public virtual int spr_Aggregators_Insert(string Name, string PardisPreNumber, string IMIPreNumber, string Remarks)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[1]));
if ((Name == null))
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[1].Value = ((string)(Name));
}
if ((PardisPreNumber == null))
{
command.Parameters[2].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[2].Value = ((string)(PardisPreNumber));
}
if ((IMIPreNumber == null))
{
command.Parameters[3].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[3].Value = ((string)(IMIPreNumber));
}
if ((Remarks == null))
{
command.Parameters[4].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[4].Value = ((string)(Remarks));
}
global::System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open))
{
command.Connection.Open();
}
int returnValue;
try {
returnValue = command.ExecuteNonQuery();
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
return(returnValue);
}
public virtual int InsertProductionProjectTechAssignment(global::System.Nullable <global::System.DateTime> DateAssigned, global::System.Nullable <int> ProjectID, global::System.Nullable <int> EmployeeID, string AssignmentNotes)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((DateAssigned.HasValue == true))
{
command.Parameters[1].Value = ((System.DateTime)(DateAssigned.Value));
}
else
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
if ((ProjectID.HasValue == true))
{
command.Parameters[2].Value = ((int)(ProjectID.Value));
}
else
{
command.Parameters[2].Value = global::System.DBNull.Value;
}
if ((EmployeeID.HasValue == true))
{
command.Parameters[3].Value = ((int)(EmployeeID.Value));
}
else
{
command.Parameters[3].Value = global::System.DBNull.Value;
}
if ((AssignmentNotes == null))
{
command.Parameters[4].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[4].Value = ((string)(AssignmentNotes));
}
global::System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open))
{
command.Connection.Open();
}
int returnValue;
try {
returnValue = command.ExecuteNonQuery();
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
return(returnValue);
}
public virtual int CloseRentalTrackingTransaction(global::System.Nullable <int> TransactionID, global::System.Nullable <global::System.DateTime> ReturnDate, global::System.Nullable <int> TotalDays, global::System.Nullable <decimal> TotalCost)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((TransactionID.HasValue == true))
{
command.Parameters[1].Value = ((int)(TransactionID.Value));
}
else
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
if ((ReturnDate.HasValue == true))
{
command.Parameters[2].Value = ((System.DateTime)(ReturnDate.Value));
}
else
{
command.Parameters[2].Value = global::System.DBNull.Value;
}
if ((TotalDays.HasValue == true))
{
command.Parameters[3].Value = ((int)(TotalDays.Value));
}
else
{
command.Parameters[3].Value = global::System.DBNull.Value;
}
if ((TotalCost.HasValue == true))
{
command.Parameters[4].Value = ((decimal)(TotalCost.Value));
}
else
{
command.Parameters[4].Value = global::System.DBNull.Value;
}
global::System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open))
{
command.Connection.Open();
}
int returnValue;
try {
returnValue = command.ExecuteNonQuery();
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
return(returnValue);
}
public virtual int Update_stock_balance(string organization_no, string store_no, string sku, global::System.Nullable <decimal> quantity)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((organization_no == null))
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[1].Value = ((string)(organization_no));
}
if ((store_no == null))
{
command.Parameters[2].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[2].Value = ((string)(store_no));
}
if ((sku == null))
{
command.Parameters[3].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[3].Value = ((string)(sku));
}
if ((quantity.HasValue == true))
{
command.Parameters[4].Value = ((decimal)(quantity.Value));
}
else
{
command.Parameters[4].Value = global::System.DBNull.Value;
}
global::System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open))
{
command.Connection.Open();
}
int returnValue;
try {
returnValue = command.ExecuteNonQuery();
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
return(returnValue);
}