Пример #1
0
 public Credit Add(Credit Model)
 {
     using (SqlCommand command = Connection.CreateCommand())
     {
         command.CommandText = "INSERT INTO Credit(Description) VALUES(@Description);SELECT @@IDENTITY;";
         command.CommandType = CommandType.Text;
         command.Parameters.Add("@Description", SqlDbType.VarChar, 50).Value = Model.Description;
         Model.CreditId = int.Parse(command.ExecuteScalar().ToString());
     }
     return Model;
 }
Пример #2
0
        public bool Edit(Credit Model)
        {
            bool _return = false;

            using (SqlCommand command = Connection.CreateCommand())
            {
                command.CommandText = "UPDATE Credit SET Description=@Description WHERE CreditId=@CreditId";
                command.CommandType = CommandType.Text;
                command.Parameters.Add("@Description", SqlDbType.VarChar, 50).Value = Model.Description;
                command.Parameters.Add("@CreditId", SqlDbType.Int).Value = Model.CreditId;
                _return = (command.ExecuteNonQuery() > 0);
            }

            return _return;
            
        }
Пример #3
0
        public Credit Find(params object[] Keys)
        {
            Credit credit = null;

            using (SqlCommand command = Connection.CreateCommand())
            {
                command.CommandText = "SELECT CreditId, Description FROM Credit WHERE CreditId=@CreditId";
                command.CommandType = CommandType.Text;
                command.Parameters.Add("@CreditId", SqlDbType.Int).Value = Keys[0];
                using (SqlDataReader reader = command.ExecuteReader())
                {
                    reader.Read();
                    credit = new Credit(reader.GetInt32(0), reader.GetString(1));
                }
            }

            return credit;
        }
Пример #4
0
 public bool Remove(Credit Model)
 {
     return Remove(Model.CreditId);
 }