Exemplo n.º 1
0
    private static void WriteConsole(DataTable dataTable)
    {
        Console.WriteLine("Csv file:");
        Console.WriteLine();
        Console.WriteLine(File.ReadAllText(FILE_NAME));

        Console.WriteLine();
        Console.WriteLine("Content of the refilled DataTable:");

        foreach (DataRow?dataRow in dataTable.Rows)
        {
            if (dataRow is null)
            {
                continue;
            }

            const int padding = 15;

            for (int i = 0; i < dataTable.Columns.Count; i++)
            {
                object o = dataRow[i];
                Console.Write(o switch
                {
                    null => "<null>".PadRight(padding),
                    DBNull dBNull => "<DBNull>".PadRight(padding),
                    string s when s.Length == 0 => "\"\"".PadRight(padding),
                    TimeSpan ts => ts.ToString("g", CultureInfo.InvariantCulture).PadRight(padding),
                    _ => o.ToString()?.PadRight(padding)
                });
Exemplo n.º 2
0
        public void Update(Drazba drazba)
        {
            SqlConnection conn    = DatabaseConnection.GetInstance();
            SqlCommand    command = null;

            using (command = new SqlCommand("UPDATE drazba SET popis=@popis,drazbaBezi=@drazbaBezi,car_id=@car_id where id = @id", conn))
            {
                try
                {
                    command.Parameters.Add(new SqlParameter("@id", drazba.ID));
                    command.Parameters.Add(new SqlParameter("@popis", drazba.Popis));
                    int autoId = dao.GetID(drazba.drazeneAuto);
                    if (autoId == 0)
                    {
                        DBNull id = DBNull.Value;
                        command.Parameters.Add(new SqlParameter("@car_id", id));
                    }
                    else
                    {
                        int id = autoId;
                        command.Parameters.Add(new SqlParameter("@car_id", id));
                    }
                    command.Parameters.Add(new SqlParameter("@drazbaBezi", drazba.drazbaBezi));
                }
                catch (Exception err)
                {
                    Console.WriteLine(err.Message);
                }
                command.ExecuteNonQuery();
            }
        }
Exemplo n.º 3
0
 public literal(DBNull n, DbType CoerceType)
 {
     type      = DbType.Object;
     nullvalue = DBNull.Value;
     coerce    = CoerceType;
     size      = -1;
 }
Exemplo n.º 4
0
        // Delete the Otdelen by ID_Room.
        public int DeleteRecord(int ID_Manufacture, DBNull Parent_ID)
        {
            SqlConnection conn = new SqlConnection(_connectionString);
            SqlCommand    cmd  = new SqlCommand("DELETE FROM Manufacture WHERE ID_Manufacture = @ID_Manufacture", conn);

            cmd.Parameters.Add("@ID_Manufacture", SqlDbType.Int).Value = ID_Manufacture;
            int result = 0;

            try
            {
                conn.Open();

                result = cmd.ExecuteNonQuery();
            }
            catch (SqlException e)
            {
                // Handle exception.
            }
            finally
            {
                conn.Close();
            }

            return(result);
        }
 public static RdStaticArg BoxToServerStaticArg(object value)
 {
     if (value == null)
     {
         return(null);
     }
     return(value switch
     {
         sbyte x => new RdStaticArg(RdTypeName.@sbyte, x.ToString()),
         short x => new RdStaticArg(RdTypeName.@short, x.ToString()),
         int x => new RdStaticArg(RdTypeName.@int, x.ToString()),
         long x => new RdStaticArg(RdTypeName.@long, x.ToString()),
         byte x => new RdStaticArg(RdTypeName.@byte, x.ToString()),
         ushort x => new RdStaticArg(RdTypeName.@ushort, x.ToString()),
         uint x => new RdStaticArg(RdTypeName.@uint, x.ToString()),
         ulong x => new RdStaticArg(RdTypeName.@ulong, x.ToString()),
         decimal x => new RdStaticArg(RdTypeName.@decimal, x.ToString(CultureInfo.InvariantCulture)),
         float x => new RdStaticArg(RdTypeName.@float, x.ToString(CultureInfo.InvariantCulture)),
         double x => new RdStaticArg(RdTypeName.@double, x.ToString(CultureInfo.InvariantCulture)),
         char x => new RdStaticArg(RdTypeName.@char, x.ToString()),
         bool x => new RdStaticArg(RdTypeName.@bool, x.ToString()),
         string x => new RdStaticArg(RdTypeName.@string, x),
         DBNull _ => new RdStaticArg(RdTypeName.dbnull, ""),
         _ when value.GetType() is var type && type.IsEnum => BoxToServerStaticArg((int)value),
         _ => throw new ArgumentException($"Unexpected static arg with type {value.GetType().FullName}")
     });
Exemplo n.º 6
0
        public EquipmentRepairEntity(System.Data.DataTableReader dr)
        {
            this.pk_RepairID       = Convert.ToInt32(dr["pk_RepairID"]);
            this.ContainerNo       = Convert.ToString(dr["ContainerNo"]);
            this.Location          = Convert.ToString(dr["Location"]);
            this.Damaged           = Convert.ToBoolean(dr["Damaged"]);
            this.EstimateReference = Convert.ToString(dr["EstimateReference"]);
            this.fk_UserApproved   = Convert.ToInt32(dr["fk_UserApproved"]);

            this.Line            = Convert.ToString(dr["Line"]);
            this.RepMaterialAppr = Convert.ToDecimal(dr["MaterialAppr"]);
            this.RepMaterialEst  = Convert.ToDecimal(dr["MaterialEst"]);
            this.RepLabourEst    = Convert.ToDecimal(dr["LabourEst"]);
            this.onHold          = Convert.ToBoolean(dr["onHold"]);
            this.RealeasedOn     = DBNull.ReferenceEquals(dr["RealeasedOn"], DBNull.Value)? (Nullable <DateTime>)null:  Convert.ToDateTime(dr["RealeasedOn"]);
            this.NVOCCId         = Convert.ToInt32(dr["NVOCCID"]);
            this.Reason          = Convert.ToString(dr["Reason"]);
            this.RepLabourAppr   = Convert.ToDecimal(dr["RepLabourAppr"]);
            this.RepLabourBilled = Convert.ToDecimal(dr["RepLabourBilled"]);

            this.RepMaterialBilled = Convert.ToDecimal(dr["RepMaterialBilled"]);

            this.StockReturnDate = DBNull.ReferenceEquals(dr["StockReturnDate"], DBNull.Value) ? (Nullable <DateTime>)null : Convert.ToDateTime(dr["StockReturnDate"]);
            this.TransactionDate = DBNull.ReferenceEquals(dr["TransactionDate"], DBNull.Value) ? (Nullable <DateTime>)null : Convert.ToDateTime(dr["TransactionDate"]);
        }
Exemplo n.º 7
0
        public static string TypeValueToDbValueStatement(object?typeValue, bool quotedIfNeed, EngineType engineType)
        {
            if (typeValue == null)
            {
                return("null");
            }

            Type type = typeValue.GetType();
            EntityPropertyDef propertyDef = new EntityPropertyDef
            {
                Type = type,
                NullableUnderlyingType = Nullable.GetUnderlyingType(type),
                TypeConverter          = null
            };

            object dbValue = TypeValueToDbValue(typeValue, propertyDef, engineType);

            string statement = dbValue switch
            {
                //null => "null",
                //Enum e => e.ToString(),
                DBNull _ => "null",
                DateTime _ => throw Exceptions.UseDateTimeOffsetOnly(),
                      DateTimeOffset dt => dt.ToString(@"yyyy\-MM\-dd HH\:mm\:ss.FFFFFFFzzz", GlobalSettings.Culture),
                      bool b => b ? "1" : "0",
                      _ => dbValue.ToString() !
            };

            if (!quotedIfNeed || statement == "null" || !SqlHelper.IsValueNeedQuoted(dbValue !.GetType()))
            {
                return(statement);
            }

            return(SqlHelper.GetQuoted(statement));
        }
Exemplo n.º 8
0
        private void btnPost_Click(object sender, EventArgs e)
        {
            string Msg = "هل تريد بالتاكيد إعتماد جميع البطاقات المحددة؟";

            if (new Dialogs.Dg_ComfirmMessage("إعتماد", Msg).MessageResult() == DialogResult.Yes)
            {
                string EntryDocNo = string.Empty;
                for (int i = 0; i < dgv_Reception.Rows.Count; ++i)
                {
                    if (!DBNull.Equals(dgv_Reception["select", i].Value, null) &&
                        Boolean.Parse(dgv_Reception["select", i].Value.ToString()) == true)
                    {
                        EntryDocNo = dgv_Reception["Entry_doc_no", i].Value.ToString();
                        if (QuerySource == "pending")
                        {
                            Db.PostDlgReception(EntryDocNo, SharedParam.CurrentUser.UserID);
                        }
                        else
                        {
                            Db.PostReception(EntryDocNo, SharedParam.CurrentUser.UserID);
                        }
                    }
                }
                btn_Query_Click(sender, e);
            }
        }
Exemplo n.º 9
0
        public void Create(Drazba drazba)
        {
            SqlConnection conn    = DatabaseConnection.GetInstance();
            SqlCommand    command = null;

            using (command = new SqlCommand("INSERT INTO drazba(popis,drazbaBezi,car_id) VALUES (@popis,@drazbaBezi,@car_id)", conn))
            {
                int autoId = dao.GetID(drazba.drazeneAuto);
                if (autoId == 0)
                {
                    DBNull id = DBNull.Value;
                    command.Parameters.Add(new SqlParameter("@car_id", id));
                }
                else
                {
                    int id = autoId;
                    command.Parameters.Add(new SqlParameter("@car_id", id));
                }
                command.Parameters.Add(new SqlParameter("@popis", drazba.Popis));
                command.Parameters.Add(new SqlParameter("@drazbaBezi", drazba.drazbaBezi));
                command.ExecuteNonQuery();
                command.CommandText = "Select @@Identity";
                drazba.ID           = Convert.ToInt32(command.ExecuteScalar());
            }
        }
Exemplo n.º 10
0
        private void toolStripButton3_Click(object sender, EventArgs e)
        {
            if (grData.CurrentRow == null)
            {
                return;
            }

            bool rdism, rrem;

            if (DBNull.Equals(grData.CurrentRow.Cells["objDism"].Value, DBNull.Value))
            {
                rdism = false;
            }
            else
            {
                rdism = (bool)grData.CurrentRow.Cells["objDism"].Value;
            }

            if (DBNull.Equals(grData.CurrentRow.Cells["onRemont"].Value, DBNull.Value))
            {
                rrem = false;
            }
            else
            {
                rrem = (bool)grData.CurrentRow.Cells["onRemont"].Value;
            }


            if (rdism)
            {
                MessageBox.Show("Данное устройство снято с учета!", Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }

            if (rrem)
            {
                MessageBox.Show("Данное устройство уже в ремонте!", Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }

            if (MessageBox.Show("Отметить выбранное устройство как нуждающееся в ремонте?", Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question)
                == DialogResult.Yes)
            {
                SqlCommand cmd = new SqlCommand
                {
                    Connection  = new SqlConnection(Properties.Settings.Default.itInventorConnectionString),
                    CommandType = CommandType.StoredProcedure,
                    CommandText = "chkToRemont"
                };

                cmd.Parameters.AddWithValue("@obNo", (int)grData.CurrentRow.Cells["objNo"].Value);

                cmd.Connection.Open();
                cmd.ExecuteNonQuery();
                cmd.Connection.Close();

                int kod = (int)trPodr.SelectedNode.Tag;
                selOborudTableAdapter.Fill(selOborudDataSet.selOborud, kod);
            }
        }
Exemplo n.º 11
0
        public virtual void Test_Can_Convert_DBNull()
        {
            DBNull toConvert = DBNull.Value;
            StandardCLRConverter tConverter = new StandardCLRConverter();
            object result = tConverter.ConvertToType(toConvert, typeof(bool));

            Assert.IsNull(result);
        }
 public override LocalDate?Parse(object value)
 {
     return(value switch
     {
         DBNull _ => null,
         DateTime dateTime => LocalDateTime.FromDateTime(dateTime).Date,
         _ => throw new ArgumentException($"Cannot convert {value.GetType()} to {typeof(LocalDate?)}")
     });
Exemplo n.º 13
0
        public void DBNull()
        {
            DBNull     value   = System.DBNull.Value;
            Type       type    = value.GetType();
            XmlRpcType rpcType = XmlRpcTypeInfo.GetXmlRpcType(type);

            Assert.AreEqual(XmlRpcType.tStruct, rpcType, "GetXmlRpcType return DBNull as tStruct");
        }
Exemplo n.º 14
0
        public void DBNull()
        {
            DBNull     value   = System.DBNull.Value;
            Type       type    = value.GetType();
            XmlRpcType rpcType = XmlRpcServiceInfo.GetXmlRpcType(type);

            Assert.AreEqual(XmlRpcType.tInvalid, rpcType,
                            "GetXmlRpcType return DBNull as tInvalid");
        }
Exemplo n.º 15
0
 public override Instant?Parse(object value)
 {
     return(value switch
     {
         DBNull _ => null,
         DateTimeOffset dateTimeOffset => Instant.FromDateTimeOffset(dateTimeOffset),
         DateTime dateTime => Instant.FromDateTimeUtc(DateTime.SpecifyKind(dateTime, DateTimeKind.Utc)),
         _ => throw new ArgumentException($"Cannot convert {value.GetType()} to {typeof(Instant?)}")
     });
Exemplo n.º 16
0
        public static string ToString(this DBNull bNull, string resultStr)
        {
            if (DBNull.Value == null)
            {
                return(resultStr);
            }

            return("");
        }
Exemplo n.º 17
0
        public SqlParameter CrearParametro(string nombre, DBNull valor)
        {
            SqlParameter p = new SqlParameter();

            p.ParameterName = nombre;
            p.Value         = valor;
            p.SqlDbType     = SqlDbType.Int;
            return(p);
        }
 public override LocalTime?Parse(object value)
 {
     return(value switch
     {
         DBNull _ => null,
         TimeSpan timeSpan => LocalTime.FromTicksSinceMidnight(timeSpan.Ticks),
         DateTime dateTime => LocalTime.FromTicksSinceMidnight(dateTime.TimeOfDay.Ticks),
         _ => throw new ArgumentException($"Cannot convert {value.GetType()} to {typeof(LocalTime?)}")
     });
Exemplo n.º 19
0
        static void Main(string[] args)
        {
            DBNull dbNull = DBNull.Value;

            Console.WriteLine(typeof(string).IsAssignableFrom(typeof(DBNull))); //False
            Console.WriteLine(dbNull is string);                                //False
            //Console.WriteLine((string)dbNull);  // compile time error
            //Console.WriteLine(dbNull as string); // compile time error
            Console.ReadLine();
        }
Exemplo n.º 20
0
        public void TestingDBNull(DBNull init)
        {
            ResetBois();

            PrimitiveWriter.WriteValue(Writer, init);
            ResetStream();

            var final = PrimitiveReader.ReadDbNull(Reader);

            final.Should().Be(init);
        }
Exemplo n.º 21
0
 internal static void WriteValue(BinaryWriter writer, DBNull dbNull)
 {
     if (dbNull == null)
     {
         WriteNullValue(writer);
     }
     else
     {
         WriteValue(writer, true);
     }
 }
Exemplo n.º 22
0
        internal object GetConstantValue(bool raw)
        {
            object obj    = MdConstant.GetValue(this.GetRuntimeModule().MetadataImport, this.m_token, this.PropertyType.GetTypeHandleInternal(), raw);
            DBNull dbNull = DBNull.Value;

            if (obj != dbNull)
            {
                return(obj);
            }
            throw new InvalidOperationException(Environment.GetResourceString("Arg_EnumLitValueNotFound"));
        }
Exemplo n.º 23
0
        /// <summary>
        /// Convert value to bytes and place in ByteContent at correct location
        /// </summary>
        /// <param name="field">Column information for the conversion</param>
        /// <param name="dbNull"></param>
        public void SetColumn(Field field, DBNull dbNull)
        {
            var chars = new char[field.Length];

            for (var j = 0; j < field.Length; j++)
            {
                chars[j] = ' ';
            }
            Encoding.Default.GetBytes(chars, 0, chars.Length, ByteContent, field.DataAddress);
            Modified = true;
        }
Exemplo n.º 24
0
        public void IsTruthy_Check_DBNull()
        {
            // arrange
            DBNull value = DBNull.Value;

            // act
            bool result = Booleany.IsTruthy(value);

            // assert
            Assert.IsFalse(result);
        }
Exemplo n.º 25
0
        public void AgregarParametro(string p, DBNull dBNull)
        {
            Parametro parametro = new Parametro();

            parametro.AgregarParametro(p, dBNull);
            if (this.Lista == null)
            {
                this.Lista = new List <Parametro>();
            }
            this.Lista.Add(parametro);
        }
Exemplo n.º 26
0
        private object GetValue(bool raw)
        {
            object obj    = MdConstant.GetValue(this.GetRuntimeModule().MetadataImport, this.m_tkField, this.FieldType.GetTypeHandleInternal(), raw);
            DBNull dbNull = DBNull.Value;

            if (obj != dbNull)
            {
                return(obj);
            }
            throw new NotSupportedException(Environment.GetResourceString("Arg_EnumLitValueNotFound"));
        }
Exemplo n.º 27
0
 /// <summary>檢查DataColumn是否是空值(預設 DBNull.Value 回傳 = "")</summary>
 /// <param name="pDr">資料列</param>
 /// <param name="columnName">DataColumn名稱</param>
 ///  /// <param name="returnStr">預設(DBNull.Value 回傳 = "")</param>
 /// <returns>string</returns>
 public string checkDataColumn(DataRow pDr, string columnName, string returnStr = "")
 {
     if (!DBNull.ReferenceEquals(pDr[columnName], DBNull.Value))
     {
         string columnStr = pDr[columnName].ToString().Trim();
         if (columnStr != "")
         {
             returnStr = columnStr;
         }
     }
     return(returnStr);
 }
Exemplo n.º 28
0
 private void btn_inverseSelect_Click(object sender, EventArgs e)
 {
     for (int i = 0; i < dgv_Reception.Rows.Count; ++i)
     {
         if (DBNull.Equals(dgv_Reception["select", i].Value, null) ||
             Boolean.Parse(dgv_Reception["select", i].Value.ToString()) == true)
         {
             dgv_Reception["select", i].Value = false;
         }
         else
         {
             dgv_Reception["select", i].Value = true;
         }
     }
 }
Exemplo n.º 29
0
        public void ReadScalerDbNullReturnsNullObject()
        {
            DBNull scalerReturn = DBNull.Value;

            MockDatabaseFactory.SetScalerReturnValue(scalerReturn);
            var query       = new SQLQueryScaler <string>(sqlString);
            var returnValue = queryHelper.RunScalerQuery <string>(query);

            Assert.IsNull(returnValue);
            VerifyLogging(sqlString);
            Assert.AreEqual(sqlString, MockDatabaseFactory.DbCommand.Object.CommandText);
            MockDatabaseFactory.DbConnection.VerifySet(dbc => dbc.ConnectionString = connectionString, Times.Exactly(1));
            MockDatabaseFactory.DbConnection.Verify(dbc => dbc.Open(), Times.Exactly(1));
            MockDatabaseFactory.DbConnection.Verify(dbc => dbc.Close(), Times.Exactly(1));
            MockDatabaseFactory.DbCommand.Verify(dbc => dbc.ExecuteScalarAsync(It.IsAny <System.Threading.CancellationToken>()), Times.Exactly(1));
        }
Exemplo n.º 30
0
            public ActionResult Edit(User user)
            {
                if (ModelState.IsValid)

                {
                    using (var db = new DBNull())
                    {
                        User oldUser = db.Users.Find(user.Id);

                        oldUser.Firstname = user.FirstName;
                        oldUser.LastName  = user.Last.Name;

                        db.SaveChanges();
                    }
                }
                return(View(user));
            }
#pragma warning restore 618

        // Allow internal extenders to avoid creating the hashtable/arraylist.
        internal NameValueCollection(DBNull dummy) : base(dummy)
        {
        }
Exemplo n.º 32
0
 /// <summary>
 /// Writes a 'null' text as a value.
 /// It requires to be put inside an object.
 /// </summary>
 public void WriteMember(string name, DBNull value)
 {
     WriteMemberInternal(name, JSonReader.NullString, false);
 }
 // Allow internal extenders to avoid creating the hashtable/arraylist.
 internal NameObjectCollectionBase(DBNull dummy)
 {
 }
Exemplo n.º 34
0
 /// <summary>
 /// Writes a 'null' value.
 /// It can be used only as an array element or value for object member.
 /// </summary>
 public void WriteValue(DBNull value)
 {
     WriteValueInternal(JSonReader.NullString, false);
 }
Exemplo n.º 35
0
 static DBNull()
 {
     Value = new DBNull();
 }
Exemplo n.º 36
0
 public void WriteValue(DBNull value)
 {
     throw new NotImplementedException();
 }
Exemplo n.º 37
0
 public bool IsEmpty(DBNull x)
 {
     return false;
 }
Exemplo n.º 38
0
 public void WriteMember(string name, DBNull value)
 {
     throw new NotImplementedException();
 }
Exemplo n.º 39
0
 /*public void Add(string parameter, Guid value)
 {
     Add(new OracleParameter(parameter, OracleDbType.)).Value = value;
 }*/
 public override void Add(string parameter, DBNull value)
 {
     Add(new OracleParameter(parameter, DBNull.Value)).Value = value;
 }
Exemplo n.º 40
0
        public Table(string fileName)
        {
            string[] lines = File.ReadAllLines(fileName);
              List<Value[]> table = new List<Value[]>(lines.Length);
              for (int i = 0; i < lines.Length; i++)
              {
            string[] columns = lines[i].Split(',');
            Value[] values = new Value[columns.Length];
            for (int j = 0; j < columns.Length; j++)
            {
              string cell = columns[j].Where(x => x != ' ' && x != '\t').Aggregate("", (x, y) => x + y);
              int intValue;
              double realValue;

              if (Int32.TryParse(cell, out intValue))
            values[j] = new DBInteger(intValue);
              else if (Double.TryParse(cell, out realValue))
            values[j] = new DBReal(realValue);
              else if (cell == "NULL")
            values[j] = new DBNull();
              else
            values[j] = new DBString(cell);
            }
            table.Add(values);
              }
              Rows = table;
        }