Esempio n. 1
0
        public Int32 Save(SysTerminalKeyDetails Details)
        {
            try
            {
                string SQL = "CALL procSaveSysTerminalKey(@HDSerialNo, @RegistrationKey, @CreatedOn, @LastModified);";

                MySqlCommand cmd = new MySqlCommand();
                cmd.CommandType = System.Data.CommandType.Text;
                cmd.CommandText = SQL;

                cmd.Parameters.AddWithValue("HDSerialNo", Details.HDSerialNo);
                cmd.Parameters.AddWithValue("RegistrationKey", Details.RegistrationKey);
                cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn);
                cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified);

                return(base.ExecuteNonQuery(cmd));
            }

            catch (Exception ex)
            {
                throw base.ThrowException(ex);
            }
        }
Esempio n. 2
0
        public Int32 Save(SysTerminalKeyDetails Details)
        {
            try
            {
                string SQL = "CALL procSaveSysTerminalKey(@HDSerialNo, @RegistrationKey, @CreatedOn, @LastModified);";

                MySqlCommand cmd = new MySqlCommand();
                cmd.CommandType = System.Data.CommandType.Text;
                cmd.CommandText = SQL;

                cmd.Parameters.AddWithValue("HDSerialNo", Details.HDSerialNo);
                cmd.Parameters.AddWithValue("RegistrationKey", Details.RegistrationKey);
                cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn);
                cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified);

                return base.ExecuteNonQuery(cmd);
            }

            catch (Exception ex)
            {
                throw base.ThrowException(ex);
            }	
        }