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