public override bool UpdateLocalCurrency(System.Int32 localCurrencyId, System.Double?exchangeRate, System.Boolean Inactive, System.Int32 clientNo, System.Int32?updatedBy) { SqlConnection cn = null; SqlCommand cmd = null; try { cn = new SqlConnection(this.ConnectionString); cmd = new SqlCommand("usp_update_LocalCurrency", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@LocalCurrencyId", SqlDbType.Int).Value = localCurrencyId; cmd.Parameters.Add("@ExchangeRate", SqlDbType.Decimal).Value = exchangeRate; cmd.Parameters.Add("@Inactive", SqlDbType.Bit).Value = Inactive; cmd.Parameters.Add("@ClientNo", SqlDbType.Int).Value = clientNo; cmd.Parameters.Add("@UpdatedBy", SqlDbType.Int).Value = updatedBy; cmd.Parameters.Add("@RowsAffected", SqlDbType.Int).Direction = ParameterDirection.Output; cn.Open(); int ret = ExecuteNonQuery(cmd); return(ret > 0); } catch (SqlException sqlex) { //LogException(sqlex); throw new Exception("Failed to update LocalCurrency", sqlex); } finally { cmd.Dispose(); cn.Close(); cn.Dispose(); } }
/// <summary> /// Update DebitLine /// Calls [usp_update_DebitLine] /// </summary> public override bool Update(System.Int32?debitLineId, System.Int32?quantity, System.Double?price, System.String part, System.String supplierPart, System.String notes, System.Int32?updatedBy, System.Boolean?printHazardous) { SqlConnection cn = null; SqlCommand cmd = null; try { cn = new SqlConnection(this.ConnectionString); cmd = new SqlCommand("usp_update_DebitLine", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@DebitLineId", SqlDbType.Int).Value = debitLineId; cmd.Parameters.Add("@Quantity", SqlDbType.Int).Value = quantity; cmd.Parameters.Add("@Price", SqlDbType.Float).Value = price; cmd.Parameters.Add("@Part", SqlDbType.NVarChar).Value = part; cmd.Parameters.Add("@SupplierPart", SqlDbType.NVarChar).Value = supplierPart; cmd.Parameters.Add("@Notes", SqlDbType.NVarChar).Value = notes; cmd.Parameters.Add("@UpdatedBy", SqlDbType.Int).Value = updatedBy; cmd.Parameters.Add("@PrintHazardous", SqlDbType.Bit).Value = printHazardous; cmd.Parameters.Add("@RowsAffected", SqlDbType.Int).Direction = ParameterDirection.Output; cn.Open(); int ret = ExecuteNonQuery(cmd); return(ret > 0); } catch (SqlException sqlex) { //LogException(sqlex); throw new Exception("Failed to update DebitLine", sqlex); } finally { cmd.Dispose(); cn.Close(); cn.Dispose(); } }
/// <summary> /// Create a new row /// Calls [usp_insert_GlobalTaxRate] /// </summary> public override Int32 Insert(System.DateTime?taxDate, System.Int32?taxNo, System.Double?rate1, System.Double?rate2, System.Int32?updatedBy) { SqlConnection cn = null; SqlCommand cmd = null; try { cn = new SqlConnection(this.ConnectionString); cmd = new SqlCommand("usp_insert_GlobalTaxRate", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@TaxDate", SqlDbType.DateTime).Value = taxDate; cmd.Parameters.Add("@TaxNo", SqlDbType.Int).Value = taxNo; cmd.Parameters.Add("@Rate1", SqlDbType.Float).Value = rate1; cmd.Parameters.Add("@Rate2", SqlDbType.Float).Value = rate2; cmd.Parameters.Add("@UpdatedBy", SqlDbType.Int).Value = updatedBy; cmd.Parameters.Add("@TaxRateId", SqlDbType.Int).Direction = ParameterDirection.Output; cn.Open(); int ret = ExecuteNonQuery(cmd); return((Int32)cmd.Parameters["@TaxRateId"].Value); } catch (SqlException sqlex) { //LogException(sqlex); throw new Exception("Failed to insert TaxRate", sqlex); } finally { cmd.Dispose(); cn.Close(); cn.Dispose(); } }
/// <summary> /// This method is called during deserialization to convert a given value to a specific typed value (Double?). /// </summary> /// <param name="serializationContext">The current serialization context instance.</param> /// <param name="modelELement">ModdelElement, to which the property belongs to.</param> /// <param name="propertyName">The Property name, which value is to be converted.</param> /// <param name="value">Value to convert.</param> /// <param name="targetType">Type, the object is to be converted to.</param> /// <param name="isRequired">True if this property is marked as required in the domain model. Can be null.</param> /// <returns>Converted value.</returns> public override global::System.Double?ConvertTypedObjectDoubleFrom(DslModeling::SerializationContext serializationContext, DslModeling::ModelElement modelELement, string propertyName, object value, System.Type targetType, bool?isRequired) { if (value is string) { if (String.IsNullOrEmpty(value as string)) { return(null); } if (String.IsNullOrWhiteSpace(value as string)) { return(null); } try { System.Double?d = Convert.ToDouble(value, System.Globalization.CultureInfo.InvariantCulture); return(d); } catch (Exception ex) { serializationContext.Result.AddMessage(new DslModeling::SerializationMessage( DslModeling::SerializationMessageKind.Error, "Couldnt convert " + value + " to Double: " + ex.ToString(), "", 0, 0, null)); } } return(null); }
/// <summary> /// Create a new row /// Calls [usp_insert_Lot] /// </summary> public override Int32 Insert(System.Int32?clientNo, System.String lotName, System.Double?cost, System.Int32?currencyNo, System.Boolean?onHold, System.Boolean?consignment, System.String notes, System.String lotCode, System.Int32?updatedBy, System.Int32?LockForCustomerNo) { SqlConnection cn = null; SqlCommand cmd = null; try { cn = new SqlConnection(this.ConnectionString); cmd = new SqlCommand("usp_insert_Lot", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ClientNo", SqlDbType.Int).Value = clientNo; cmd.Parameters.Add("@LotName", SqlDbType.NVarChar).Value = lotName; cmd.Parameters.Add("@Cost", SqlDbType.Float).Value = cost; cmd.Parameters.Add("@CurrencyNo", SqlDbType.Int).Value = currencyNo; cmd.Parameters.Add("@OnHold", SqlDbType.Bit).Value = onHold; cmd.Parameters.Add("@Consignment", SqlDbType.Bit).Value = consignment; cmd.Parameters.Add("@Notes", SqlDbType.NVarChar).Value = notes; cmd.Parameters.Add("@LotCode", SqlDbType.NVarChar).Value = lotCode; cmd.Parameters.Add("@UpdatedBy", SqlDbType.Int).Value = updatedBy; cmd.Parameters.Add("@LockForCustomerNo", SqlDbType.NVarChar).Value = LockForCustomerNo; cmd.Parameters.Add("@LotId", SqlDbType.Int).Direction = ParameterDirection.Output; cn.Open(); int ret = ExecuteNonQuery(cmd); return((Int32)cmd.Parameters["@LotId"].Value); } catch (SqlException sqlex) { //LogException(sqlex); throw new Exception("Failed to insert Lot", sqlex); } finally { cmd.Dispose(); cn.Close(); cn.Dispose(); } }
public TimeVariantLocalConditionDTO( System.Double?p_ConditionScoreLocal, CL.FormulaHelper.DTOs.TimePeriodDTO p_TimePeriod) { ConditionScoreLocal = p_ConditionScoreLocal; TimePeriod = p_TimePeriod; }
/// <summary> /// Call Proc [usp_insert_SupplierInvoice] /// Insert supplier invoice header /// </summary> /// <param name="clientId"></param> /// <param name="companyNo"></param> /// <param name="supplierInvoiceNumber"></param> /// <param name="supplierInvoiceDate"></param> /// <param name="supplierCode"></param> /// <param name="supplierName"></param> /// <param name="cuurencyNo"></param> /// <param name="amount"></param> /// <param name="goodsValue"></param> /// <param name="Tax"></param> /// <param name="deliveryCharge"></param> /// <param name="bankFee"></param> /// <param name="creditCardFee"></param> /// <param name="notes"></param> /// <param name="secondRef"></param> /// <param name="narrative"></param> /// <param name="canBeExported"></param> /// <param name="taxNo"></param> /// <param name="taxCode"></param> /// <param name="currencyCode"></param> /// <param name="updatedBy"></param> /// <returns></returns> public static Int32 Insert(System.Int32?clientNo, System.Int32?PurchaseHubClientNo, System.Double?amount, System.Double?goodsValue, System.Double?tax, System.Int32?taxNo, System.String taxCode, System.Double?deliveryCharge, System.Double?bankFee, System.Double?creditCardFee, System.String notes, System.String secondRef, System.String narrative, System.Boolean?canBeExported, System.Int32 updatedBy, System.Int32?currencyNo, System.String currencyCode) { Int32 objReturn = Rebound.GlobalTrader.DAL.SiteProvider.ClientInvoice.Insert(clientNo, PurchaseHubClientNo, amount, goodsValue, tax, taxNo, taxCode, deliveryCharge, bankFee, creditCardFee, notes, secondRef, narrative, canBeExported, updatedBy, currencyNo, currencyCode); return(objReturn); }
protected void MapFrom(DataRow dr) { SolSaID = dr["sol_sa_ID"] != DBNull.Value ? Convert.ToInt32(dr["sol_sa_ID"]) : SolSaID = null; SolicitudID = dr["solicitudID"] != DBNull.Value ? Convert.ToInt32(dr["solicitudID"]) : SolicitudID = null; SeguroID = dr["seguroID"] != DBNull.Value ? Convert.ToInt32(dr["seguroID"]) : SeguroID = null; HectAseguradas = dr["hectAseguradas"] != DBNull.Value ? Convert.ToDouble(dr["hectAseguradas"]) : HectAseguradas = null; DescParcelas = dr["descParcelas"] != DBNull.Value ? Convert.ToString(dr["descParcelas"]) : DescParcelas = null; CostoTotalSeguro = dr["CostoTotalSeguro"] != DBNull.Value ? Convert.ToDouble(dr["CostoTotalSeguro"]) : CostoTotalSeguro = null; }
/// <summary> /// Construct SmartDouble from System.Double. /// </summary> public SmartDouble(System.Double?value) { if (value.HasValue) { m_v = value.Value; } else { m_v = BadValue.m_v; } }
private void SetValue(System.Double?Value) { this._value = Value; this.OnPropertyChanged("Value"); if (this.Binding != null) { this.UpdatingBinding = true; ((Model.Properties.Float) this.Binding).Value = this.Value; this.UpdatingBinding = false; } }
public static DataSet BindAlredyexistElectricity(System.Int64?elEbillID, System.Double?elBillAmount, System.Double?elLateFees, System.String elMonth, System.String elYear, System.DateTime?elLastDate, System.DateTime?elBillPaidDate, System.Double?elTotalAmount, System.String elPaidStatus, System.String elExtra1) { DataSet ds; Database db; string sqlCommand; DbCommand dbCommand; db = DatabaseFactory.CreateDatabase(); sqlCommand = "[dbo].gspTMSAlredyexistElectricitySEARCH"; dbCommand = db.GetStoredProcCommand(sqlCommand, elEbillID, elBillAmount, elLateFees, elMonth, elYear, elLastDate, elBillPaidDate, elTotalAmount, elPaidStatus, elExtra1); ds = db.ExecuteDataSet(dbCommand); return(ds); }
public virtual void CopyFrom(PerformanceStatistic other) { if (other != null) { this.PerformanceStatisticId = other.PerformanceStatisticId; this.Cpu = other.Cpu; this.Memory = other.Memory; this.CreationDate = other.CreationDate; this.MachineName = other.MachineName; this.IpAddress = other.IpAddress; this.DriveSpaceAvailable = other.DriveSpaceAvailable; this.DriveTotalSpace = other.DriveTotalSpace; } }
/// <summary> /// GetConvertedValueBetweenTwoCurrencies /// Calls [usp_select_Currency_ConvertedValueBetweenTwoCurrencies] /// </summary> public static Currency GetConvertedValueBetweenTwoCurrencies(System.Double?valueToBeConverted, System.Int32?currencyFromId, System.Int32?currencyToId, System.DateTime?exchangeRateDate) { Rebound.GlobalTrader.DAL.CurrencyDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Currency.GetConvertedValueBetweenTwoCurrencies(valueToBeConverted, currencyFromId, currencyToId, exchangeRateDate); if (objDetails == null) { return(null); } else { Currency obj = new Currency(); obj.ConvertedValue = objDetails.ConvertedValue; objDetails = null; return(obj); } }
/// <summary> /// Sets properties and attributes of class in accordance with Binary definition. /// </summary> /// <param name="Definition">Binary definition</param> public override Task FromXml(XmlElement Definition) { if (System.Double.TryParse(Definition.InnerText, out System.Double Value)) { this.value = Value; this.script = null; } else { this.value = null; this.script = new Expression(Definition.InnerText); } return(Task.CompletedTask); }
/// <summary> /// Call Proc [usp_insert_ClientInvoiceManual] /// Insert client invoice header /// </summary> /// <param name="clientNo"></param> /// <param name="companyNo"></param> /// <param name="supplierInvoiceNumber"></param> /// <param name="supplierInvoiceDate"></param> /// <param name="supplierCode"></param> /// <param name="supplierName"></param> /// <param name="cuurencyNo"></param> /// <param name="amount"></param> /// <param name="goodsValue"></param> /// <param name="Tax"></param> /// <param name="deliveryCharge"></param> /// <param name="bankFee"></param> /// <param name="creditCardFee"></param> /// <param name="notes"></param> /// <param name="secondRef"></param> /// <param name="narrative"></param> /// <param name="canBeExported"></param> /// <param name="taxNo"></param> /// <param name="TaxCode"></param> /// <param name="currencyCode"></param> /// <param name="updatedBy"></param> /// <returns></returns> public override Int32 Insert(System.Int32?clientNo, System.Int32?PurchaseHubClientNo, System.Double?amount, System.Double?goodsValue, System.Double?tax, System.Int32?taxNo, System.String taxCode, System.Double?deliveryCharge, System.Double?bankFee, System.Double?creditCardFee, System.String notes, System.String secondRef, System.String narrative, System.Boolean?canBeExported, System.Int32 updatedBy, System.Int32?currencyNo, System.String currencyCode) { SqlConnection cn = null; SqlCommand cmd = null; try { cn = new SqlConnection(this.ConnectionString); cmd = new SqlCommand("usp_insert_ClientInvoiceManual", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ClientNo", SqlDbType.Int).Value = clientNo; cmd.Parameters.Add("@PurchaseHubClientNo", SqlDbType.Int).Value = PurchaseHubClientNo; cmd.Parameters.Add("@InvoiceAmount", SqlDbType.Float).Value = amount; cmd.Parameters.Add("@GoodsValue", SqlDbType.Float).Value = goodsValue; cmd.Parameters.Add("@Tax", SqlDbType.Float).Value = tax; cmd.Parameters.Add("@TaxNo", SqlDbType.Int).Value = taxNo; cmd.Parameters.Add("@TaxCode", SqlDbType.NVarChar).Value = taxCode; cmd.Parameters.Add("@DeliveryCharge", SqlDbType.Float).Value = deliveryCharge; cmd.Parameters.Add("@BankFee", SqlDbType.Float).Value = bankFee; cmd.Parameters.Add("@CreditCardFee", SqlDbType.Float).Value = creditCardFee; cmd.Parameters.Add("@Notes", SqlDbType.NVarChar).Value = notes; cmd.Parameters.Add("@SecondRef", SqlDbType.NVarChar).Value = secondRef; cmd.Parameters.Add("@Narrative", SqlDbType.NVarChar).Value = narrative; cmd.Parameters.Add("@CanbeExported", SqlDbType.Bit).Value = canBeExported; cmd.Parameters.Add("@UpdatedBy", SqlDbType.Int).Value = updatedBy; cmd.Parameters.Add("@CurrencyNo", SqlDbType.Int).Value = currencyNo; cmd.Parameters.Add("@CurrencyCode", SqlDbType.NVarChar).Value = currencyCode; cmd.Parameters.Add("@ClientInvoiceNo", SqlDbType.Int).Direction = ParameterDirection.Output; cn.Open(); int ret = ExecuteNonQuery(cmd); return((Int32)cmd.Parameters["@ClientInvoiceNo"].Value); } catch (SqlException sqlex) { //LogException(sqlex); throw new Exception("Failed to insert Client Invoice", sqlex); } finally { cmd.Dispose(); cn.Close(); cn.Dispose(); } }
public static DataSet GetalredyexistWatersupply(System.Int64?wsWsid, System.Double?wsBillAmount, System.Double?wsLateFees, System.String wsMonth, System.String wsYear, System.DateTime?wsLastDate, System.DateTime?wsBillPaidDate, System.Double?wsTotalAmount, System.String wsPaidStatus, System.String wsBillNumber, System.String wsExtra1, System.DateTime?wsDate, System.Int32?wsStatus) { DataSet ds; Database db; string sqlCommand; DbCommand dbCommand; db = DatabaseFactory.CreateDatabase(); sqlCommand = "[dbo].gspTMSalredyexistWatersupply"; dbCommand = db.GetStoredProcCommand(sqlCommand, wsWsid, wsBillAmount, wsLateFees, wsMonth, wsYear, wsLastDate, wsBillPaidDate, wsTotalAmount, wsPaidStatus, wsBillNumber, wsExtra1, wsDate, wsStatus); ds = db.ExecuteDataSet(dbCommand); return(ds); }
protected void MapFrom(DataRow dr) { EntradaprodID = dr["entradaprodID"] != DBNull.Value ? Convert.ToInt32(dr["entradaprodID"]) : EntradaprodID = null; ProductoID = dr["productoID"] != DBNull.Value ? Convert.ToInt32(dr["productoID"]) : ProductoID = null; BodegaID = dr["bodegaID"] != DBNull.Value ? Convert.ToInt32(dr["bodegaID"]) : BodegaID = null; TipoMovProdID = dr["tipoMovProdID"] != DBNull.Value ? Convert.ToInt32(dr["tipoMovProdID"]) : TipoMovProdID = null; Fecha = dr["Fecha"] != DBNull.Value ? Convert.ToDateTime(dr["Fecha"]) : Fecha = null; Cantidad = dr["cantidad"] != DBNull.Value ? Convert.ToDouble(dr["cantidad"]) : Cantidad = null; Observaciones = dr["observaciones"] != DBNull.Value ? Convert.ToString(dr["observaciones"]) : Observaciones = null; UserID = dr["userID"] != DBNull.Value ? Convert.ToInt32(dr["userID"]) : UserID = null; StoreTS = dr["storeTS"] != DBNull.Value ? Convert.ToDateTime(dr["storeTS"]) : StoreTS = null; UpdateTS = dr["updateTS"] != DBNull.Value ? Convert.ToDateTime(dr["updateTS"]) : UpdateTS = null; CicloID = dr["cicloID"] != DBNull.Value ? Convert.ToInt32(dr["cicloID"]) : CicloID = null; Preciocompra = dr["preciocompra"] != DBNull.Value ? Convert.ToDouble(dr["preciocompra"]) : Preciocompra = null; Sacos = dr["sacos"] != DBNull.Value ? Convert.ToDouble(dr["sacos"]) : Sacos = null; }
public static TMSElectricity[] Search(System.Int64?elEbillID, System.Double?elBillAmount, System.Double?elLateFees, System.String elMonth, System.String elYear, System.DateTime?elLastDate, System.DateTime?elBillPaidDate, System.Double?elTotalAmount, System.String elPaidStatus, System.String elbIllno, System.String elBillFile, System.String elExtra1, System.String elExtra2, System.DateTime?elDate, System.Int32?elStatus) { DataSet ds; Database db; string sqlCommand; DbCommand dbCommand; db = DatabaseFactory.CreateDatabase(); sqlCommand = "[dbo].gspTMSElectricity_SEARCH"; dbCommand = db.GetStoredProcCommand(sqlCommand, elEbillID, elBillAmount, elLateFees, elMonth, elYear, elLastDate, elBillPaidDate, elTotalAmount, elPaidStatus, elbIllno, elBillFile, elExtra1, elExtra2, elDate, elStatus); ds = db.ExecuteDataSet(dbCommand); ds.Tables[0].TableName = TABLE_NAME; return(TMSElectricity.MapFrom(ds)); }
public static TMSWatersupply[] Search(System.Int64?wsWsid, System.Double?wsBillAmount, System.Double?wsLateFees, System.String wsMonth, System.String wsYear, System.DateTime?wsLastDate, System.DateTime?wsBillPaidDate, System.Double?wsTotalAmount, System.String wsPaidStatus, System.String wsBillNumber, System.String wsExtra1, System.DateTime?wsDate, System.Int32?wsStatus) { DataSet ds; Database db; string sqlCommand; DbCommand dbCommand; db = DatabaseFactory.CreateDatabase(); sqlCommand = "[dbo].gspTMSWatersupply_SEARCH"; dbCommand = db.GetStoredProcCommand(sqlCommand, wsWsid, wsBillAmount, wsLateFees, wsMonth, wsYear, wsLastDate, wsBillPaidDate, wsTotalAmount, wsPaidStatus, wsBillNumber, wsExtra1, wsDate, wsStatus); ds = db.ExecuteDataSet(dbCommand); ds.Tables[0].TableName = TABLE_NAME; return(TMSWatersupply.MapFrom(ds)); }
/// <summary> /// Create a new font /// </summary> /// <param name="isBold">Whether the text should be bold</param> /// <param name="fontFamily">The font family eg: "Arial"</param> /// <param name="size">The font size</param> /// <param name="color">The font color (value of the color theme)</param> /// <returns></returns> public static Font CreateFont(bool isBold, bool isItalic, string fontFamily, System.Double?size, string color) { Font font = new Font(); if (size.HasValue) { FontSize fontSize = new FontSize() { Val = size }; font.Append(fontSize); } if (isItalic) { Italic italic = new Italic(); font.Append(italic); } if (isBold) { Bold bold = new Bold(); font.Append(bold); } if (color != null) { Color color1 = new Color() { Rgb = color }; font.Append(color1); } if (!string.IsNullOrEmpty(fontFamily)) { FontName fontName = new FontName() { Val = fontFamily }; font.Append(fontName); } return(font); }
//[Benchmark] public System.Double?Additions_DoubleNull() { System.Double?s = 0; System.Double?d = 7; for (var cc = 0; cc < cycles; cc++) { s = 0; d = 7; for (var i = 0; i < count; i++) { s += d; } } return(s); }
/// <summary> /// Initializes a new instance of the <see cref="SummaryData"/> class. /// </summary> /// <param name="KnownMathCalculation">The known math calculation.</param> /// <param name="ValueType">Type of the value.</param> /// <param name="SummaryValueDouble">The summary value double.</param> /// <param name="SummaryValueDateTime">The summary value date time.</param> /// <param name="SummaryValueString">The summary value string.</param> /// <param name="HeaderString">The header string.</param> /// <param name="DisplayFormat">The display format.</param> public SummaryData( Framework.EntityContracts.KnownMathCalculations KnownMathCalculation, System.Type ValueType, System.Double?SummaryValueDouble, System.DateTime?SummaryValueDateTime, System.String SummaryValueString, System.String HeaderString, System.String DisplayFormat ) { this.KnownMathCalculation = KnownMathCalculation; this.ValueType = ValueType; this.SummaryValueDouble = SummaryValueDouble; this.SummaryValueDateTime = SummaryValueDateTime; this.SummaryValueString = SummaryValueString; this.HeaderString = HeaderString; this.DisplayFormat = DisplayFormat; }
/// <summary> /// Adds the specified known math calculation. /// </summary> /// <param name="KnownMathCalculation">The known math calculation.</param> /// <param name="ValueType">Type of the value.</param> /// <param name="SummaryValueDouble">The summary value double.</param> /// <param name="SummaryValueDateTime">The summary value date time.</param> /// <param name="SummaryValueString">The summary value string.</param> /// <param name="HeaderString">The header string.</param> /// <param name="DisplayFormat">The display format.</param> public void Add( Framework.EntityContracts.KnownMathCalculations KnownMathCalculation, System.Type ValueType, System.Double?SummaryValueDouble, System.DateTime?SummaryValueDateTime, System.String SummaryValueString, System.String HeaderString, System.String DisplayFormat) { SummaryData _Item = new SummaryData( KnownMathCalculation, ValueType, SummaryValueDouble, SummaryValueDateTime, SummaryValueString, HeaderString, DisplayFormat); this.Add(_Item); }
public void Insert(System.Int32?facturaid, System.Int32?productoID, System.Double?precio, System.Double?cantidad, System.Int32?bodegaID, DbTransaction transaction) { Database db; string sqlCommand; DbCommand dbCommand; db = DatabaseFactory.CreateDatabase(); sqlCommand = "[dbo].gspFacturaDeProveedorDetalle_INSERT"; dbCommand = db.GetStoredProcCommand(sqlCommand, facturaid, productoID, precio, cantidad, bodegaID); if (transaction == null) { this.FacturaProveedordetalleID = Convert.ToInt32(db.ExecuteScalar(dbCommand)); } else { this.FacturaProveedordetalleID = Convert.ToInt32(db.ExecuteScalar(dbCommand, transaction)); } return; }
public void Insert(System.Int32?solicitudID, System.Int32?seguroID, System.Double?hectAseguradas, System.String descParcelas, System.Double?costoTotalSeguro, DbTransaction transaction) { Database db; string sqlCommand; DbCommand dbCommand; db = DatabaseFactory.CreateDatabase(); sqlCommand = "[dbo].gspSolicitudesSisBancosSeguroAgricola_INSERT"; dbCommand = db.GetStoredProcCommand(sqlCommand, solicitudID, seguroID, hectAseguradas, descParcelas, costoTotalSeguro); if (transaction == null) { this.SolSaID = Convert.ToInt32(db.ExecuteScalar(dbCommand)); } else { this.SolSaID = Convert.ToInt32(db.ExecuteScalar(dbCommand, transaction)); } return; }
public void Insert(System.String racMonth, System.String racYear, System.Double?racTotalAmount, System.Double?racPaidAmount, System.Double?racAnyDues, System.Int64?racAddedById, System.String racPaidStatus, System.DateTime?racTransactionDate, System.DateTime?racDate, System.Int32?racStatus, DbTransaction transaction) { Database db; string sqlCommand; DbCommand dbCommand; db = DatabaseFactory.CreateDatabase(); sqlCommand = "[dbo].gspTMSRentAccountDetails_INSERT"; dbCommand = db.GetStoredProcCommand(sqlCommand, racMonth, racYear, racTotalAmount, racPaidAmount, racAnyDues, racAddedById, racPaidStatus, racTransactionDate, racDate, racStatus); if (transaction == null) { this.RACRentId = Convert.ToInt64(db.ExecuteScalar(dbCommand)); } else { this.RACRentId = Convert.ToInt64(db.ExecuteScalar(dbCommand, transaction)); } return; }
public void Insert(System.Double?wsBillAmount, System.Double?wsLateFees, System.String wsMonth, System.String wsYear, System.DateTime?wsLastDate, System.DateTime?wsBillPaidDate, System.Double?wsTotalAmount, System.String wsPaidStatus, System.String wsBillNumber, System.String wsExtra1, System.DateTime?wsDate, System.Int32?wsStatus, DbTransaction transaction) { Database db; string sqlCommand; DbCommand dbCommand; db = DatabaseFactory.CreateDatabase(); sqlCommand = "[dbo].gspTMSWatersupply_INSERT"; dbCommand = db.GetStoredProcCommand(sqlCommand, wsBillAmount, wsLateFees, wsMonth, wsYear, wsLastDate, wsBillPaidDate, wsTotalAmount, wsPaidStatus, wsBillNumber, wsExtra1, wsDate, wsStatus); if (transaction == null) { this.WsWsid = Convert.ToInt64(db.ExecuteScalar(dbCommand)); } else { this.WsWsid = Convert.ToInt64(db.ExecuteScalar(dbCommand, transaction)); } return; }
public void Insert(System.Double?elBillAmount, System.Double?elLateFees, System.String elMonth, System.String elYear, System.DateTime?elLastDate, System.DateTime?elBillPaidDate, System.Double?elTotalAmount, System.String elPaidStatus, System.String elbIllno, System.String elBillFile, System.String elExtra1, System.String elExtra2, System.DateTime?elDate, System.Int32?elStatus, DbTransaction transaction) { Database db; string sqlCommand; DbCommand dbCommand; db = DatabaseFactory.CreateDatabase(); sqlCommand = "[dbo].gspTMSElectricity_INSERT"; dbCommand = db.GetStoredProcCommand(sqlCommand, elBillAmount, elLateFees, elMonth, elYear, elLastDate, elBillPaidDate, elTotalAmount, elPaidStatus, elbIllno, elBillFile, elExtra1, elExtra2, elDate, elStatus); if (transaction == null) { this.ElEbillID = Convert.ToInt64(db.ExecuteScalar(dbCommand)); } else { this.ElEbillID = Convert.ToInt64(db.ExecuteScalar(dbCommand, transaction)); } return; }
public void Insert(System.String presentacion, System.Double?peso, DbTransaction transaction) { Database db; string sqlCommand; DbCommand dbCommand; db = DatabaseFactory.CreateDatabase(); sqlCommand = "[dbo].gspPresentaciones_INSERT"; dbCommand = db.GetStoredProcCommand(sqlCommand, presentacion, peso); if (transaction == null) { this.PresentacionID = Convert.ToInt32(db.ExecuteScalar(dbCommand)); } else { this.PresentacionID = Convert.ToInt32(db.ExecuteScalar(dbCommand, transaction)); } return; }
public static void Update(System.Int64?elEbillID, System.Double?elBillAmount, System.Double?elLateFees, System.String elMonth, System.String elYear, System.DateTime?elLastDate, System.DateTime?elBillPaidDate, System.Double?elTotalAmount, System.String elPaidStatus, System.String elbIllno, System.String elBillFile, System.String elExtra1, System.String elExtra2, System.DateTime?elDate, System.Int32?elStatus, DbTransaction transaction) { DataSet ds; Database db; string sqlCommand; DbCommand dbCommand; db = DatabaseFactory.CreateDatabase(); sqlCommand = "[dbo].gspTMSElectricity_UPDATE"; dbCommand = db.GetStoredProcCommand(sqlCommand); db.DiscoverParameters(dbCommand); dbCommand.Parameters["@elEbillID"].Value = elEbillID; dbCommand.Parameters["@elBillAmount"].Value = elBillAmount; dbCommand.Parameters["@elLateFees"].Value = elLateFees; dbCommand.Parameters["@elMonth"].Value = elMonth; dbCommand.Parameters["@elYear"].Value = elYear; dbCommand.Parameters["@elLastDate"].Value = elLastDate; dbCommand.Parameters["@elBillPaidDate"].Value = elBillPaidDate; dbCommand.Parameters["@elTotalAmount"].Value = elTotalAmount; dbCommand.Parameters["@elPaidStatus"].Value = elPaidStatus; dbCommand.Parameters["@elbIllno"].Value = elbIllno; dbCommand.Parameters["@elBillFile"].Value = elBillFile; dbCommand.Parameters["@elExtra1"].Value = elExtra1; dbCommand.Parameters["@elExtra2"].Value = elExtra2; dbCommand.Parameters["@elDate"].Value = elDate; dbCommand.Parameters["@elStatus"].Value = elStatus; if (transaction == null) { db.ExecuteNonQuery(dbCommand); } else { db.ExecuteNonQuery(dbCommand, transaction); } return; }
protected void MapFrom(DataRow dr) { SFPDetailsId = dr["SFP_DetailsId"] != DBNull.Value ? Convert.ToInt64(dr["SFP_DetailsId"]) : SFPDetailsId = null; SFPStudentLoginId = dr["SFP_StudentLoginId"] != DBNull.Value ? Convert.ToInt64(dr["SFP_StudentLoginId"]) : SFPStudentLoginId = null; SFPStandardId = dr["SFP_StandardId"] != DBNull.Value ? Convert.ToInt64(dr["SFP_StandardId"]) : SFPStandardId = null; SFPDivisionId = dr["SFP_DivisionId"] != DBNull.Value ? Convert.ToInt64(dr["SFP_DivisionId"]) : SFPDivisionId = null; SFPTotalFees = dr["SFP_TotalFees"] != DBNull.Value ? Convert.ToDouble(dr["SFP_TotalFees"]) : SFPTotalFees = null; SFTPaidFees = dr["SFT_PaidFees"] != DBNull.Value ? Convert.ToDouble(dr["SFT_PaidFees"]) : SFTPaidFees = null; SFPRemainingFees = dr["SFP_RemainingFees"] != DBNull.Value ? Convert.ToDouble(dr["SFP_RemainingFees"]) : SFPRemainingFees = null; SFPMonth = dr["SFP_Month"] != DBNull.Value ? Convert.ToString(dr["SFP_Month"]) : SFPMonth = null; SFPYear = dr["SFP_Year"] != DBNull.Value ? Convert.ToString(dr["SFP_Year"]) : SFPYear = null; SFPTransactionDate = dr["SFP_TransactionDate"] != DBNull.Value ? Convert.ToDateTime(dr["SFP_TransactionDate"]) : SFPTransactionDate = null; SFPAddedById = dr["SFP_AddedById"] != DBNull.Value ? Convert.ToInt64(dr["SFP_AddedById"]) : SFPAddedById = null; SFPAddedByRemark = dr["SFP_AddedByRemark"] != DBNull.Value ? Convert.ToString(dr["SFP_AddedByRemark"]) : SFPAddedByRemark = null; SFPOtherRemark = dr["SFP_OtherRemark"] != DBNull.Value ? Convert.ToString(dr["SFP_OtherRemark"]) : SFPOtherRemark = null; SFPDate = dr["SFP_Date"] != DBNull.Value ? Convert.ToDateTime(dr["SFP_Date"]) : SFPDate = null; SFPStatus = dr["SFP_Status"] != DBNull.Value ? Convert.ToInt32(dr["SFP_Status"]) : SFPStatus = null; }
public static object ConvertValue(object value, Field.FieldType toFieldType) { object convertedValue = null; try { switch (toFieldType) { case ESRI.ArcGIS.Client.Field.FieldType.Integer: case ESRI.ArcGIS.Client.Field.FieldType.OID: //typeof(System.Int32?); int intValue = Convert.ToInt32(value); convertedValue = new System.Int32?(intValue); break; case ESRI.ArcGIS.Client.Field.FieldType.SmallInteger: //typeof(System.Int16?); short shortValue = Convert.ToInt16(value); convertedValue = new System.Int16?(shortValue); break; case ESRI.ArcGIS.Client.Field.FieldType.Double: //typeof(System.Double?); double doubleValue = Convert.ToDouble(value); convertedValue = new System.Double?(doubleValue); break; case ESRI.ArcGIS.Client.Field.FieldType.Single: //typeof(System.Single?); float floatValue = Convert.ToSingle(value); convertedValue = new System.Single?(floatValue); break; case ESRI.ArcGIS.Client.Field.FieldType.String: case ESRI.ArcGIS.Client.Field.FieldType.GlobalID: case ESRI.ArcGIS.Client.Field.FieldType.GUID: case ESRI.ArcGIS.Client.Field.FieldType.XML: //typeof(System.String); string stringValue = Convert.ToString(value); convertedValue = stringValue; break; case ESRI.ArcGIS.Client.Field.FieldType.Date: //typeof(System.DateTime?); DateTime dateTimeValue = Convert.ToDateTime(value); convertedValue = new System.DateTime?(dateTimeValue); break; case ESRI.ArcGIS.Client.Field.FieldType.Geometry: case ESRI.ArcGIS.Client.Field.FieldType.Blob: case ESRI.ArcGIS.Client.Field.FieldType.Raster: case ESRI.ArcGIS.Client.Field.FieldType.Unknown: //typeof(System.Object); convertedValue = value; break; default: //typeof(System.Object); convertedValue = value; break; } } catch (Exception) { convertedValue = null; } return convertedValue; }