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 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 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 object spr_Accessgroup_Insert(string Desp, global::System.Nullable <global::System.DateTime> STime, global::System.Nullable <int> FK_UserID)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[1]));
if ((Desp == null))
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[1].Value = ((string)(Desp));
}
if ((STime.HasValue == true))
{
command.Parameters[2].Value = ((System.DateTime)(STime.Value));
}
else
{
command.Parameters[2].Value = global::System.DBNull.Value;
}
if ((FK_UserID.HasValue == true))
{
command.Parameters[3].Value = ((int)(FK_UserID.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 global::System.Nullable <int> CheckXoa(string ten, global::System.Nullable <bool> gt)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[5]));
if ((ten == null))
{
throw new global::System.ArgumentNullException("ten");
}
else
{
command.Parameters[0].Value = ((string)(ten));
}
if ((gt.HasValue == true))
{
command.Parameters[1].Value = ((bool)(gt.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();
}
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 virtual global::System.Nullable <int> Login(string TAIKHOAN, string MATKHAU)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((TAIKHOAN == null))
{
throw new global::System.ArgumentNullException("TAIKHOAN");
}
else
{
command.Parameters[0].Value = ((string)(TAIKHOAN));
}
if ((MATKHAU == null))
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[1].Value = ((string)(MATKHAU));
}
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 virtual object sp_RemoveCustomerPackage(string CustomerName, string PackageName)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[7]));
if ((CustomerName == null))
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[1].Value = ((string)(CustomerName));
}
if ((PackageName == null))
{
command.Parameters[2].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[2].Value = ((string)(PackageName));
}
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 object GetReportEKOBDailyProductionIndicator(global::System.Nullable <global::System.DateTime> StartDate, global::System.Nullable <global::System.DateTime> EndDate)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((StartDate.HasValue == true))
{
command.Parameters[1].Value = ((System.DateTime)(StartDate.Value));
}
else
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
if ((EndDate.HasValue == true))
{
command.Parameters[2].Value = ((System.DateTime)(EndDate.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();
}
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 string datos(string Param1)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((Param1 == null))
{
throw new global::System.ArgumentNullException("Param1");
}
else
{
command.Parameters[0].Value = ((string)(Param1));
}
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((string)(returnValue));
}
}
public virtual object DEPT(string DEPT1)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((DEPT1 == null))
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[1].Value = ((string)(DEPT1));
}
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 object InsertTestEmployees(global::System.Nullable <long> test_event_id)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((test_event_id.HasValue == true))
{
command.Parameters[1].Value = ((long)(test_event_id.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();
}
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 global::System.Nullable <int> UserQuery(string username)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((username == null))
{
command.Parameters[0].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[0].Value = ((string)(username));
}
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 virtual global::System.Nullable <int> RunPackage(string NombreArchivo, byte[] archivo, string NombrePaquete, string PassPaquete)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((NombreArchivo == null))
{
throw new global::System.ArgumentNullException("NombreArchivo");
}
else
{
command.Parameters[0].Value = ((string)(NombreArchivo));
}
if ((archivo == null))
{
throw new global::System.ArgumentNullException("archivo");
}
else
{
command.Parameters[1].Value = ((byte[])(archivo));
}
if ((NombrePaquete == null))
{
throw new global::System.ArgumentNullException("NombrePaquete");
}
else
{
command.Parameters[2].Value = ((string)(NombrePaquete));
}
if ((PassPaquete == null))
{
throw new global::System.ArgumentNullException("PassPaquete");
}
else
{
command.Parameters[3].Value = ((string)(PassPaquete));
}
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 virtual object spr_CRM_Insert(global::System.Nullable <int> FK_OwnerUserID, global::System.Nullable <int> FK_CRMCategoryID, string Remarks, string ContactNo, byte[] Attachment, string AttachmentMime, global::System.Nullable <global::System.DateTime> RequestDate, 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[1]));
if ((FK_OwnerUserID.HasValue == true))
{
command.Parameters[1].Value = ((int)(FK_OwnerUserID.Value));
}
else
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
if ((FK_CRMCategoryID.HasValue == true))
{
command.Parameters[2].Value = ((int)(FK_CRMCategoryID.Value));
}
else
{
command.Parameters[2].Value = global::System.DBNull.Value;
}
if ((Remarks == null))
{
command.Parameters[3].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[3].Value = ((string)(Remarks));
}
if ((ContactNo == null))
{
command.Parameters[4].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[4].Value = ((string)(ContactNo));
}
if ((Attachment == null))
{
command.Parameters[5].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[5].Value = ((byte[])(Attachment));
}
if ((AttachmentMime == null))
{
command.Parameters[6].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[6].Value = ((string)(AttachmentMime));
}
if ((RequestDate.HasValue == true))
{
command.Parameters[7].Value = ((System.DateTime)(RequestDate.Value));
}
else
{
command.Parameters[7].Value = global::System.DBNull.Value;
}
if ((Status.HasValue == true))
{
command.Parameters[8].Value = ((byte)(Status.Value));
}
else
{
command.Parameters[8].Value = global::System.DBNull.Value;
}
if ((ResponseDate.HasValue == true))
{
command.Parameters[9].Value = ((System.DateTime)(ResponseDate.Value));
}
else
{
command.Parameters[9].Value = global::System.DBNull.Value;
}
if ((ResponseRemarks == null))
{
command.Parameters[10].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[10].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();
}
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 object SP_T_AutoNumber_Get(string name, global::System.Nullable <int> year, global::System.Nullable <int> branchID, global::System.Nullable <bool> _return)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((name == null))
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[1].Value = ((string)(name));
}
if ((year.HasValue == true))
{
command.Parameters[2].Value = ((int)(year.Value));
}
else
{
command.Parameters[2].Value = global::System.DBNull.Value;
}
if ((branchID.HasValue == true))
{
command.Parameters[3].Value = ((int)(branchID.Value));
}
else
{
command.Parameters[3].Value = global::System.DBNull.Value;
}
if ((_return.HasValue == true))
{
command.Parameters[4].Value = ((bool)(_return.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();
}
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 object sp_ExportSalesVouFBusy(global::System.Nullable <global::System.DateTime> SIMDATE, string SIMNO, string SIMSERIES, string UnitCode, string FY)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((SIMDATE.HasValue == true))
{
command.Parameters[1].Value = ((System.DateTime)(SIMDATE.Value));
}
else
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
if ((SIMNO == null))
{
command.Parameters[2].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[2].Value = ((string)(SIMNO));
}
if ((SIMSERIES == null))
{
command.Parameters[3].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[3].Value = ((string)(SIMSERIES));
}
if ((UnitCode == null))
{
command.Parameters[4].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[4].Value = ((string)(UnitCode));
}
if ((FY == null))
{
command.Parameters[5].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[5].Value = ((string)(FY));
}
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 object spr_VASService_Insert(
global::System.Nullable <int> FK_OwnerUserID,
global::System.Nullable <int> FK_AggregatorID,
global::System.Nullable <int> FK_HeadNumberID,
global::System.Nullable <int> FK_VASServiceCategoryID,
global::System.Nullable <bool> IsPardis,
string theWholeNumber,
global::System.Nullable <bool> IsActive,
string ServiceName,
string Remarks,
string HeaderText,
string FooterText,
string WelcomeText,
string GoodbyeText,
global::System.Nullable <decimal> ServicePrice,
global::System.Nullable <decimal> IMIEnduserTariff,
string AggergatorServiceID,
global::System.Nullable <bool> IsOnDemand,
global::System.Nullable <int> FK_UserID,
global::System.Nullable <global::System.DateTime> STime)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((FK_OwnerUserID.HasValue == true))
{
command.Parameters[1].Value = ((int)(FK_OwnerUserID.Value));
}
else
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
if ((FK_AggregatorID.HasValue == true))
{
command.Parameters[2].Value = ((int)(FK_AggregatorID.Value));
}
else
{
command.Parameters[2].Value = global::System.DBNull.Value;
}
if ((FK_HeadNumberID.HasValue == true))
{
command.Parameters[3].Value = ((int)(FK_HeadNumberID.Value));
}
else
{
command.Parameters[3].Value = global::System.DBNull.Value;
}
if ((FK_VASServiceCategoryID.HasValue == true))
{
command.Parameters[4].Value = ((int)(FK_VASServiceCategoryID.Value));
}
else
{
command.Parameters[4].Value = global::System.DBNull.Value;
}
if ((IsPardis.HasValue == true))
{
command.Parameters[5].Value = ((bool)(IsPardis.Value));
}
else
{
command.Parameters[5].Value = global::System.DBNull.Value;
}
if ((theWholeNumber == null))
{
command.Parameters[6].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[6].Value = ((string)(theWholeNumber));
}
if ((IsActive.HasValue == true))
{
command.Parameters[7].Value = ((bool)(IsActive.Value));
}
else
{
command.Parameters[7].Value = global::System.DBNull.Value;
}
if ((ServiceName == null))
{
command.Parameters[8].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[8].Value = ((string)(ServiceName));
}
if ((Remarks == null))
{
command.Parameters[9].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[9].Value = ((string)(Remarks));
}
if ((HeaderText == null))
{
command.Parameters[10].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[10].Value = ((string)(HeaderText));
}
if ((FooterText == null))
{
command.Parameters[11].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[11].Value = ((string)(FooterText));
}
if ((WelcomeText == null))
{
command.Parameters[12].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[12].Value = ((string)(WelcomeText));
}
if ((GoodbyeText == null))
{
command.Parameters[13].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[13].Value = ((string)(GoodbyeText));
}
if ((ServicePrice.HasValue == true))
{
command.Parameters[14].Value = ((decimal)(ServicePrice.Value));
}
else
{
command.Parameters[14].Value = global::System.DBNull.Value;
}
if ((IMIEnduserTariff.HasValue == true))
{
command.Parameters[15].Value = ((decimal)(IMIEnduserTariff.Value));
}
else
{
command.Parameters[15].Value = global::System.DBNull.Value;
}
if ((AggergatorServiceID == null))
{
command.Parameters[16].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[16].Value = ((string)(AggergatorServiceID));
}
if ((IsOnDemand.HasValue == true))
{
command.Parameters[17].Value = ((bool)(IsOnDemand.Value));
}
else
{
command.Parameters[17].Value = global::System.DBNull.Value;
}
if ((FK_UserID.HasValue == true))
{
command.Parameters[18].Value = ((int)(FK_UserID.Value));
}
else
{
command.Parameters[18].Value = global::System.DBNull.Value;
}
if ((STime.HasValue == true))
{
command.Parameters[19].Value = ((System.DateTime)(STime.Value));
}
else
{
command.Parameters[19].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 object sp_insert_payment_in(string payment_prefix, string payment_desc, global::System.Nullable <global::System.DateTime> payment_date, global::System.Nullable <decimal> amount, global::System.Nullable <int> cheque, global::System.Nullable <int> credit_card, global::System.Nullable <int> payment_method, string remark, global::System.Nullable <int> modified_by)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((payment_prefix == null))
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[1].Value = ((string)(payment_prefix));
}
if ((payment_desc == null))
{
command.Parameters[2].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[2].Value = ((string)(payment_desc));
}
if ((payment_date.HasValue == true))
{
command.Parameters[3].Value = ((System.DateTime)(payment_date.Value));
}
else
{
command.Parameters[3].Value = global::System.DBNull.Value;
}
if ((amount.HasValue == true))
{
command.Parameters[4].Value = ((decimal)(amount.Value));
}
else
{
command.Parameters[4].Value = global::System.DBNull.Value;
}
if ((cheque.HasValue == true))
{
command.Parameters[5].Value = ((int)(cheque.Value));
}
else
{
command.Parameters[5].Value = global::System.DBNull.Value;
}
if ((credit_card.HasValue == true))
{
command.Parameters[6].Value = ((int)(credit_card.Value));
}
else
{
command.Parameters[6].Value = global::System.DBNull.Value;
}
if ((payment_method.HasValue == true))
{
command.Parameters[7].Value = ((int)(payment_method.Value));
}
else
{
command.Parameters[7].Value = global::System.DBNull.Value;
}
if ((remark == null))
{
command.Parameters[8].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[8].Value = ((string)(remark));
}
if ((modified_by.HasValue == true))
{
command.Parameters[9].Value = ((int)(modified_by.Value));
}
else
{
command.Parameters[9].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 object spr_NewsContent_Insert(global::System.Nullable <int> FK_OwnerUserID, string theText, global::System.Nullable <global::System.DateTime> SendDate, global::System.Nullable <global::System.TimeSpan> SendTime, global::System.Nullable <global::System.DateTime> STime)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[1]));
if ((FK_OwnerUserID.HasValue == true))
{
command.Parameters[1].Value = ((int)(FK_OwnerUserID.Value));
}
else
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
if ((theText == null))
{
command.Parameters[2].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[2].Value = ((string)(theText));
}
if ((SendDate.HasValue == true))
{
command.Parameters[3].Value = ((System.DateTime)(SendDate.Value));
}
else
{
command.Parameters[3].Value = global::System.DBNull.Value;
}
if ((SendTime.HasValue == true))
{
command.Parameters[4].Value = ((System.TimeSpan)(SendTime.Value));
}
else
{
command.Parameters[4].Value = global::System.DBNull.Value;
}
if ((STime.HasValue == true))
{
command.Parameters[5].Value = ((System.DateTime)(STime.Value));
}
else
{
command.Parameters[5].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 object spr_User_Insert(
string Username,
string Password,
global::System.Nullable <bool> IsActive,
global::System.Nullable <bool> IsDataAdmin,
global::System.Nullable <bool> IsItemAdmin,
string FName,
string LName,
global::System.Nullable <bool> IsMale,
string Tel,
string Mobile,
global::System.Nullable <global::System.DateTime> STime,
global::System.Nullable <int> FK_UserID,
string NationalID,
string NationalNo,
string Address,
byte[] UserPhoto,
global::System.Nullable <bool> IsReal)
{
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((Username == null))
{
command.Parameters[1].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[1].Value = ((string)(Username));
}
if ((Password == null))
{
command.Parameters[2].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[2].Value = ((string)(Password));
}
if ((IsActive.HasValue == true))
{
command.Parameters[3].Value = ((bool)(IsActive.Value));
}
else
{
command.Parameters[3].Value = global::System.DBNull.Value;
}
if ((IsDataAdmin.HasValue == true))
{
command.Parameters[4].Value = ((bool)(IsDataAdmin.Value));
}
else
{
command.Parameters[4].Value = global::System.DBNull.Value;
}
if ((IsItemAdmin.HasValue == true))
{
command.Parameters[5].Value = ((bool)(IsItemAdmin.Value));
}
else
{
command.Parameters[5].Value = global::System.DBNull.Value;
}
if ((FName == null))
{
command.Parameters[6].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[6].Value = ((string)(FName));
}
if ((LName == null))
{
command.Parameters[7].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[7].Value = ((string)(LName));
}
if ((IsMale.HasValue == true))
{
command.Parameters[8].Value = ((bool)(IsMale.Value));
}
else
{
command.Parameters[8].Value = global::System.DBNull.Value;
}
if ((Tel == null))
{
command.Parameters[9].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[9].Value = ((string)(Tel));
}
if ((Mobile == null))
{
command.Parameters[10].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[10].Value = ((string)(Mobile));
}
if ((STime.HasValue == true))
{
command.Parameters[11].Value = ((System.DateTime)(STime.Value));
}
else
{
command.Parameters[11].Value = global::System.DBNull.Value;
}
if ((FK_UserID.HasValue == true))
{
command.Parameters[12].Value = ((int)(FK_UserID.Value));
}
else
{
command.Parameters[12].Value = global::System.DBNull.Value;
}
if ((NationalID == null))
{
command.Parameters[13].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[13].Value = ((string)(NationalID));
}
if ((NationalNo == null))
{
command.Parameters[14].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[14].Value = ((string)(NationalNo));
}
if ((Address == null))
{
command.Parameters[15].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[15].Value = ((string)(Address));
}
if ((UserPhoto == null))
{
command.Parameters[16].Value = global::System.DBNull.Value;
}
else
{
command.Parameters[16].Value = ((byte[])(UserPhoto));
}
if ((IsReal.HasValue == true))
{
command.Parameters[17].Value = ((bool)(IsReal.Value));
}
else
{
command.Parameters[17].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));
}
}