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 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 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 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 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 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 global::System.Nullable <int> SelectReservasVsHospedes()
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
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();
}
object returnValue;
try {
returnValue = command.ExecuteScalar();
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
if (((returnValue == null) ||
(returnValue.GetType() == typeof(global::System.DBNull))))
{
return(new global::System.Nullable <int>());
}
else
{
return(new global::System.Nullable <int>(((int)(returnValue))));
}
}
public global::System.Data.SqlClient.SqlCommand BuildCommand(global::System.Data.SqlClient.SqlTransaction transaction)
{
var command = new global::System.Data.SqlClient.SqlCommand();
this.BuildCommand(command, transaction);
return(command);
}
public virtual object spComplianceData()
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
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();
}
object returnValue;
try {
returnValue = command.ExecuteScalar();
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
if (((returnValue == null) ||
(returnValue.GetType() == typeof(global::System.DBNull))))
{
return(null);
}
else
{
return((object)(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 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 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 global::System.Data.SqlClient.SqlCommand BuildCommand()
{
var command = new global::System.Data.SqlClient.SqlCommand();
this.BuildCommand(command);
return(command);
}
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 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 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 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 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 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 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 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 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 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 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 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);
}
public virtual object prcRptTypeWiseStockSummary(string Line, string Loc, global::System.Nullable <global::System.DateTime> StockDate)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((Line == null))
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[1].Value = ((string)(Line));
}
if ((Loc == null))
{
command.Parameters[2].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[2].Value = ((string)(Loc));
}
if ((StockDate.HasValue == true))
{
command.Parameters[3].Value = ((System.DateTime)(StockDate.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();
}
object returnValue;
try {
returnValue = command.ExecuteScalar();
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed))
{
command.Connection.Close();
}
}
if (((returnValue == null) ||
(returnValue.GetType() == typeof(global::System.DBNull))))
{
return(null);
}
else
{
return((object)(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 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);
}
private void InitCommandCollection() {
_commandCollection = new global::System.Data.SqlClient.SqlCommand[1];
_commandCollection[0] = new global::System.Data.SqlClient.SqlCommand();
_commandCollection[0].Connection = Connection;
_commandCollection[0].CommandText = "SELECT SalesPerson, ID, EstimatedCost, ExtendedPrice, CloseDate, CommissionPercen" +
"t, PBP, OpportunityName, ActualCost, EstimatedPaidDate, AccountName, Type, Invoi" +
"ceCommissionPaid, CommissionPaid FROM dbo.TSPrior";
_commandCollection[0].CommandType = global::System.Data.CommandType.Text;
}
private void InitCommandCollection() {
_commandCollection = new global::System.Data.SqlClient.SqlCommand[1];
_commandCollection[0] = new global::System.Data.SqlClient.SqlCommand();
_commandCollection[0].Connection = Connection;
_commandCollection[0].CommandText = @"SELECT TotalCost, CostPerAttendee, D3PoNumber, Date, EventCourse, EventName, Instructor, Location, Presenter, EventType, EventState, EventStateCodeName, OrderStateCode, OrderStateCodeName, AttendeeName, AttendeeInvoiceDetailName, InvoiceName, AccountID, AccountName, ContactID, ContactName, AttendeePrice, OpportunityName, EventDate, AttendeeStateCode, AttendeeStateCodeName, ordernumber, OpportunityStatecode, OpportunityStateCodeName, attendeeinvoicedetailstatecodename, invoicestatecode, invoicestatecodename, SalesPerson, NumberAttended, AttendeeState, AttendeeStateName, CommissionPaid, CommissionPercent FROM dbo.Training";
_commandCollection[0].CommandType = global::System.Data.CommandType.Text;
}
private void InitCommandCollection() {
_commandCollection = new global::System.Data.SqlClient.SqlCommand[1];
_commandCollection[0] = new global::System.Data.SqlClient.SqlCommand();
_commandCollection[0].Connection = Connection;
_commandCollection[0].CommandText = @"SELECT SalesPersonName, datefulfilled, AccountName, ContactName, OpportunityName, ProjectName, ProductName, PricePerUnit, CostPerUnit, Quantity, Discount, ExtendedPrice, ExtendedCost, TotalCost, CommissionDate, CommissionPercent, ID, Type FROM dbo.Projects";
_commandCollection[0].CommandType = global::System.Data.CommandType.Text;
}
private void InitCommandCollection() {
_commandCollection = new global::System.Data.SqlClient.SqlCommand[1];
_commandCollection[0] = new global::System.Data.SqlClient.SqlCommand();
_commandCollection[0].Connection = Connection;
_commandCollection[0].CommandText = "SELECT SalesPersonName, Date, AccountName, ContactName, OpportunityName, ProductN" +
"ame, PricePerUnit, CostPerUnit, Quantity, Discount, ExtendedPrice, ExtendedCost," +
" CommissionPaid, CommissionPercent, Type, ID, Category FROM dbo.SoldProducts";
_commandCollection[0].CommandType = global::System.Data.CommandType.Text;
}
